Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Brian Kelley SQL Server 2005 Logins RE: SQL Server 2005 Logins

  • October 2, 2009 at 2:11 pm

    #1061168

    pclemares (7/3/2009)

    Hello

    I have a Sql 2000 and I'd like to migrate to sql 2005. The problem I have it's that on the Sql 2000 I have the password of SA less than 8 characters, is it possible to maintain the same password on SQL 2005?

    Thanks

    Yes, when you go to modify the sa account, toggle Password Policy Enforcement off. However, from a security perspective, you need to see about getting that SA account password to at least 8 characters.

    K. Brian Kelley
    @kbriankelley