Re: Transfering NT logins

From: Jason (jasonwattse2_at_hotmail.com)
Date: 05/09/03 

Date: Fri, 9 May 2003 15:41:53 +0100

Thanks Vinodk

It does not tell you how to transfer the NT Authenticated logins with their
Server Roles. I use sp_helpsrvrolemember and manually add them after.

Cheers

Jason

"Vinodk" <vinodk_sct@hotmail.com> wrote in message
news:#1ut92fFDHA.2180@TK2MSFTNGP10.phx.gbl...
Have a look into the below KB article from MS
Q246133 INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133 

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions
"Jayson" <jasonwattse2@hotmail.com> wrote in message
news:01c501c3154b$c4244e30$2f01280a@phx.gbl...
> Can anyone tell me how to transfer NT logins with their
> Server Roles onto another Server.
>
> I create a script that generates the NT logins to add to
> the destination Server, However, I cannot find a way to
> add them to their defined Server Role from the Source
> Server.
>
> Any ideas will be great!!
>
> Cheers

Relevant Pages

  • Re: Compromised Server? Anyone recognize the suspect Services?
    ... I finally discovered that there was a whole folder structure under ... Event viewer shows normal logins, but I did not have it set to record ... there are a bunch of logins for Website Accounts created by the ... order to find those files on the Web Server I had to make sure that System ...
    (microsoft.public.windows.server.networking)
  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: Enabling STARTTLS in Exchange 2003 IMAP service?
    ... For the first, if you simply want to enable encrypted logins, then once you ... I guess I don't understand the need to have that command listed. ... > This section describes a means for "upgrading" an ordinary cleartext IMAP ... In order to use it, however, the server must advertise support for ...
    (microsoft.public.exchange2000.protocols)
  • Re: Enabling STARTTLS in Exchange 2003 IMAP service?
    ... For the first, if you simply want to enable encrypted logins, then once you ... I guess I don't understand the need to have that command listed. ... > This section describes a means for "upgrading" an ordinary cleartext IMAP ... In order to use it, however, the server must advertise support for ...
    (microsoft.public.exchange2000.admin)
  • Re: Transferring logins form 6.5 to 2000, anyone?!
    ... > server is case-insenstive, and the 2000 server is case-sensitive, then you ... > end up with all your passwords in upper case when they're copied. ... > /* Get 6.5 login information into the worktable, excluding system logins. ... >> Microsoft Online Support Engineer ...
    (microsoft.public.sqlserver.security)