I needed to connect to sql server from a remote computer which is on my home lan.
But got this error message.

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 some googling I understand what was the problem. I have to allow remote connection in Surface Area Configuration.

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 for which you want to allow 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

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.

ShareTweet about this on TwitterShare on LinkedInShare on Google+Share on RedditShare on StumbleUponShare on FacebookEmail this to someone
SQL Server 2005 error 10061
Tagged on:         

3 thoughts on “SQL Server 2005 error 10061

  • April 27, 2009 at 10:51 am

    i have cange it so it alows romote connections and insured that my firewall allow the port but we are still getting this error when trying to connect a second comp the the main sql db.

    help me plz


  • April 28, 2009 at 9:45 am

    Thanks, we figured it out, it was IIS (firewall) blocking one of the ports that was needed. It didnt just like us allowing the default, it wanted about 4 others as well. DAM computers lol.

Leave a Reply

Your email address will not be published. Required fields are marked *