The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

SQL localhost connection problem

willem67willem67 Member Posts: 2 Contributor I
edited September 2019 in Help
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_ Member Posts: 70 Maven
    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_chiefel_chief Member Posts: 63 Contributor II
    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


  • willem67willem67 Member Posts: 2 Contributor I
    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.
  • knightsyknightsy Member Posts: 3 Contributor I
    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  :)
Sign In or Register to comment.