How to Enable Remote Connections in SQL Server 2005

First time when I tried to make remote connection, I got this error message.

“An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection …?”

By default, SQL Server 2005 doesn’t allow remote connection so you have to enable it manually. If you try to connect to remote SQL Server without enable remote connection first. This is a security precautions that prevents other computers from connection to this instance of SQL Server before it has been properly secured. If you have seccessfully installed SQL Server 2005 and you want to allow other computers to be able to access your instance of database then you have to be enable remote connection in your system.

Here we go step by step, how to do enable remote connection.

  1. Use Surface Area Configuration Tool to enable remote connetion. See in snapshot how?

    What is Surface Area Configuration Tool?

    Microsoft SQL Server 2005 selectively installs and starts key services and features. This helps reduce the attackable surface area of a system. In the default configuration of new installations, many features are not enabled. A system administrator can change these defaults at installation time and also selectively enable or disable features of a running instance of SQL Server 2005.

    image11

  2. Now click on the Surface Area Configuration for Services and Connections.

    pic2

  3. Now click on SQLEXPRESS/Database Engine/RemoteConnections/ or MSSQLSERVER.
  4. Now enable Local and remote connections.
    pic3

Hope it will help.

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