Re: how to transfer logins between 2k5 instances

You can still do it using SSIS (as opposed to DTS) . One thing to watch out
for is that for SQL logins the account is disabled and the password set to
random value as per Books Online "Transfer Logins Task"

Apart from that pretty sure the same rules applies - ie have to fix up with
sp_change_users_login

cheers,
Andy.
"Jake" <noreply@xxxxxxxxxxx> wrote in message
news:enqPtusQGHA.5036@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

I am wondering if there is a kb article on how to transfer logins
between two sql2k5 instances? I have seen one for sql2k but not for
sql2k5. Thanks.

Jake




.

Relevant Pages

  • RE: "hashed" password on alter login command
    ... I understand that you'd like to transfer logins and passwords between SQL ... Microsoft Online Partner Support ...
    (microsoft.public.sqlserver.security)
  • Re: Migration / Kopieren einer DB von SQL 2000 => SQL 2005
    ... "Man kann sich ein SSIS Package erstellen, das nur die Aufgabe/Task hat Transfer Logins. ... So kann man sich leicht die Login vom Quell- in das Zielsystem holen. ... Bitte bei der Task darauf achten, dass die Option "SID erhalten" gewählt ist. ...
    (microsoft.public.de.sqlserver)
  • Re: Logins in 6.5 to 2000 upgrade
    ... upgrade, but it does not give me a way to move them. ... I have 200+ logins that I do not want to have to manually ... >Andrew J. Kelly SQL MVP ... >> How can I transfer logins and passwords from a 6.5 ...
    (microsoft.public.sqlserver.security)
  • Re: Move DB users
    ... Transfer Logins and Passwords Between Instances of SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Changing security authentication type.
    ... i'm thinking that yes in time the sa account will ... Create one or more logins for the applications. ... for each database. ... , you really have no security for your ...
    (microsoft.public.sqlserver.security)