Problem in Enterprise Manager - SQL Server Forums

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)

Problem in Enterprise Manager

Author

Topic

yasin
Yak Posting Veteran

68 Posts

Posted - 2005-03-16 : 09:32:10

hello

I Detached the user default database from the server (Using EM) and when i was attaching the database,there is a problem. Enter prise Manager is working but In a servergroup, a particular server is not opened(Expand). It shows the error as cannot open user default database, Login failed, i entered in EM using sa login.

Please any one can help me in this regards.

thanx in advance.

by

yasi

Kristen
Test

22859 Posts

Posted - 2005-03-16 : 09:47:20

Duplciate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47164

yasin
Yak Posting Veteran

68 Posts

Posted - 2005-03-16 : 09:57:26

Mr. Kristen ,

Now i got it , i entered in query analyzer using different login. Now all other databases are functioning fine. Now how i can change this default database.

Thanx a lot ma ... thanx

by
yasi

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources