Can't transfer user logins and password from 6.5 to 2000

I tried the upgrade wizard and I am getting this error:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
--
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
> >I tried the upgrade wizard and I am getting this error:
> > "Unable to connect to the Export Server. Please verify that you are an NT
> > Administrator on that machine"
> >
> > I am an NT Administrator on that box.
> >
> > I also tried the script located
> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> >
> > but when I run it, it gives me alot of errors. Can anyone help me with
> > any
> > suggestions. Thanks.
> > --
> > New SQL Server DBA
> >
> > --
> > New SQL Server DBA
>
>|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
>> I would just script them out, type in the passwords, and go on down the road
>> personally. Provided you don't have too many SQL Logins.
>>
>> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
>> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>> >I tried the upgrade wizard and I am getting this error:
>> > "Unable to connect to the Export Server. Please verify that you are an NT
>> > Administrator on that machine"
>> >
>> > I am an NT Administrator on that box.
>> >
>> > I also tried the script located
>> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
>> >
>> > but when I run it, it gives me alot of errors. Can anyone help me with
>> > any
>> > suggestions. Thanks.
>> > --
>> > New SQL Server DBA
>> >
>> > --
>> > New SQL Server DBA
>>