954,560 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Web.config error in ASP.NET with SQL Server 2005

Hello Everyone,

I have developed an application for website using ASP.NET and SQL Server 2005. Recently I have uploaded it to server, but after uploading its showing the following error message -

Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

I wrote following connection string in web.config file-

Is there anything wrong with the connection string?

Please help me out

Sinha's
Light Poster
37 posts since Apr 2006
Reputation Points: 10
Solved Threads: 0
 

You can check the following article about this error:
http://support.microsoft.com/kb/555332

Thanks.

catherine sea
Junior Poster
126 posts since Jan 2008
Reputation Points: 25
Solved Threads: 20
 

Hello Catherine,

When I run the application in my local computer it was ok. I am getting the error after uploading it to the server.

Sinha's
Light Poster
37 posts since Apr 2006
Reputation Points: 10
Solved Threads: 0
 

Which authentication mode do you use?If you are using Windows Authentication, please change it to mixed mode and try again.

catherine sea
Junior Poster
126 posts since Jan 2008
Reputation Points: 25
Solved Threads: 20
 
Which authentication mode do you use?If you are using Windows Authentication, please change it to mixed mode and try again.

Thanx a lot for your reply. I had solved it with following connectionstring setting-

Sinha's
Light Poster
37 posts since Apr 2006
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: