cscrofani


Hello, I'm running an MS SQL 2005 database which supports our entire website and it's fairly huge. I seem to have lost the sa password for the database.

I COULD get it back if there was a way to convert the SQL 2005 DB to an SQL 2000 DB, seeing as how I found a password cracker for that version. Is there anyway to convert a 2005 DB back to a 2000 DB

Does anyone have any other ideas they might want to lay on me

I'm kind of sick about this... I'm usually a really good note-taker; In fact, I do have the sa password recorded in an IT database that I keep. Unfortunately the password just doesn't work. I've tried the caps lock and other variations, but the password just eludes me.

Thanks for your help,
Chris



Re: Lost sa Password... 2005->2000 Conversion?

Raul Garcia - MS


By default, in SQL Server 2005 members of builtin\Administrators have sysadmin privileges on SQL server. You can use a machine administrator account to reset the SA password using ALTER LOGIN.

-Raul Garcia

SDE/T

SQL Server Engine







Re: Lost sa Password... 2005->2000 Conversion?

cscrofani

Awesome... Can I do this with SQL Server 2005 Express + Management Studio Express, or do I need the standard versions

Thanks,
Chris





Re: Lost sa Password... 2005->2000 Conversion?

Raul Garcia - MS

It should work on any version. If you have problems getting this to work let us know, we will be glad to help.

-Raul Garcia

SDE/T

SQL Server Engine






Re: Lost sa Password... 2005->2000 Conversion?

Satya SKJ

Make sure to check the syntax and other informatio provided above from the latest Books online update , that should give you required information




Re: Lost sa Password... 2005->2000 Conversion?

cscrofani

So, I logged in with Management Studio Express and I'm a little lost... I can't find this "ALTER LOGIN" anywhere... Is this some sort of a command I need to use in a query If so, could you help me structure it

Also, Satya, I'm not quite sure what Books online is...

Thanks for the responses!

Chris




Re: Lost sa Password... 2005->2000 Conversion?

Laurentiu Cristofor

ALTER LOGIN is a TSQL DDL command. It is described in Books Online at this link: http://msdn2.microsoft.com/en-us/library/ms189828.aspx. The main link for Books Online is at: http://msdn2.microsoft.com/en-us/library/ms130214.aspx. Commands like ALTER LOGIN can by typed inside a query window in Management Studio. I usually run commands by selecting them and pressing F5.

Hope this helps
Laurentiu






Re: Lost sa Password... 2005->2000 Conversion?

VisualWeb

Hi Raul:

I am using SQL SERVER 2005 EXPRESS. Can you please send me the instructions for how to reset 'sa' password

Thanks a lot!

Annie






Re: Lost sa Password... 2005->2000 Conversion?

Deepak Rangarajan

Welcome to MSDN Forums Smile

If builtin administrator is present in sql level, you can login as an administrator and reset SA password or if you have any sysadmin ID login with it and reset it. If both are ruled out, you can try as per Raul's suggestion below http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx I think it is applicable to Sql Express as well.

- Deepak