SQL localhost connection problem

Question

I'm having a problem connecting to a local database in SQL Server 2008. When connecting to a remote database on another machine it connects fine, but when I try to connect to the same database on my local machine it does not want to connect and give me an error saying:

Database error occurred: Network error IOException: Connection refused: connect.

Has anyone experienced this problem or have any suggestions?

knightsy · Answer

B.  wrote:
1.   Make sure TCP is on

start > programs > sqlserver 2008 > configuration tools > sql config manager, protocols for mssqlserver, enable TCP/IP

I was having the exact same issue and this fixed the problem  :)

willem67 · Answer

Thanks for the quick replies guys

I'm using SQL Server Management Studio. Connections from other applications works fine. Also TCP/IP protocol is turned on. What baffles me the most is that I can connect fine whenever the database is on the network. Its just irritating cause I cannot figure it out.

el_chief · Answer

willem,

1. are you able to connect with other tools? such as SQL Server Management Studio?

2. Make sure that SQL Server Browser service is running