Post reply

How do I make a SQL login not have to change it's password?

  • December 3, 2007 at 10:21 pm

    #179744

    I've created a simple database on my development system and created a regular user to access this new database. Then I've written an application, and started to test it, having it use this new user. Everything is fine, except when I get to the point of opening a connection to the SQL 2005 database. It tells me that the user must change its password. I don't want this user to change its password. I got into SSMS and tried to clear everything so that I could continue working, but SSMS would not accept that.

    So, how do I make SQL Server 2005 let me change the requirement that the new user has to change its password before it can open a connection to the database?

    Rod

  • December 3, 2007 at 11:04 pm

    #756778

    This is because you might have created the login with windows policies enforced on it. You need to disable the enforce password policy in login user properties.

    --Ramesh

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply