Resetting Unknown SA password
Posted on 2004-10-29
New to SQL Server and coming in as the new DBA (w/an Oracle background).
Previous DBA used Windows authentication in the old office location. When our office moved to a new location, the Network Admin backed up the image of SQL Server 2000 from an old machine to a new server when we transferred to the new location. The Network Admin gave me local as well as domain admin rights to login to the new instance of SQL Server on the new server. Logging in, I was able to register the SQL Services and can access and see some of the databases running on SQL Server, but I am obviously not coming in as a SYSADMIN. The problem is, I cannot even go to the registry and change my authentication from Windows-based to Mixed mode since I do not know what the SA password is (the previous DBA cannot be reached and nobody here knows what the SA password is). So, what other options do I have?
Appreciate the expert help ASAP as I need to start managing our databases and I cannot even get in as an "sa" to do my job.