Loosing right after restore : Mistery

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

SQL Server 2008 Forums

SQL Server Administration (2008)

Loosing right after restore : Mistery

Author

Topic

olibara
Yak Posting Veteran

94 Posts

Posted - 2010-08-24 : 16:40:51

Hello

I'm fighting since two days to try to set up User ID and login to an sql server Database
After many tricky attempts I win
See this topic
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149144

But now a make a new restore of my production DB and I've lost all the rights
If I delete that restored DB and restore my local DB I get the rights back

I've tryed all the ways to grant pertinent rights to the restored production DB without success

Rights on Sql server DB is a real mistery !!

So I thing that the simple way will be to script rights from the accessible DB and try to apply them on the recalcitrant DB

Is that possible ?

Thank for your help

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-24 : 17:46:09

Most likely you have orphaned logins. Hit google (or your favourite search engine) and search on that term, there's lots and lots written and the fix is trivial.

--
Gail Shaw
SQL Server MVP

olibara
Yak Posting Veteran

94 Posts

Posted - 2010-08-24 : 17:46:34

One more tip

If I open MNG studio using Windows Authentication I can open and browse the DB I can also see the user 'zitouch" with db_owner right

If I open MNG studio using SQL Autentication and zitouch Login I can NOT open the DB

Thanks for any help

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-24 : 18:36:54

You almost certainly have an orphaned login. Common when restoring a DB on a different instance. Hit google (or your favourite search engine) and search on that term, there's lots and lots written and the fix is trivial.

--
Gail Shaw
SQL Server MVP

olibara
Yak Posting Veteran

94 Posts

Posted - 2010-08-25 : 01:21:05

Thank you
I've found the solution here

http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources