how to find sa password
-
I will be acquiring a SQL server from another department and that dept only knows the name of the server and that it is sql 7.0. -- problem: they want a full backup of information on the server now how without knowing the sa password am I going to get this accomplished?
Sheila Conlon (getting back)
-
If the BUILTIN\Administrators group hasn't been removed, when you connect with a windows account that has admin privelages you should be granted sysadmin privelages. Once connected you can change the sa password.
--------------------
Colt 45 - the original point and click interface
-
SA may not be the only login that can perform a backup. Backup permissions default to members of the sysadmin server role and the db_owner & db_backupoperator database roles. If there's a login in one of those roles that you know, use it to do the backup.
If you do a search on this site for "SA password", you'll find several threads describing how to gain administrative access to SQL Server if the SA password is unknown.
Greg
Greg
-
NGSSquirrel and NGSSQLCrack are two products capable of doing this to recover an sa password. They are available from NGSSoftware. However, as others have indicated, you do not necessarily have to have the sa account in order to perform a backup.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply