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.
| Author |
Topic |
|
yasin
Yak Posting Veteran
68 Posts |
 Posted - 2005-03-16 : 09:38:50
|
| helloI 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.byyas |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-16 : 11:35:21
|
| Your DB probably has a new ID in sysDatabases so your old default database value is gone. Can you get to a QA window on that server? If so:sp_defaultdb '<YourLogin>', 'YourDB'Be One with the OptimizerTG |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Problem in Enterprise Manager when i am opening DB