none
SQL Server Error 5 and 17

    Question

  • Hello! I had a server crash yesterday and I recovered my core server, but had to reinstall over SQL. The data was intact and I quickly set up the server. The problem I am now having is that our main system application can connect to the SQL Server in some PCs (example... "DBNAMEPC") while others I've had to input the IP of the SQL machine so they could login. Obviously this has broken some additional programs that depend on calling the SQL Server Name directly. I am having two major errors whenever I try to setup ODBC:

    Error 5. SQL STATE = 08001

    and

    Server Error 17 = SQL Server does not exist.

    Image: http://i.imgur.com/VY8Oz0O.jpg

    This is using the very same setup used before, same server name, same DB, etc. I just can't get some clients to connect. TCP/IP and Named Pipes are enabled, Windows Firewall is OFF and even then I set up the 1433 port inbound/outbound rules.



    • Edited by Lord Relix Thursday, November 21, 2013 6:06 PM
    Thursday, November 21, 2013 6:04 PM

Answers

  • Fixed. Apparently I forgot to fully Enable (it was Active) the IP for the server under SQL Network Configuration and under TCP/IP. Such a headache. Thanks to those that replied
    • Marked as answer by Lord Relix Thursday, November 21, 2013 7:58 PM
    Thursday, November 21, 2013 7:58 PM

All replies

  • is this screen capture from client machine; is that client machine able to reach system using host-names using dns service

    on client machines where it is working are any settings different from where is not working etc. machine domain membership, dns server etc


    Sarfraz Ali

    Thursday, November 21, 2013 6:19 PM
  • Not at all. Same settings as they were before. In fact, I can access the server from the clients with a ping. I flushed and registered DNS again just in case as well.
    Thursday, November 21, 2013 6:26 PM
  • Fixed. Apparently I forgot to fully Enable (it was Active) the IP for the server under SQL Network Configuration and under TCP/IP. Such a headache. Thanks to those that replied
    • Marked as answer by Lord Relix Thursday, November 21, 2013 7:58 PM
    Thursday, November 21, 2013 7:58 PM