Solution for MSSQL Network error IOException: Connection refused: connect
Posted by: tanner alf
Date: October 17, 2007 07:08PM

Network error IOException: Connection refused: connect
Enable TCP/IP protocol in SQL Server.

In SQL Server 2000 TCP/IP is set as follows:
Start the SQL Server Network Utility with the application C:/Program Files/Microsoft SQL Server/80/Tools/Binn/SVRNETCN.exe. Select the TCP/IP protocol and transfer the selection to the Enabled protocols frame. Select the Apply button. Select the OK button. Restart the MSSQLSERVER service in Administrative Tools>Services.

In SQL Server 2005 TCP/IP is set as follows:
Select Microsoft SQL Server 2005>Configuration Tools>SQL Server Configuration Manager. In the SQL Server Configuration Manager select the node SQL Server 2005 Network Configuration>Protocols for SQLEXPRESS. Right-click on the TCP/IP node and select Enable. Restart the SQL Server (SQLEXPRESS) service. Right-click on the SQL Server (SQLEXPRESS) service in Services and select Restart.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.