SQL localhost connection problem

[willem67]

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?

[B.]

1.   Make sure TCP is on

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

2. find el chief's sql setup tutorial on youtube (vancouver data)

[Neil McGuigan]

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

[willem67]

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.

[knightsy]

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