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.googlegr oups.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.
>

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.
>

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike Hayes
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can download,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A
|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike HayesMS do not decide on such dates. The official response is "when it is ready".
It is in RC2 now, so
based on that, we can *guess* that it might be 1.5-2 months away, but nobody
knows.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes|||> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can downloa
d,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes