Change MS SQL Login Password in ASP.NET

Question

I'm trying to change passwords of SQL server logins, but the Passwords just won't change. This is what I have:

SqlCommand query = new SqlCommand("ALTER LOGIN @login WITH PASSWORD = '@Pwd'", con);
query.Parameters.Add("@login", SqlDbType.NVarChar, 60).Value = login;
query.Parameters.Add("@Pwd", SqlDbType.NVarChar, 20).Value = _newPwds[login];
query.Prepare();
query.BeginExecuteNonQuery();

I don't get any error messages back from the SQL Server or debugging (Or I don't know how to get them). The Connection is correct and I have the rights to Change Passwords on the Server (Application is running with Integrated Security).

Thanks for your help.

@mason Thanks, didn't know that. I changed it and now I get "Incorrect Syntax near '@login'". — M.Zuberbühler
– M.Zuberbühler, Commented Sep 18, 2017 at 15:43
See this question for an example of using parameters with an alter login statement. — mason
– mason, Commented Sep 18, 2017 at 15:48
@mason Thanks! I'll test that on Thursday, but I think this will do. Could you add this to your answer? Then I would mark it as the right answer after I tested it. — M.Zuberbühler
– M.Zuberbühler, Commented Sep 18, 2017 at 16:20

mason · Accepted Answer · 2017-09-21 12:12:21Z

1

You are using an asynchronous method BeginExecuteNonQuery to execute the query, so you haven't captured it. Given you probably didn't want to go async, try using ExecuteNonQuery instead:

query.ExecuteNonQuery();

Plus you can't use parameters in an ALTER LOGIN statement, see this question.

edited Sep 21, 2017 at 12:12

answered Sep 18, 2017 at 15:45

mason

32.8k12 gold badges83 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Change MS SQL Login Password in ASP.NET

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related