Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Login failed for user ... Please, what am I doing

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2010-05-31 : 21:31:11
Hello,

I configured a SQL Server to remote connections and I have the
following connection string:

<connectionStrings>
<add
name="WA.Tasks.Domain.Properties.Settings.WATasksConnectionString"
connectionString="Data Source=xxx.xx.xxx.xx
\SQLEXPRESS;Initial Catalog=WATasks;User Id=wa;Password=wa1111;"
providerName="System.Data.SqlClient" />
</connectionStrings>

I added a login and set the SQL Authentication.

Then I set this login as db_Owner and public for that database.

But I keep having the error:

Login failed for user 'wa'. Reason: The password of the account must
be changed.
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 'wa'. Reason: The password of the account must be changed.

What is wrong?

I tried everything I could think of but I can't find a solution.
I change the password and the same happens ... The password is
correct.
Please, what am I doing wrong?

Thank You,
Miguel

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-01 : 02:05:02
Please try to logon as user "wa" with your Management Studio and change the password there.
I have googled and that seems to be the easiest solution.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-01 : 12:49:54
You need to login with a sysadmin account, perhaps sa, and modify the wa user so that the option to change the password is disabled.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2010-06-08 : 01:06:22
Why is not working I like to know.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-08 : 02:40:12
Well the error message tells you why it isn't working. Someone must manually log into the account in SSMS and get the password changed. You can either do that via a sysadmin account or with the wa account.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -