ODBC error connecting to SQL Server 2005 database on remote machine
Posted on 2007-10-18
I'm having a problem when adding a DSN via ODBC to connect to a SQL Server 2005 database. The exact error is:
SQL Server Error: 233
[Microsoft][ODBC SQL Server Driver][DBNETLIB] ConnectionOpen(Connect()).
SQL State: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied.
I have variously tried checking the Client Configuration is set to TCP/IP and that the username/password pair is correct (I set up these ODBC connections quite often and it's usually very simple). Setting up the ODBC from the Server itself machine is fine.
Having looked at various similar problems that people are having a lot of the Q's on EE for this particular problem just get left hanging in mid-air or just abandoned.
I really need to sort this out quickly and am at the 'tearing my hair out' stage. You may have to walk me through it step by step....but if it gets solved this may be the one appropriate answer to this quite common question here on EE!
Thanks in advance