Id be grateful if anyone could help on this very complicated problem
I am trying to connect to a new sql2000 server running windows 2k on a different doamin
The set up
All clients are running Windows NT and are on domain one
I have tried to connect via odbc to this new server and it fails if i point to a server on the existing domain which is running SQL 6.5 it fails. I sign on to the same domain as the other clients, the really strange thing is that it will connect fine from my workstation to the new server on the new domain. I do have a lot of software installed on my work station.
The server is running windows 2000 with sql 2000 (standard) - The security within SQ2000 is set to SQL database security
The error I get is
SQL Server Error :1326
Microsoft ODBC SQLserver Driver ........
SQL State '08001'
SQL Server Error 1326
Client unable to establish connection