moving logins from one server to another

Question

Post reply

moving logins from one server to another

sandhyarao49

SSCrazy

Points: 2215
More actions
September 16, 2008 at 5:43 am

#123621

Hi,
I want to move the logins from one server to another server.
Could anyone suggest on this in a simple way.
Thanks,
Sandhya

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

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.

Adam Bean One Orange Chip Points: 26631 More actions · Answer 2

Adam Bean

One Orange Chip

Points: 26631

September 16, 2008 at 6:33 am

#872301

sp_help_revlogin

Perry Whittle SSC Guru Points: 233966 More actions · Answer 3

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" 😉

Joseph-465703 SSCrazy Points: 2122 More actions · Answer 4

you can use DTS by using "Transfer Logins Task" task.

sandhyarao49 SSCrazy Points: 2215 More actions · Answer 5

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

New2SQL-343122 Default port Points: 1461 More actions · Answer 6

http://mohanraj-jayaraman.spaces.live.com/blog/cns!EACF5D65BF47EF1E!287.entry

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krishnaraj9 SSC Eights! Points: 959 More actions · Answer 8

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