Skip to main content

AddToAny

Share/Save

SQL Server 2005 error 10061

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

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr><br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong><font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption>
  • You can enable syntax highlighting of source code with the following tags: <c>, <cpp>, <csharp>, <drupal5>, <drupal6>, <java>, <javascript>, <mysql>, <php>, <python>, <ruby>, <sql>, <tsql>, <vbnet>, <xml>. Beside the tag style "<foo>" it is also possible to use "[foo]". PHP source code can also be enclosed in <?php ... ?> or <% ... %>.
  • Lines and paragraphs break automatically.

More information about formatting options