Login failed for user ''. Reason: Not associated with a trusted SQL Server connection.

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
CochiseCountyAsked:
Who is Participating?
 
thirdConnect With a Mentor Commented:
when connecting from internet, you need to update the datasource to the public url/ip of your server.
0
 
kevp75Commented:
did you make sure to add that user to the second database?
0
 
CochiseCountyAuthor Commented:
i added the user Testuser, it shows up under Logins
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
CochiseCountyAuthor Commented:
when I run sp_helpuser, the user Testuser also shows up
0
 
CochiseCountyAuthor Commented:
i tried all that, I am using SQL Server login anf had the SQL Server and Windows checked. Still not working
0
 
CochiseCountyAuthor Commented:
One more thing, I have SQL server 2000 SP4 installed on my server, not sure if this causes the problem
0
 
thirdCommented:
Are you sure you are pointing to the correct datasource? Do you have multiple instance of SQL Server installed? Have you tried integrated security instead (just for testing)?
0
 
CochiseCountyAuthor Commented:
I think there are some inconsistencies in the Log on user account...
When I checked the Security in the SQL Server Properties, under Startup service account, I saw 'System  account' checked, so I ask the network guy to change it 'This account', so he changed it to a domain account with a password. But my connection string still gives me the same error message
Now, when I go to the Services, I saw the service MSSQLSERVER, under Log On, it uses the same domain accout as in the Security, but the service SQLSERVERAGENT, under Log on, the Local System account is checked, I am not sure if this causes the problem. I already emailed the network guy again to ask him to use the same domain account as using with the MSSQLSERVER and the Security. After he does that, I will check to see if my connection string work and let you know. Thanks for your help
0
 
CochiseCountyAuthor Commented:
OK, the network guy reinstalled the SQL Server 2000 with SP4, my connection string now works fine with the Intranet sites, but not the Internet, the error message I am getting now is
SQL server does not exists or access denied
0
 
CochiseCountyAuthor Commented:
How do I do that? thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.