Tuesday, January 3, 2012

Changing the default password in SQL Server 2008

SQL Server 2008 password requirements differ from previous SQL Server versions. To modify SQL Server 2008’s default password policy, start by ensuring that mixed mode authentication is enabled. Next, open SQL Server Management Studio and log in as a database owner. And then open a new query window and execute the following SQL command:

ALTER LOGIN sa WITH PASSWORD = ‘sa’ UNLOCK, CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF

No comments: