ASP.NET: Error "Login failed for user 'sa'."

[Tony]

Dear all,

When running the program, I recieved the following error

"Exception Details: System.Data.SqlClient.SqlException: Login failed for
user 'sa'."

In web.config file, the connection setting is below:
"
<appSettings>
<add key="PubsString" value="workstation
id='sha-tongl-xp1';uid=sa;pwd='';server=localhost;initial
catalog='Pubs'"></add>
</appSettings>
"
Any help will be highly appreciated.



-Tony

 

[Scott M.]

You are not providing the correct logon parameters for your copy of SQL.

 

[Tony]

The program work well yesterday. It does not work well this morning, I have
not changed anything.

What do you means by "logon parameters for your copy of SQL"?

Thank you very much for your help.

 

[Guest]

Dear Tony,

They might have changed the password for 'sa'.

Try accesssing the databse through query analyzer. whether you are able to retrive table data.

if you are able to login with the sa username and blank password, then there is some problem, we need to analyze.

write back.

 

[Tony]

I reinstall Sql Server and the issue does not occur again. So i think the
problem is caused by the Sql Server side.

Thank you for your help!

Dear Tony,

They might have changed the password for 'sa'.

Try accesssing the databse through query analyzer. whether you are able to retrive table data.

if you are able to login with the sa username and blank password, then

there is some problem, we need to analyze.