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
 SQL Server Administration (2005)
 How to unlock 'sa' account

Author  Topic 

ian.caro
Starting Member

9 Posts

Posted - 2009-01-22 : 02:25:57
Hi,

the account that we are using for the sql server 2005 is lock out. we cant get inside the sql because of this error message.

Pls. help

regards,
IAN

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-22 : 04:20:14
Try to log on the server as an Administrator and start the management studio from there. Usually the local administrator is a sysadmin on the sql server...

- Lumbago
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-22 : 11:57:39
quote:
Originally posted by Lumbago

Try to log on the server as an Administrator and start the management studio from there. Usually the local administrator is a sysadmin on the sql server...

- Lumbago



Unless Built-in administrator is not removed from SQL Server Security after installation.
Go to Top of Page

ian.caro
Starting Member

9 Posts

Posted - 2009-01-23 : 04:54:27
Hi,

Thanks Lumbago and sodeep. it work! thanks for the reply and for the help.

Regards,
IAN
Go to Top of Page
   

- Advertisement -