We are currently in the process of testing our Webserver migration to Win 2000 and came across a problem while setting up a ODBC dataserver connection to the SQL database on USAWDB1. When I try to setup the connection on WWWBOXSTER2 its giving the error message "Login failed reason: Not associated with a trusted SQL server connection" . Please advise
One of two things is going on. Either SQL 2000 was installed to accept only Windows Authenticated connections (default), or the ODBC is trying to use a Trusted connection to the database (also default).
The first can be fixed by going to the properties of the sql server in enterprise manager. The second can be fixed by selecting the right radio button on the login screen.
Are you using windows authentification or sql server authentification in your odbc connection ? Check to see if you sql server is using windows only or mixed authentification ... In enterprise manager, right click the server and select properties -> security ...