Can't access default database on start up

Help!
The default database failed on the restore, and was marked
as in load. After trying to get the database out of that
state, the server was stoped and restarted. On the
restart, we now get the message that the default database
can not be accessed, so we can't connect. For some
unknown reason the default database for the admin group
was not Master, but the database that is marked in Load.
How can I know connect to the server?
Thanks
Mike Allen
Novice DBA|
| The default database failed on the restore, and was marked
| as in load. After trying to get the database out of that
| state, the server was stoped and restarted. On the
| restart, we now get the message that the default database
| can not be accessed, so we can't connect. For some
| unknown reason the default database for the admin group
| was not Master, but the database that is marked in Load.
|
| How can I know connect to the server?
|
--
Hi Mike,
If you connect using osql, you can use the /d switch to specify another
database as the default. For more information, please consult your SQL
Server Books Online on the topic "default database."
Hope this helps,
--
Eric Cárdenas
SQL Server support|||Thanks for your help. Even after changing the default db, for the Admin group, I was not able to get connect through EM. So I added my individual userid with a default db of master, and that worked. Now I get to 'fix' the bad database.
Thanks.
>--Original Message--
>| >| The default database failed on the restore, and was marked >| as in load. After trying to get the database out of that >| state, the server was stoped and restarted. On the >| restart, we now get the message that the default database >| can not be accessed, so we can't connect. For some >| unknown reason the default database for the admin group >| was not Master, but the database that is marked in Load.
>| >| How can I know connect to the server?
>| >--
>Hi Mike,
>If you connect using osql, you can use the /d switch to specify another >database as the default. For more information, please consult your SQL >Server Books Online on the topic "default database."
>Hope this helps,
>--
>Eric C=E1rdenas
>SQL Server support
>.
>sql