web analytics
How to change your SA password in SQL Server? Options
ncdit
Posted: Thursday, December 24, 2015 8:47:14 PM

Rank:Advanced Member
Groups: Member
Joined: 12/14/2015
Posts: 189
Points: 1098

You can change the sa password by using einther Transact-SQL or To Management Studio

To change the sa password by using Transact-SQL

Execute the following statements to enable the sa password and assign a password.

osql -E -S yourSQLserverName
sp_password @old = 'oldpassword or null', @new = 'newpassword', @loginame ='sa'
go

 

To change the sa password by using Management Studio

In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.

On the General page, you might have to create and confirm a password for the sa login.

Sponsor
Posted: Thursday, December 24, 2015 8:47:14 PM
 
Users browsing this topic
Guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2018 Digcode.com. All rights reserved.