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 |
|
timdw5s
Starting Member
1 Post |
 Posted - 2005-11-15 : 19:29:26
|
| Hi. I am getting the message "Cannot open user default database. Login failed." whenever I try to connect to a sql database that my hosting company owns. They are telling me that is a problem with my network although from this message I don't think that is the problem. I am using Enterprise Mangager and get this when trying to create a "New SQL Server Registration". Any help would be appreciated.Thanks,Tim |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-15 : 19:35:14
|
| Your hosting company needs to change the default database for your userid. Apparently it is currently assigned to one that doesn't exist (often is the case when restores are done and the dbid gets out of sync) or one that you don't have access to. The hosting company can due this via sp_defaultdb in Query Analyzer or by double clicking on your userid in Security..Logins in Enterprise Manager.Tell your hosting company that they are idiots if they think this problem is on your side. Switch hosting companies as this one doesn't know enough about SQL Server!Tara Kizeraka tduggan |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-16 : 01:33:52
|
| "They are telling me that is a problem with my network although from this message I don't think that is the problem"Crap! And tell them that I told you so!Kristen |
|
|
|
|
|
|
Cannot open user default database. Login failed.