Error message "Login failed for user"

[jayy66]

I have a webservice set up that is suppose to access sql server and return a dataset, however, i keep getting the error message below:

"Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]"


The same code works fine in a windows application. The connection string contains the username and password and i even have <identity impersonate="true"/> listed in the web.config file.

Can anyone help me get around this??

I read about adding ASP.NET as a user in enterprise manager but i have no idea on how to do this.

Thanks

 

[SQLDenis]

You have windows only authentication

2000-->

http://sqlservercode.blogspot.com/2006/01/login-failed-for-user-sa-reason-not.html

2005-->

http://sqlservercode.blogspot.com/2006/02/login-failed-for-user-sa-reason-not.html

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jayy66]

Thanks for the reply but I've checked that already and it is already set to SQL Server and Windows mode. By the way, i'm using 2000.

 

[Catadmin]

Silly as it sounds, try resetting the password in SQL Server for that particular account. We've run into that problem recently where that's all we needed to do to get it working again.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"