Enabling Remote Connections to SQL Server Express

By default, SQL Server Express will only allow connecting from a local client.  To enable remote connections, there are two settings to change:

1) First, select the properties of the SQL Server Express instance within Microsoft SQL Server Management Studio and make sure that "allow remote connections to this server is checked".



2) Now open the SQL Server Surface Area Configuration tool and change the remote connections to allow both local and remote connections.



posted on Thursday, October 13, 2005 11:08 AM by AlanL

Comments

# re: Enabling Remote Connections to SQL Server Express

I don't think step #1 is necessary.. I just did step #2 and step #1 was already performed for me!
Thursday, October 13, 2005 2:25 PM by Jeff Atwood

# Its not working for me man..

i didnt find how to perform the first step..i performed the second step given here but still its not working for me.. plz help..
Saturday, March 11, 2006 11:35 PM by Hiren