Re: how to migrate users/logins with different domain account
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Mon, 06 Mar 2006 21:07:32 -0700
One option is to change domains for the logins using
sp_SidMap that comes with a utility from Microsoft. Refer to
the following article for the download link and more
information:
How to resolve permission issues when you move a database
between servers that are running SQL Server
http://support.microsoft.com/?id=240872
-Sue
On Thu, 02 Mar 2006 11:47:50 -0800, be be
<anonymous@xxxxxxxxxx> wrote:
Hi,
I'm facing the same challenge that is migrate database logins/users to a
different domain. sp_revlogin created a script fine. But the generated
script has "exec master..sp_grantlogin 'olddomain\user' for all the
logins. What I need is "exec master..sp_grantlogin 'newdomain\user'".
Since there are quite a few domain users/groups are involved, replacing
'olddomain' with 'newdomain' is out of the question. So the question is
in the original script that's used to generate sp_revlogin, how to
replace 'olddomain' with 'newdomain' in @name in the following
statement?
SET @tmpstr = 'EXEC master..sp_grantlogin '''+ @name + ''''
I'm not familiar with the scripting language and its syntax. I'd
appreciate any help.
Thanks,
Bing
*** Sent via Developersdex http://www.developersdex.com ***
.
- References:
- Prev by Date: Re: Adding permissions to an AD user on a remote database
- Next by Date: authentication across domains - asp in frame
- Previous by thread: Re: how to migrate users/logins with different domain account
- Next by thread: Logon from remote system error
- Index(es):
Relevant Pages
|
