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 |
|
mhbdba
Starting Member
8 Posts |
 Posted - 2007-10-04 : 17:03:24
|
| How can i Restore a Database as a sql user authenication rather than windows user authentication. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-04 : 17:13:24
|
| There is no difference between which authentication method you use when restoring databases.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
mhbdba
Starting Member
8 Posts |
Posted - 2007-10-04 : 17:38:23
|
| right but my question is how can one restore using sql authentication. thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-04 : 17:47:15
|
| Same statement same gui, as long as sql id used has proper permission. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-04 : 17:48:33
|
quote:
Originally posted by mhbdba
right but my question is how can one restore using sql authentication.
There is no difference. So how do you restore using Windows authentication?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
mhbdba
Starting Member
8 Posts |
Posted - 2007-10-04 : 18:05:16
|
| well if you restore using windows authentication than the dbo show as windows authentication user, but i need to show it as sql authentication user and i mean when you right click on the db and go to properties in enterprise manager it should give you a sql user as the dbo. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-04 : 18:11:31
|
| What are you talking about? Do you just want to change the owner of the database?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-04 : 18:14:16
|
| You can always change it with sp_changedbowner. |
|
|
|
mhbdba
Starting Member
8 Posts |
Posted - 2007-10-05 : 13:15:25
|
| Never Mind Guys, thank you for all your help |
|
|
|
|
|
|
Restore DB as a sql user authenication