Re: Logins in 6.5 to 2000 upgrade

From: Chuck Cardenas (ccarden@greyhound.com)
Date: 11/08/02 

From: "Chuck Cardenas" <ccarden@greyhound.com>
Date: Fri, 8 Nov 2002 08:53:38 -0800

This document does not address how to move logins. It only
tells me that they must exist in master before the upgrade.
Any other suggestions?
>-----Original Message-----
>I am pretty sure this document discusses this:
>http://www.microsoft.com/sql/howtobuy/howtoup.asp
>
>--
>Andrew J. Kelly SQL MVP
>Targitinteractive, Inc.
>
>Check out the PASS Community Summit - Seattle, the
largest and only user
>event entirely dedicated to SQL Server, November 19-22.
>http://www.sqlpass.org/events/seattle/index.cfm
>
>
>"Chuck Cardenas" <ccarden@greyhound.com> wrote in message
>news:391701c28740$b90b7df0$35ef2ecf@TKMSFTNGXA11...
>> How can I transfer logins and passwords from a 6.5
>> instance to a 2000 instance. I've upgraded an instance
>> and noticed that syslogins is now a view off of
sysxlogins
>> in 2000 instead of a table on 7.0 and 6.5. Is there a
>> procedure to move logins?
>
>
>.
>

Relevant Pages

  • Re: Upgading to XP Pro form XP Home
    ... Blaine R respectfully replied;-) ... Upgrade to Windows XP Professional ... >>> can't find my logins from XP Home. ... >> right-click My Computer> Manage> Local Users and Groups? ...
    (microsoft.public.windowsxp.general)
  • Re: Upgading to XP Pro form XP Home
    ... It was an upgrade and the logins are from local users but are in the ... "Bruce Chambers" wrote: ...
    (microsoft.public.windowsxp.general)
  • 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: Transferring logins form 6.5 to 2000, anyone?!
    ... aplicationmanager and his response was, that a lot of those logins where ... Only a dozen or so logins should be ... to be able to do a 2-machine upgrade ... To put both machines everytime an upgrade is made in 1 account ...
    (microsoft.public.sqlserver.security)
  • RE: Transferring logins form 6.5 to 2000, anyone?!
    ... Hi Hans, ... The *only* supported way to transfer all the logins along with their ... password from SQL Server 6.5 to SQL Server 2000 is to upgrade the databases ... using the version upgrade wizard. ...
    (microsoft.public.sqlserver.security)