sql6.5 login/pswd transfer to 2k

From: Rob (anonymous_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 09:40:02 -0700

Hello:

As posted under microsoft.public.sqlserver.setup

I had seen an article on transferring SQL 6.5 logins and
passwords (not upgrade wizard) but can't seem to find it
now, and was hoping if someone could either direct me to
any relevant links or if you could shed some info on how
to migrate all SQL Server 6.5 Logins and their Passwords
along with all their object permissions from, to a SQL
Server 2000 server.

I only want to migrate the logins and not the database as
the database on the 2000 server will be created net new.

Thanks.

- Rob.

Relevant Pages

  • 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)
  • 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: object level permissions being lost when migrating
    ... Just want to confirm that you are talking about SQL Logins and not windows Logins correct? ... As far as I know the compatibility level should not be an issue one way or the other but exactly how are you looking at the permissions? ... I first transferred the logins from the 2000 server to the 2005 server via ...
    (microsoft.public.sqlserver.security)
  • Re: login password changed
    ... available from Microsoft (reference Knowledge Base Article 246133). ... executed on the target server to create the logins with their original SIDs ... The passwords after transfer ...
    (microsoft.public.sqlserver.server)
  • Log Shipping Passwords
    ... I am trying to transfer my SQL logins from the primary ... server and resolve the passwords on the secondary ... If people change their passwords I want to ...
    (microsoft.public.sqlserver.setup)