This one has caught out people for ages, so I thought I'd clarify that it IS possible to connect to SQL Server 2005 Developer edition over a network.
The problem is that the Express and Developer versions of SQL Server 2005 turn OFF remote access by default (Standard and Enterprise have it ON by default). That's why out-of-the-box you can't connect over a network to it. But it's easy to turn on.
Now, you might think that using the SQL Server Configuration Manager is where it all happens. Turns out you need to use the SQL Server Surface Area Configuration tool.
It should be available from:
Microsoft SQL Server 2005 > Configuration Tools >
Run it up and choose the configuration for Services and Connections
Choose the Remote option tab
and make sure you've allowed both Local and Remote connections.
Note: This works with SQL Server 2005. If you are playing with SQL Server 2008 CTPx then you'll have discovered that the Surface Area Configuration tool is no longer available. I'll update you on that front when I've investigated further...
4 comments:
It's funny you point the Surfaces thing out. I had tested different releases of SQL Server 2008 and in the last couple of releases, they seemed to have removed that. It's only important to me now because I could get connections from other PCs on my network before they removed it from my view. Now I can't figure out how to get a connection on the latest pre-RTM version. So, I figured I don't have any more time to waste and have scuttled my SQL Server 2008 testing.
Hi Carl,
Yeah it seems strange to take it out. I'm assuming they have enabled the controls elsewhere - but like you haven't had the time to investigate further as yet.
Cheers,
Craig
For SQL 2008: Start > Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager
From the Manager goto the Network Configuration and Enable Protocols TCP/IP and Named Pipes
That Easy!
Cheers,
Brad
Well, yes but that doesn't seem to be enough to do the trick. I've been wrestling with this for the last few days and can't find any other settings anywhere to get remote connections to the Sql Express 2008 RC0. If anyone knows anything, please let me know.
Post a Comment