SQL Server Express – Enable Remote Connections

SQL Server Express Remote Connection:
To enable remote connections on a SQL Server Express instance:

 1) Start SQL Server Configuration Manager(Start => Programs => SQL Server => Configuration Tools => SQL Server Configuration Manager.
 2) Start SQL Server Browser service (May want to set to start automatically)
 3) Left window, select SQL Server Network Configuration, then Protocols for [InstanceName]
 4) Enable TCP\IP
 5) Restart SQL Service

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: