INFORMATICS

The Best

Przełącznik języka

BUY COFFEE

If you like the website and want to support the project!

Postaw mi kawę na buycoffee.to

Tools

This Site

Mining

Security

CMS

Hardware

Backup

Windows Server

Uncategorised

useful sites

Databases

Emulators

Powershell

Storage Array

Active Directory

SEO

MSSQL

DNS

Antivirus program

Linux

Foto

Licznik

3.png0.png7.png0.png3.png3.png7.png
Today807
Yesterday1328
This week2852
This month20850
Total3070337

Visitor Info

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

Who Is Online

3
Online
Monday, 23 December 2024 19:26

Change SQL Server Password Using SQL Script

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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