Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

SQL localhost connection problem

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?

Find more posts tagged with

AI Studio

Errors

SQL

Accepted answers

All comments

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)

el_chief

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

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