Issues with SQL Server 2005 SP1

2006/04/27

There have been reports of some issues with SQL Server 2005 SP1, especially with SQL Server Integration Services not starting as expected. If you're considering installing SP1, you'll probably want to verify the bug reports don't affect you:

MSDN Product Feedback - Bug Details: SSIS doesn't start after applying sql2k5 sp1
MSDN Product Feedback - Bug Details: SQL Server Integration Services service failed to start after installing SP1
MSDN Product Feedback - Bug Details: SP1 Broke Integration Services (looks like a duplicate of the others)
MSDN Product Feedback - Bug Details: Error installing SQL 2005 SP1 (Release) - Hotifx.exe crashes
Database Underground blog - SP1 for SQL Server 2005 Yields Mixed Results
SSC.com forum - sql2005 service pack I

I'm sure there are other sources, but that's what I found this morning after a quick search. There aren't a huge number of people screaming about problems with SP1, but then again, I don't know what the penetration of SQL Server 2005 looks like currently. However, if most of the folks are having issues, I'd assume there would be a lot more public outcry than what I've seen to date.But that's an assumption, so take it as such. If you're going to apply SP1 into your environment, remember the old proviso: test first and have a rollback plan.

If you're interested in what bugs have been fixed in SP1, you can find that here: Microsoft KB - A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1