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.
- 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.
- Now click on the Surface Area Configuration for Services and Connections.
- Now click on SQLEXPRESS/Database Engine/RemoteConnections/ or MSSQLSERVER.
- Now enable Local and remote connections.
Hope it will help.