RE: Logging into a restored db

From: Cindy Gross (cgross_at_online.microsoft.com)
Date: 07/03/03 

Date: Thu, 03 Jul 2003 20:16:46 GMT

There are various ways to accomplish what you want. Start with reviewing these articles to get a better understanding why you are seeing the
behavior, then you can either sync up the logins/users or change the db and object owners.

314546 HOW TO: Move Databases Between Computers That Are Running SQL Server http://support.microsoft.com/?id=314546
224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach http://support.microsoft.com/?id=224071
221465 INF: Using the WITH MOVE Option with the RESTORE Statement http://support.microsoft.com/?id=221465
240872 HOW TO: Resolve Permission Issues When You Move a Database Between http://support.microsoft.com/?id=240872
246133 INF: How To Transfer Logins and Passwords Between SQL Servers http://support.microsoft.com/?id=246133
274463 INF: Understanding and Troubleshooting the Copy Database Wizard in SQL http://support.microsoft.com/?id=274463
168001 PRB: User Logon and/or Permission Errors After Restoring Dump http://support.microsoft.com/?id=168001
264474 PRB: System Database Backups Cannot be Restored on a Different Build of http://support.microsoft.com/?id=264474
321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log Backups http://support.microsoft.com/?id=321836

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: MSDE users guide
    ... You are "right on" with your understanding of my problem. ... I am going to download the ... MSDE is missing a key component of SQL Server, ... basic tool for database creation and probing existing databases. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Upgrading database
    ... INF: Moving SQL Server databases to a new location with Detach/Attach ... How to Resolve Permission Issues When a Database Is Moved Between SQL Servers ... Mapsids.exe Helps Map SIDs Between User and Master Databases When Database Is Moved ...
    (microsoft.public.sqlserver.server)
  • RE: Using a HEX differential when moving data files.
    ... 246133 INF: How To Transfer Logins and Passwords Between SQL Servers ... Move Databases Between Computers That Are Running SQL Server ... Resolve Permission Issues When You Move a Database Between ...
    (microsoft.public.sqlserver.server)
  • Re: All security permission in my new SQL server.
    ... 224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach http://support.microsoft.com/?id=224071 ... 221465 INF: Using the WITH MOVE Option with the RESTORE Statement http://support.microsoft.com/?id=221465 ... 274463 INF: Understanding and Troubleshooting the Copy Database Wizard in SQL http://support.microsoft.com/?id=274463 ...
    (microsoft.public.sqlserver.security)
  • Re: User who does not exist in Enterprise Manager has full access
    ... impede Windows NT administrators from administering a clustered ... Move Databases Between Computers That Are Running SQL Server ... 221465 INF: Using the WITH MOVE Option with the RESTORE Statement ... Resolve Permission Issues When You Move a Database Between ...
    (microsoft.public.sqlserver.security)