Moving Logins from 6.5 to 2000

Hello all,
I need to move over all the users in 6.5 into 2000, but when i created the
script to create the logins, the passwords came in as null into the new 2000
db. How do I birng over the passwords from 6.5 into the new 2000? Any help
is appreciated. Thanks in advance.
--
New SQL Server DBAHi,
The method to transfer the logins with the password from SQL Server 6.5 to S
QL Server 2000 is
to upgrade the databases using "upgrade wizard". There is no documented way
to move logins with password using scripts.
But there is undocumented method method to do this. see the below link. I ha
ve never tried this.
http://groups-beta.google.com/group...99a55c7fbed5496
FOR SQL 7 and SQL 2000 servers you can read the below article to transfer lo
gins.
http://support.microsoft.com/?kbid=246133
Thanks
Hari
SQL Server MVP
____________________________________
Newbie Wrote:
Hello all,
I need to move over all the users in 6.5 into 2000, but when i created the
script to create the logins, the passwords came in as null into the new 2000
db. How do I birng over the passwords from 6.5 into the new 2000? Any help
is appreciated. Thanks in advance.
--
New SQL Server DBA
Sent via SreeSharp NewsReader http://www.SreeSharp.com|||Thanks for the advise. How do I get this upgrade wizard? Thanks.
"Hari Prasad" wrote:

> Hi,
> The method to transfer the logins with the password from SQL Server 6.5 to
SQL Server 2000 is
> to upgrade the databases using "upgrade wizard". There is no documented wa
y to move logins with password using scripts.
> But there is undocumented method method to do this. see the below link. I
have never tried this.
> http://groups-beta.google.com/group...99a55c7fbed5496
>
> FOR SQL 7 and SQL 2000 servers you can read the below article to transfer
logins.
> http://support.microsoft.com/?kbid=246133
>
> Thanks
> Hari
> SQL Server MVP
> ____________________________________
> Newbie Wrote:
> Hello all,
> I need to move over all the users in 6.5 into 2000, but when i created the
> script to create the logins, the passwords came in as null into the new 20
00
> db. How do I birng over the passwords from 6.5 into the new 2000? Any he
lp
> is appreciated. Thanks in advance.
> --
> New SQL Server DBA
>
>
>
> Sent via SreeSharp NewsReader http://www.SreeSharp.com
>|||Hi,
This comes automatically when you install SQL Server 2000. After
installation see the SQL Server program groups.
Thanks
Hari
SQL Server MVP
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:C222A6D0-0AF9-4F6E-88D8-AA280AE1E2CF@.microsoft.com...[vbcol=seagreen]
> Thanks for the advise. How do I get this upgrade wizard? Thanks.
> "Hari Prasad" wrote:
>