RE: Transferring logins form 6.5 to 2000, anyone?!

From: Jyothi Pai [MS] (jyothip@online.microsoft.com)
Date: 12/19/02 

From: jyothip@online.microsoft.com (Jyothi Pai [MS])
Date: Thu, 19 Dec 2002 01:49:43 GMT

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. If you want to transfer only logins with
the password, there is a way to do this using DTS in SQL Server 2000.
However, this is only possible between two SQL Server 2000 servers or
between two 7.0 servers or from 7.0 to 2000 only. The procedure is outlined
in the following article:

INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/?kbid=246133

However, transferring the logins with the password from 6.5 to 2000 is not
possible (as far as my knowledge goes) using any other methods. Scripting
the logins out of the 6.5 Server and running the script on the 2000 server
would be the easiest solution to move the logins although the password is
re-set to NULL.

Regards,
Jyothi Pai
Microsoft Online Support Engineer

Get Secure! – www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: Hans Brouwer <hansbrouwer@hotmail.com>
| X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
| Subject: Transferring logins form 6.5 to 2000, anyone?!
| Mime-Version: 1.0
| Content-Type: text/plain; charset="us-ascii"
| Content-Transfer-Encoding: 7bit
| Message-ID: <enmqFUmpCHA.2064@TK2MSFTNGP12>
| Newsgroups: microsoft.public.sqlServer.security
| Date: Tue, 17 Dec 2002 23:13:51 -0800
| NNTP-Posting-Host: actionjackson37.dsl.frii.net 216.17.146.37
| Lines: 1
| Path: cpmsftngxa09!TK2MSFTNGP08!TK2MSFTNGP12
| Xref: cpmsftngxa09 microsoft.public.sqlserver.security:9831
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| Hi there,
|
| I need to transfer several hundred logins from SQL Server 6.5 to 2000,
| and this several times on different servers. It's only the logins, their
| database rights and passwords, NOT any database. As far as I can see I
| cannot use the upgradewizard for this. I have tried several things,
| basically transferring logins + password from the syslogins in v65 to
| sysxlogins to v2000. It all stumbles on the password transfer, which
| does not happen, probably due to securityconsiderations.
|
| Tnx for your time,
|
| Hans Brouwer
|
| *** Sent via Developersdex http://www.developersdex.com ***
| Don't just participate in USENET...get rewarded for it!
|

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)
  • Re: Windows permissions to run Jet OLEDB 4.0
    ... in SQL Server or not when you have to go outside of the server to the ... Actually I was talking about Windows logins. ... There is no security whatsoever implemented on the mdb ...
    (microsoft.public.data.oledb)
  • Re: Logins & Permissions
    ... At server level, we use "Logins" to connect to a SQL Server Instance and perform server level jobs. ... "Users" are used and these users are mapped to Logins. ... I am using SQL Server 2005 on a Windows NT Network ...
    (microsoft.public.sqlserver.security)
  • No Application Logins Allowed - SOX
    ... I'm trying to work through an issue regarding our MS SQL Server logins. ... "Customer" application uses a login to SQL Server called "Customer" and the ... Grant our users Windows Authentication access to SQL Server. ...
    (microsoft.public.sqlserver.security)