Login failed for user ''. Reason: Not associated with a trusted SQL Server connection.
Posted on 2007-10-19
I have been working with classic ASP for a long time and here is how I create the connection string
From the database Security, Logins, I create a new user name like 'Testuser' and use SQL authenticate and enter the password like 'test'. Then on the global.asa page, I create a connectiong string like this
Application("Agenda_ConnectionString") = "DRIVER=SQL Server;SERVER=TestServer;UID=Testuser;DATABASE=Meeting;Pwd=test;"
Application("Agenda_ConnectionTimeout") = 15
Application("Agenda_CommandTimeout") = 30
Application("Agenda_CursorLocation") = 3
Application("Agenda_RuntimeUserName") = "Testuser"
Application("Agenda_RuntimePassword") = "test"
I have a new sql database and I follow the same procedure to create the connection string, but this time I keep getting the error message
Login failed for user 'Testuser'. Reason: Not associated with a trusted SQL Server connection.
Please help. Thanks