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 |
|
gongxia649
So Suave
344 Posts |
 Posted - 2007-04-09 : 14:53:59
|
| i backed up the database d1 and deleted it off my sql server.when i innitiate the sql server instante is supposed to run the d1 DB. But since i deleted it, it pops up an error. How can i fix it? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-09 : 14:58:40
|
| What do you mean by "when i innitiate the sql server instante is supposed to run the d1 DB"?What error are you getting?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
gongxia649
So Suave
344 Posts |
Posted - 2007-04-09 : 15:21:41
|
| cannot connect to p4cannot open user dfault db. login failedlogin failed for user p4\user (ms sql server, error 4064) |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-04-09 : 15:23:22
|
| so this happens when?when you start management studio or somewhere else?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-09 : 15:26:45
|
| You'll need to login as a different user, one with permissions to run sp_defaultdb. Then run sp_defaultdb to change the default database of your userid.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
deleted the database but have a backup .