SQL sa adminstrator account

This 'sa' account was used for the initial setup of the SQL 2000 database.

However, over a long period of time this password to this 'sa' account was forgotten.

How can I recover this 'sa' password? Any impact for future upgrade to SQL 2005 without the current SQL 2000 'sa' account password?

Any advice?

thanks in advance.

Lawrence

[378 byte] By [laulvai] at [2007-12-25]
# 1
I don't know of any ways to recover the password, but if you have another account that can backup the databases, you could backup/restore them to a fresh install of SQL 2005.

Thanks,
Sam Lester (MSFT)

SamuelLester-MSFT at 2007-9-3 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 2

If you're using another account with the sysadmin role assigned to it you can reset the sa password with the other account.

sp_password NULL, 'NewP@ssw0rd', 'sa'
go

AllenWhite at 2007-9-3 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...

SQL Server

Site Classified