Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

retrieve / recover sa password Expand / Collapse
Author
Message
Posted Monday, May 19, 2014 4:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 12:50 AM
Points: 41, Visits: 53

Open the SQL Server Management Studio.
Open a New Query.

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.


SSMS Expert
Post #1572210
Posted Monday, May 19, 2014 4:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 12:50 AM
Points: 41, Visits: 53
hopefully this will help


SSMS Expert
Post #1572211
Posted Thursday, August 7, 2014 3:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 20, 2014 1:51 AM
Points: 4, Visits: 15
Basically there are two ways to recover SQL SA password: either by creating a new SA account using SQLCMD or configure SQL Server by User mode. This processes involve some basic steps to implement it. Fore reference, you can read the solution from this post - http://sonikarawat.wordpress.com/2014/07/01/simple-manual-techniques-to-recover-lost-sa-password-in-microsoft-sql-server/
Post #1600530
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse