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 11:25:31 -0500


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: SQL Vulnerabilities
    ... Check out the PASS Community Summit - Seattle, ... event entirely dedicated to SQL Server, ...
    (microsoft.public.sqlserver.security)
  • Re: How to view process information from Query Manager
    ... Check out the PASS Community Summit - Seattle, ... event entirely dedicated to SQL Server, ... > process information of each spid, showing the actual command the ...
    (microsoft.public.sqlserver.security)
  • RE: Linked Server setup problem
    ... Transfer Logins and Passwords Between Instances of SQL Server ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL2000 accounts to SQL 2005 ?
    ... "Hank Arnold " wrote in message ... You transfer logins and passwords from SQL Server 7.0 to SQL Server 2005. ... You transfer logins and passwords from SQL Server 2000 to SQL Server 2005. ...
    (microsoft.public.sqlserver.setup)
  • Re: Transfer Logins
    ... Transfer Logins and Passwords Between Instances of SQL Server ... I'm trying to Add a DTS Package to Transfer Logins from My Production ... Environment to My Test Environment. ...
    (microsoft.public.sqlserver.tools)