Change the SA user password in SQL Server

Change the SA user password in SQL Server

Open the SQL Server Management Studio and log in with the SA or Window Authentication to the Server.

Expand the Server –> Security –> Logins as follows:

Right-click on SA user and click on properties. The following window will be shown from which you can easily change the SA password.

Using Script you can also change the password:

-- Login with Window Adminstrator or SA or any other administrator:

USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'Password@123'
GO
Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.