<

SQL 2000 SP4 timeout error 1460

Published on
10,147 Points
4,047 Views
1 Endorsement
Last Modified:
Approved

Problem.

I have an older server in my environment, running Microsoft SQL Server 2000 SP3, which I was trying to install SP4 on unsuccessfully.  I kept seeing 3 very bizarre symptoms, including getting "timeout error 1460" during the service pack installation.  This Article will show how I got around this issue.

I could neither install SQL Server 2000 SP4 nor any of the cumulative hotfixes (i.e., SP4 build 2187 & 2249) completely – installation kept resulting in timeout error 1460 and/or only the “tools” would update but not the DBs themselves (e.g., Master, et al).
I could not create maintenance plans (e.g., backups) for the SQL server – kept on getting SQL ServerAgent error 14258.
My Online Backup software would fail to backup the SQL server using its default SQL settings.

Then I discovered that the server was in “fiber / lightweight pooling mode” rather than in the default “thread mode”:

Solution.

All my problems went away after I placed the server back into its default “thread mode”:
sp_configure 'allow updates', 1
go
reconfigure with override
go
sp_configure 'lightweight pooling', 0
go
reconfigure with override
go

Open in new window


I know it’s a very old issue, but perhaps there are still people out there that could benefit from this tidbit of my experience.

Regards,

Philippe Blanchard, MCSE


Related References.

How to determine proper SQL Server configuration settings
http://support.microsoft.com/kb/319942

Is there any benefit for me in turning on the "lightweight pooling" SQL Server configuration option?
http://www.sql-server-performance.com/faq/fiber_lightweight_pooling_p1.aspx

The Perils of Fiber Mode (SQL Server 2000)
http://msdn.microsoft.com/en-us/library/aa175385(SQL.80).aspx
1
Ask questions about what you read
If you have a question about something within an article, you can receive help directly from the article author. Experts Exchange article authors are available to answer questions and further the discussion.
Get 7 days free