Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SQL server error

Author  Topic 

kongaung
Starting Member

8 Posts

Posted - 2009-01-20 : 03:52:56
I am using SQl server 2005, now i am not remember sa password. It have many valueable data. I am not also resigning sa password and can not create dbuser. Now i can not backup and restore my database. If it has any way to solve this erorr... please share to me



Naing Aung
Myanmar

raky
Aged Yak Warrior

767 Posts

Posted - 2009-01-20 : 04:07:59
Hi,

Login with Windows authentication mode and go to security and change the password for sa login. Then relogin to sql server with this new password
Go to Top of Page
   

- Advertisement -