Hi All,
I am attempting to upgrade my SQL 6.5 databases running on NT4 SP6 to a new
server running Win2003Server and SQL 2000.
The Upgrade Wizard is dying on the Import and Export phase and giving the
error described in KB Article 302850. The cause being a mismatch of users
and permissions between the two machines and the users that are starting the
MSSQLSever service. I attempted to follow the steps listed in this article,
but ran in the problem that I cannot seem to add a domain user from the NT4
machine as a Local Admin on the 2003 Server (no Active directory support I
guess?)
Any other options for me to get this upgrade to happen?
Thanks.
- MaxinNJHi
The solution in:
http://support.microsoft.com/default.aspx?scid=kb;en-us;818550
is to upgrade your OS on the NT server. You may want to find a third machine
to do this on! Alternatively you may want to try and use the Import
Wizard/DTS or BCP to retrieve the data (and possibly script the database to
get the DDL).
John
"MaxinNJ" <MaxinNJ@.discussions.microsoft.com> wrote in message
news:498B1C83-7395-4604-B6DE-D0CF35A53D9B@.microsoft.com...
> Hi All,
> I am attempting to upgrade my SQL 6.5 databases running on NT4 SP6 to a
> new
> server running Win2003Server and SQL 2000.
> The Upgrade Wizard is dying on the Import and Export phase and giving the
> error described in KB Article 302850. The cause being a mismatch of users
> and permissions between the two machines and the users that are starting
> the
> MSSQLSever service. I attempted to follow the steps listed in this
> article,
> but ran in the problem that I cannot seem to add a domain user from the
> NT4
> machine as a Local Admin on the 2003 Server (no Active directory support I
> guess?)
> Any other options for me to get this upgrade to happen?
> Thanks.
> - MaxinNJ|||Thanks John - missed that KB article. Well, this at least explains things :)
Off to find a spare machine and dig up SQL 6.5 disks!
- Max
"John Bell" wrote:
> Hi
> The solution in:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;818550
> is to upgrade your OS on the NT server. You may want to find a third machine
> to do this on! Alternatively you may want to try and use the Import
> Wizard/DTS or BCP to retrieve the data (and possibly script the database to
> get the DDL).
> John
> "MaxinNJ" <MaxinNJ@.discussions.microsoft.com> wrote in message
> news:498B1C83-7395-4604-B6DE-D0CF35A53D9B@.microsoft.com...
> > Hi All,
> >
> > I am attempting to upgrade my SQL 6.5 databases running on NT4 SP6 to a
> > new
> > server running Win2003Server and SQL 2000.
> >
> > The Upgrade Wizard is dying on the Import and Export phase and giving the
> > error described in KB Article 302850. The cause being a mismatch of users
> > and permissions between the two machines and the users that are starting
> > the
> > MSSQLSever service. I attempted to follow the steps listed in this
> > article,
> > but ran in the problem that I cannot seem to add a domain user from the
> > NT4
> > machine as a Local Admin on the 2003 Server (no Active directory support I
> > guess?)
> >
> > Any other options for me to get this upgrade to happen?
> >
> > Thanks.
> >
> > - MaxinNJ
>
>|||Hi
Make sure it is also service packed to the correct level.
John
"MaxinNJ" <MaxinNJ@.discussions.microsoft.com> wrote in message
news:DF507549-A9B1-40ED-BF65-0EB53DFB0DDC@.microsoft.com...
> Thanks John - missed that KB article. Well, this at least explains things
> :)
> Off to find a spare machine and dig up SQL 6.5 disks!
> - Max
> "John Bell" wrote:
>> Hi
>> The solution in:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;818550
>> is to upgrade your OS on the NT server. You may want to find a third
>> machine
>> to do this on! Alternatively you may want to try and use the Import
>> Wizard/DTS or BCP to retrieve the data (and possibly script the database
>> to
>> get the DDL).
>> John
>> "MaxinNJ" <MaxinNJ@.discussions.microsoft.com> wrote in message
>> news:498B1C83-7395-4604-B6DE-D0CF35A53D9B@.microsoft.com...
>> > Hi All,
>> >
>> > I am attempting to upgrade my SQL 6.5 databases running on NT4 SP6 to a
>> > new
>> > server running Win2003Server and SQL 2000.
>> >
>> > The Upgrade Wizard is dying on the Import and Export phase and giving
>> > the
>> > error described in KB Article 302850. The cause being a mismatch of
>> > users
>> > and permissions between the two machines and the users that are
>> > starting
>> > the
>> > MSSQLSever service. I attempted to follow the steps listed in this
>> > article,
>> > but ran in the problem that I cannot seem to add a domain user from the
>> > NT4
>> > machine as a Local Admin on the 2003 Server (no Active directory
>> > support I
>> > guess?)
>> >
>> > Any other options for me to get this upgrade to happen?
>> >
>> > Thanks.
>> >
>> > - MaxinNJ
>>
