fix logins

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Adam (anonymous_at_discussions.microsoft.com)
Date: 04/02/04

Next message: Raj: "How to Find if locks exists when deleting records from a table"
Previous message: Stephen Strong: "RE: Problems with installing SQL Server Service Pack 3A (still)"
Next in thread: Tibor Karaszi: "Re: fix logins"
Reply: Tibor Karaszi: "Re: fix logins"
Messages sorted by: [ date ] [ thread ]

Date: Thu, 1 Apr 2004 21:40:09 -0800

How do you create the logins with the same password, when
you backup and restore a database to a seperate server and
those logins do not exist at the server level?

Adam

Next message: Raj: "How to Find if locks exists when deleting records from a table"
Previous message: Stephen Strong: "RE: Problems with installing SQL Server Service Pack 3A (still)"
Next in thread: Tibor Karaszi: "Re: fix logins"
Reply: Tibor Karaszi: "Re: fix logins"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Resynching DB Users after Restore
... accidental security breach due to a cross-server restore. ... this semi-automagically, especially if you have a small, known set of logins ... Senior Database Administrator ... I support the Professional Association for SQL Server ...
(microsoft.public.sqlserver.security)
Re: Installation Question (Cross-Post)
... > Thank you for your post regarding how to restore database on MSDE. ... what a backup is restored from a different server than ... > logins in the database do not match the logins on the server. ...
(microsoft.public.sqlserver.msde)
RE: Installation Question (Cross-Post)
... Thank you for your post regarding how to restore database on MSDE. ... what a backup is restored from a different server than ... logins in the database do not match the logins on the server. ...
(microsoft.public.sqlserver.msde)
Re: problem in restore using dbcreator
... > I am facing the following issue when trying to restore a database ... While restore, i get the ... How To Transfer Logins and Passwords Between SQL Servers ... User Logon and/or Permission Errors After Restoring Dump ...
(microsoft.public.sqlserver.server)
Re: User already exists in the database error
... Tibor Karaszi, SQL Server MVP ... >> When you restore the database on another server, ... >> in the database now are orphaned. ... until I get ready to create users in the "Logins" ...
(microsoft.public.sqlserver.server)