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)  connection problem

Author  Topic  ntflores Starting Member 1 Post Posted - 2001-06-18 : 06:27:19 OS: WIN2K Advanced Server with Server Pack 2 Back-end: SQL Server 2000 ConnectionString used in ASP scripts: "Provider=sqloledb; Data Source=server; Initial catalog=database; User ID=sa; Password=;" Error message received: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. By the way, I'm using Windows authentication. Under the security folder of the SQL server, sa is specified as a Windows User with Permit server access.