Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Login failed for user

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-19 : 10:30:59
Nancy writes "I'm using SQL Server 2000 (no service packs) under WIN2K Advanced Server (service pack 2).
ConnectionString is "Provider=sqloledb; Data Source=server; Initial catalog=database; User ID=administrator; Password=password;"
Under the security folder of the server, and under the logins folder, server name\Administrator is listed as a permitted user.

Error message: Login failed for user 'administrator'. Reason: Not associated with a trusted SQL server connection.
I'm using Windows authentication."
   

- Advertisement -