I needed to connect to sql server from a remote computer which is on my home lan.
But got this error message.
Error:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, the failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: TCP Provider error: 0 – No connection could be made because the
target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
After googling a lot, I got what the problem was. I had to allow remote connection in Surface Area Configuration which by default doesn't allow remote connections.
Click Start > All Programs > SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration.
Select Option “Surface Area Configuration for services and connection“.
Select the sql server component (i.e. database server name eg sqlexpress*) for which you want to allow remote connection.
sqlexpress doen't connects in LAN. It is meant to be used only on one system not on network.
To configure remote connection...
Select “remote connection“, you will now be able to see the settings for this instance. If you want to allow remote connections. Then Select “Local and Remote Connections” Then “Using both TCP/IP and Named Pipes” then Apply.
Restart the Sql Server Service, To restart...
Click Start > Run > Type “Services.msc” > Right Click on your SQL Server Instance > Restart the service.
Now your SQL Server is ready to accept the remote connections.
Error that usually occurs while running it on network
This link gives rest of the process of configuring network connection
http://www.techpint.com/programming/error-26-%E2%80%93-error-locating-se...
Post new comment