I have 12 workstations in the network and all but one can connect to my SQLEXPRESS instance. When I try to create a DSN in the ODBC tool I get the following error.
Connection Failed
SQLState ‘01000’
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Socket]ConnectionOpen(Connect())
Connection Failed
SQLState ‘08001’
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Socket]Specified SQL Server not found
Due to the fact that all of the other workstations are capable of connecting and interacting with the SQL server I am certain that I have a client problem. The problem workstation is able to read/write to the host that is running SQLEXPRESS, but, I can connect to the SQLEXPRESS. There are no firewalls active on either host (workstation or SQL Host) and they are all in the same subnet i.e., 192.168.35.0 network.
Please help
Ron
