Tuesday, January 4, 2011

Reset sa Password in SQL Server

1. Login to Server Management Studio using Windows Authentication

2. Click New Query

3. Enter the following

GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
GO

No comments:

Post a Comment