Accidently deleted user

Hi,
I accidently deleted two users from a SQL Server database (from the
database, not from the server). It's the server for a MS CRM 1.2 system,
but that doesn't really matter...
I tried to recover them by restoring a backup for the database, but that
doesn't seam to help.
I tried to recreate the user in the database but I get an error that the
user (a windows user) already exists.
So what can I do? How can I use a backup to restore the permissions? How
can I recreate the user (they are stil used in other DBs) in the
database?
THANKS,
Thomas Pagel, Senior Consultant Business Intelligence
Software4You Planungssysteme GmbH
Hauptstr. 35
33178 Borchen
Germany
Tel: +49 5251 54009 11
Fax: +49 5251 54009 99
Mobil: +49 172 8423035
Homepage: www.software4you.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
All you should have had to do was recreate the users in the database and map
them to a login. Restoring the database should have been enough but you
might have needed to use sp_change_users_login to map the user to a login.
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
Andrew J. Kelly SQL MVP
"Thomas Pagel" <tpagel@.only.mail.no.spam.software4you.com> wrote in message
news:eaFN1aeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I accidently deleted two users from a SQL Server database (from the
> database, not from the server). It's the server for a MS CRM 1.2 system,
> but that doesn't really matter...
> I tried to recover them by restoring a backup for the database, but that
> doesn't seam to help.
> I tried to recreate the user in the database but I get an error that the
> user (a windows user) already exists.
> So what can I do? How can I use a backup to restore the permissions? How
> can I recreate the user (they are stil used in other DBs) in the
> database?
> THANKS,
>
> Thomas Pagel, Senior Consultant Business Intelligence
> ----
> Software4You Planungssysteme GmbH
> Hauptstr. 35
> 33178 Borchen
> Germany
> Tel: +49 5251 54009 11
> Fax: +49 5251 54009 99
> Mobil: +49 172 8423035
> Homepage: www.software4you.com
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Have you tried use sp_change_users_login in the database where the users
were deleted?
See BOL for full info.
hth
"Thomas Pagel" <tpagel@.only.mail.no.spam.software4you.com> wrote in message
news:eaFN1aeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I accidently deleted two users from a SQL Server database (from the
> database, not from the server). It's the server for a MS CRM 1.2 system,
> but that doesn't really matter...
> I tried to recover them by restoring a backup for the database, but that
> doesn't seam to help.
> I tried to recreate the user in the database but I get an error that the
> user (a windows user) already exists.
> So what can I do? How can I use a backup to restore the permissions? How
> can I recreate the user (they are stil used in other DBs) in the
> database?
> THANKS,
>
> Thomas Pagel, Senior Consultant Business Intelligence
> ----
> Software4You Planungssysteme GmbH
> Hauptstr. 35
> 33178 Borchen
> Germany
> Tel: +49 5251 54009 11
> Fax: +49 5251 54009 99
> Mobil: +49 172 8423035
> Homepage: www.software4you.com
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thanks for everyone... Seams to work now...
Thomas Pagel, Senior Consultant Business Intelligence
Software4You Planungssysteme GmbH
Hauptstr. 35
33178 Borchen
Germany
Tel: +49 5251 54009 11
Fax: +49 5251 54009 99
Mobil: +49 172 8423035
Homepage: www.software4you.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!