<

SQL 2000 SP4 timeout error 1460

Published on
10,022 Points
3,922 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
Comment
0 Comments

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Join & Write a Comment

Via a live example, show how to shrink a transaction log file down to a reasonable size.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month