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)
 Cannot open user default database '<ID>'

Author  Topic 

koln5
Starting Member

29 Posts

Posted - 2003-01-31 : 18:30:57
I think I deleted my default database and now when logging into EM or QA I receive the following msg:

A connection could not be established to DatabaseA
Reason: A connection could not be established to DatabaseA
Reason: Cannot open user default database '<ID>'. Using Master database instead
Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the DatabaseA node) and try again.

CAN ANYONE HELP ?????...Please

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-01-31 : 19:18:29
Just change your default database. The easiest way to do this is to go through Enterprise Manager. Go to the security section and double click on your userid. At the bottom of the screen that launched, just change the database to master or whatever you want your default to now be.

Go to Top of Page
   

- Advertisement -