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 |
|
paramu
Posting Yak Master
151 Posts |
 Posted - 2009-09-30 : 04:49:41
|
| Hi,I take a backup from my office SQL-Machine, no problem. 1.Backup database My_Uses to disk='G:\SQL\Myuse1.bak'Also when I try to store to my laptop it stored no problem.2.alter database My_Uses set recovery simple3.restore database My_Uses from disk='G:\SQL\Myuse1.bak'But I have a problem, cannot access the database for particular user name. From "sa" login I can access. But for other user I cannot access. From the Database-> Security -> users I can find that user name.But it cannot be accessible to that user. I tried to add like "sp_adduser", but its says that username already exist.Also I tried to delete that user it failed to delete and gave the error "Drop Failed for user Haqeem- the database Principal owns a schema in that databse, cannot be deleted!" Then I checked from user properties there I can found "dbo" in schema tab.So how to solve it?ThanksParamu @ PARANTHAMAN |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-09-30 : 11:41:30
|
| The user's SIDs do not match from one machine to another. Look up sp_change_users_login in BOL. |
 |
|
|
paramu
Posting Yak Master
151 Posts |
Posted - 2009-10-03 : 02:33:31
|
| Thankyou very much....Very Nice Guidences. Really Appreciated !Paramu @ PARANTHAMAN |
|
|
|
|
|
|
Restored Data Access Problem - SQL Server 2008