2005 Upgrade Lightweight Pooling Error

I am trying to upgrade from SQL Server 2000 Enterprise to SQL Server
2005 Enterprise on Windows 2000 Server.  It gets to the part where it
stops and starts MSSQLSERVER and completes that successfully.  Next,
when it says it is updating the database, I get the following error
when it is executing sqldmo.sql:

"SQL Server Setup has encountered the following problem:
[Microsoft][SQL Native Client][SQL Server]Lightweight pooling is
 not
supported on this platform or in this edition of SQL Server.. To
continue, correct the problem, and then run SQL Server Setup again."

If I knew how the correct the problem, I would... Anyone have any ideas
on things I could try?

Any help would be greatly appreciated.

Start SQL Server and in Query Analyzer run the following

exec sp_configure 'lightweight pooling',0
reconfigure

and then restart SQL Service. You should then be able to complete the
upgrade

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com


"kwins" <kwinslow@gmail.com> wrote in message
news:1144352693.139212.223460@t31g2000cwb.googlegroups.com...
>I am trying to upgrade from SQL Server 2000 Enterprise to SQL Server
> 2005 Enterprise on Windows 2000 Server.  It gets to the part where it
> stops and starts MSSQLSERVER and completes that successfully.  Next,
> when it says it is updating the database, I get the following error
> when it is executing sqldmo.sql:
>
> "SQL Server Setup has encountered the following problem:
> [Microsoft][SQL Native Client][SQL Server]Lightweight pooling 
is not
> supported on this platform or in this edition of SQL Server.. To
> continue, correct the problem, and then run SQL Server Setup again."
>
> If I knew how the correct the problem, I would... Anyone have any ideas
> on things I could try?
>
> Any help would be greatly appreciated.
>