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 |
|
krisdotca
Starting Member
6 Posts |
 Posted - 2011-06-20 : 09:53:40
|
| I'm trying to connect to a SQL Server 2008 database so that I can back it up. The problem is that the default database for the user is invalid and I do not have admin rights to the server.What I would like to do is connect to the database and specify the database to connect to. I found where to specify the db when connecting through Management Studio and am able to log in but it keeps giving me messages stating "Cannot open user default database" whenever I issue a command against the database (e.g. backing up db by right clicking on it).Is there any way to connect and get it to permanently remember the default database that was specified? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-20 : 11:03:41
|
| Have your sysadmin change your default database to a valid one. Many DBAs leave it as master, specifically for this issue. |
 |
|
|
|
|
|
Management Studio - Specifying Db Not Working