We have two machines (that I know of so far) that since we restarted our server a couple of days ago are giving the following error on trying to establish an ODBC connection to the SQL Server:
SQL State: ÃƒÂ¢Ã‚Â€Ã‚Â˜01000ÃƒÂ¢Ã‚Â€Ã‚Â™
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect())
SQL State: ÃƒÂ¢Ã‚Â€Ã‚Â˜08001ÃƒÂ¢Ã‚Â€Ã‚Â™
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied."
Both machines had no problems connecting to the server previously and there are a number of other machines that still happily connect. No changes have been made to software or hardware on the two machines either. Any ideas how to fix the problem?