<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

SQL 2000 SP4 timeout error 1460

Published on
10,071 Points
3,971 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

IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Join & Write a Comment

Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month