Re: fix logins
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 04/02/04
- Next message: Dan van Ginhoven: "Re: Sp_helpdb fails, model db has null owner"
- Previous message: Raj: "How to Find if locks exists when deleting records from a table"
- In reply to: Adam: "fix logins"
- Next in thread: Adam: "Re: fix logins"
- Reply: Adam: "Re: fix logins"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 2 Apr 2004 07:54:09 +0200
Either specify the SID that the user has in the database in your sp_addlogin call, or just add the login and
fix the user's sid using sp_change_users_login, or use the KB article to export the logins from the source
server (search KB for sp_help_revlogin).
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "Adam" <anonymous@discussions.microsoft.com> wrote in message news:12ade01c41874$f63ca8e0$a001280a@phx.gbl... > 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: Dan van Ginhoven: "Re: Sp_helpdb fails, model db has null owner"
- Previous message: Raj: "How to Find if locks exists when deleting records from a table"
- In reply to: Adam: "fix logins"
- Next in thread: Adam: "Re: fix logins"
- Reply: Adam: "Re: fix logins"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
