September 16, 2008 at 5:43 am
Hi,
I want to move the logins from one server to another server.
Could anyone suggest on this in a simple way.
Thanks,
Sandhya
September 16, 2008 at 5:48 am
Yes.
You can script the logins on source server then apply script on target server.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 16, 2008 at 6:33 am
September 16, 2008 at 6:57 am
sandhyarao49 (9/16/2008)
Hi,I want to move the logins from one server to another server.
Could anyone suggest on this in a simple way.
Thanks,
Sandhya
depends on the flavour of source and target sql server
the following links to MS details moving logins from sql7\2000 to sql2005
http://support.microsoft.com/kb/246133
and sql2005 to sql2005
http://support.microsoft.com/kb/918992/
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 2:55 pm
you can use DTS by using "Transfer Logins Task" task.
September 20, 2008 at 7:40 am
Yes.
You can script the logins on source server then apply script on target server
Hi I don't know how to scipt the logins.Could you kindly tell me how to script the logins.
It would be great if you provide the repro steps for the same.
Iam new to sql server.
Thanks,
sandhya
September 20, 2008 at 9:49 am
September 20, 2008 at 10:27 am
sandhyarao49 (9/20/2008)
Hi I don't know how to scipt the logins.Could you kindly tell me how to script the logins.It would be great if you provide the repro steps for the same.
Search through the scripts library here. There are a number of scripts to script the logins there.
Or you can follow the links that Perry provided and use the scripts from the Microsoft support site.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 20, 2008 at 12:10 pm
If it is SQL 2000 Once transfered you have to use sid_map as well
Select 'EXEC ' + Name +'.dbo.sp_SidMap @old_domain = olddomainname,
@new_domain = newdomainname,
@old_server = oldservername,
@new_server = [i]newservername[/i]'from master.dbo.sysdatabases where dbid > 4
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply