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
 General SQL Server Forums
 New to SQL Server Programming
 Migrating a database to a new SQL server

Author  Topic 

olly83
Starting Member

1 Post

Posted - 2008-08-14 : 09:09:46
Hi Guys,

i've moved a database from one server to another on different boxes. i have restored and attached the database to the new SQL server but when i go to make this database the default database it will not let me/says the database is an inapropriate default database.

any ideas?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-14 : 09:36:31
Didn't get it? Post clearly.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-14 : 23:47:27
Is sql login you want to set a valid user in that db? Double check with sp_helpuser.
Go to Top of Page
   

- Advertisement -