CODEWITHSUNDEEP
sql-serversql-server-2008sql-server-2008-r2
Vikrant More
Vikrant More

Reputation: 5442

how to set the password to SA user

My Windows account has administrator rights on a local SQL Instance. I am able to change the password to SA user but when I try to login using SA with SQL Server authentication mode it gives me error. I am trying to access a local database.

Can somebody please help me to set the password and login to the local SQL using SQL authentication mode?

Upvotes: 1

Views: 7211

Answers (1)

Asif
Asif

Reputation: 2677

To set the sa password

In Object Explorer, connect to an instance of Database Engine.

On the Standard bar, click New Query.

Copy and paste the following example into the query window and click Execute. The following example enables the sa login and sets a new password.

ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;
GO

check this link

http://blog.sqlauthority.com/2007/12/29/sql-server-change-password-of-sa-login-using-management-studio/

Upvotes: 3

Related Questions