Logins transfer problem

I have almost 200 SQL Server accounts on a SQL Server 7.0 server(SP2). I need
to transfer these accounts on to an SQL Server 2005 server(SP2). I used
http://support.microsoft.com/kb/246133
but it does not transfer the paswords. I know this because when I try to
connect with an account using the password on the old server, it does not
connect.
The only difference between the 2 servers, the old one has the collation of
SQL_Latin1_General_Cp437_BIN
and the new one has
SQL_Latin1_General_Cp1_CI_AS
Any ideas how I can transfer the passwords correctly ?
T.I.ADid you manually run SP_Help_RevLogin stored procedure? If not then you will
need to run the procdedure manually and take the output of that procedure and
execute it against the new SQL Server.
It has always worked for me.
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (World Wide SQL Server Community)
SQLTips, Scripts, Discussions, Blogs, Articles, Radio and a lot of SQL
Server Fun.
"DXC" wrote:
> I have almost 200 SQL Server accounts on a SQL Server 7.0 server(SP2). I need
> to transfer these accounts on to an SQL Server 2005 server(SP2). I used
> http://support.microsoft.com/kb/246133
> but it does not transfer the paswords. I know this because when I try to
> connect with an account using the password on the old server, it does not
> connect.
> The only difference between the 2 servers, the old one has the collation of
> SQL_Latin1_General_Cp437_BIN
> and the new one has
> SQL_Latin1_General_Cp1_CI_AS
> Any ideas how I can transfer the passwords correctly ?
> T.I.A|||You don't have to manually execute it. The whole script does that for you. If
you read the document, you just have to take the output and run it on the new
server.
"Saleem Hakani" wrote:
> Did you manually run SP_Help_RevLogin stored procedure? If not then you will
> need to run the procdedure manually and take the output of that procedure and
> execute it against the new SQL Server.
> It has always worked for me.
> --
> Thank you,
> Saleem Hakani
> HTTP://WWW.SQLCOMMUNITY.COM (World Wide SQL Server Community)
> SQLTips, Scripts, Discussions, Blogs, Articles, Radio and a lot of SQL
> Server Fun.
>
> "DXC" wrote:
> > I have almost 200 SQL Server accounts on a SQL Server 7.0 server(SP2). I need
> > to transfer these accounts on to an SQL Server 2005 server(SP2). I used
> >
> > http://support.microsoft.com/kb/246133
> >
> > but it does not transfer the paswords. I know this because when I try to
> > connect with an account using the password on the old server, it does not
> > connect.
> >
> > The only difference between the 2 servers, the old one has the collation of
> >
> > SQL_Latin1_General_Cp437_BIN
> >
> > and the new one has
> >
> > SQL_Latin1_General_Cp1_CI_AS
> >
> > Any ideas how I can transfer the passwords correctly ?
> >
> > T.I.A