Have a workstation1 with MSSQL Server 2008 installed running a piece of software.
There is another workstation2 that connects to the database stored on the WS1. This has been working for months.
Now when WS2 tried to launch the software that connects to the DB on WS1, we get the following SQL error:
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
The firewall on WS1 has been turned off. Ports 1433 have been opened on WS2. I have checked the priority on the SQL Configuration Manager for the protocols and TCP/IP is set higher. Have even tried disabling Named Pipes as well.
Still cannot get WS2 to start the program and connect ot the DB on WS1