Re: Logins in 6.5 to 2000 upgrade

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 11/08/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Fri, 8 Nov 2002 13:24:15 -0500

Actually if I remember correctly now you couldn't move the logins from 6.5
to 7.0 or 2000. It's been a LONG time since I did a 6.5 upgrade but I
believe you need to create the Logins yourself and there is no way around
that. Maybe someone else who has done this recently can confirm but that is
my recollection. 

-- 
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:0ffd01c28747$629f25a0$3aef2ecf@TKMSFTNGXA09...
> 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
    ... This document does not address how to move logins. ... tells me that they must exist in master before the upgrade. ... >Andrew J. Kelly SQL MVP ...
    (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)
  • 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)