INFORMATICS

The Best

Change SQL Server Password Using SQL Script

Звезда не активнаЗвезда не активнаЗвезда не активнаЗвезда не активнаЗвезда не активна
 

Change SQL Server Password Using SQL Script

  1. Open the SQL Server Management Studio.
  2. Open a New Query.
  3. Copy, paste, and execute the following:

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

    where NewPassword is the password you wish to use for the sa account.

Search