SQL 2000 SP4 timeout error 1460

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

SQL 2000 SP4 timeout error 1460

Problem.

Solution.

Related References.

Comments (0)