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

[Craig Deelsnyder]

Tony wrote:

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

just like it says, password is incorrect for user sa in your local
database. Try logging into SQL Server thru Enterprise Manager w/ the
credentials you have here and see if it works....

I don't think you need quotes around any of the values either (unless
maybe for values w/ spaces). Check out

http://www.connectionstrings.com/

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET