Remove Strong Password Policy

[lshields]

I'm kind of new to SQL Server 2005, but how can I remove the enforcing of strong passwords from SQL Server 2005. Currently I have an app that has built in passwords that are not strong and it is having difficulty using the DB due to the strong password policy.

Any help would be appreciated. Thanks in advance.

 

[mrdenny]

Edit the login within the SQL 2005 gui, and uncheck the strong password requirment. If the SQL Server is forcing you to change the password, you'll need to change the password, then remove the requirement, then change the password back.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

BTW, I don't believe you can change this for the SA login. I think MS is deliberately forcing the SA login to use strong password security.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

This can be changed for the sa account. It's enabled by default, but it can be changed.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Ah. Thank you for correcting me. I thought it was unchangeable.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[lshields]

Is there a way to do this for the server in general. I do not want the policy at all. I know I can do this for any login through the GUI but I would like to disable the policy all together.

 

[mrdenny]

You can't. You have to disable it on a login by login basis.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com