Remote connections SQL 2008 (express) default disabled

By default you cannot make a remote connection to a SQL 2008 (express) instance. To enable this you have to make the following changes:

Start the SQL 2008 Server Configuration Manager
Set at SQL Server Services the SQL Server Browser to automatic and start the service

SQL 2008 Remote Connections

Then go to SQL Server Network Configuration and then Protocols for Instance

SQL 2008 Remote Connections

By default TCP/IP and Named Pipes are disabled, enable the services you need for remote connection. You have to set these settings for every instance you want to remotely connect to.

Now you have to restart the SQL Server Services for all changed instances.

Posted in Blog, SQL 2008 at July 26th, 2010. 1 Comment.

Sharing Buttons by Linksku