INFORMATICS

The Best

Przełącznik języka

Tools

This Site

Mining

Security

CMS

Hardware

Backup

Windows Server

Databases

Emulators

Powershell

Storage Array

Active Directory

SEO

MSSQL

Antivirus program

Linux

Licznik

3.png0.png4.png1.png2.png5.png8.png
Today155
Yesterday1207
This week6140
This month16159
Total3041258

Visitor Info

  • IP: 18.191.189.124
  • Browser: Unknown
  • Browser Version:
  • Operating System: Unknown

Who Is Online

3
Online
22.11.2024 02:48

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