SQL localhost connection problem

willem67
willem67 New Altair Community Member
edited November 5 in Community Q&A
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?
Tagged:

Answers

  • B_
    B_ New Altair Community Member
    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
    el_chief New Altair Community Member
    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
    willem67 New Altair Community Member
    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
    knightsy New Altair Community Member
    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  :)

Categories