TIP: How to access SQL Server Developer edition over a network

Posted on March 1, 2008. Filed under: Tip |

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 >

Select the SQL Server Surface Area Configuration

Run it up and choose the configuration for Services and Connections

SQL Server Surface Area Configuration  Choose the Remote option tab

SQL Server Surface Area Configuration

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…


Make a Comment

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: