Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

No record of sa password

Dear Admins,

I am newbie to SQL Database and now I have a need to move SQL 7 database from 1 server to another. But being new to this company, there is no one remembers the password. Is there any workaround or way to recover or reset this password? I do not have any ID other than the domain admin rights.

Hope you can lend me a helping hand. Would be very grateful as I urgently need to migrate the database. Thanks.

Best regards,
Yong
[467 byte] By [yong] at [2007-11-11 7:44:51]
# 1 Re: No record of sa password
Domain admin rights will do the trick mate, so long as the sql server is set for mixed mode authentication...
PaulMcM at 2007-11-11 23:47:40 >