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 2000 Forums
 SQL Server Administration (2000)
 Error 18456 in single user mode

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-16 : 09:35:42
Gabriela writes "I restarted sqlserver to single user mode in order to restore production master database to this standby server. I tried to restore master in Enterprise Mgr but it hung.

Then I tried to connect to this server via query analyzer but I keep getting Error 18456 using sa. The server is set up to starts services using a specific account, not system account. Did I miss anythings? Would appreciate any helps. Thanks,

Gabriela"
   

- Advertisement -