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
Server Error 17 = SQL Server does not exist.
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
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