After upgrading a BTS 2006 B1 R2 vpc image to Win2003 R2 all was not good.
Services were not starting and erroring all over the place (worked fine before Win2003
R2) and they seemed to be centered around SQL.
So I thought I’d ‘re-apply’ SQL 2005 SP1….and this fixed some of the problems….others
still remained.
I was getting “Event ID 7000: Sql Server Integration Services did not start or respond
to a control message in a timely fashion”
(I was also getting this with Analysis Services)
After much research here’s the circumstances that cause the problem:
(1) machine running sql is not directly connect to the internet (data
centers etc.) SSIS wants to go out to the internet to check the status of a certificate
or two (crl.microsoft.com…) when it starts up.
(2) SQL 2005 SP1 applied.
Solution: There are alternatives but my good buddy AB came
up trumps with Some
SQL Hotfixes to apply
(at the bottom of his article)
I’m on the road at the moment and when looking at the post SP1 SQL Hotfixes – the
first one of a SQL Server ‘hotfix’ of 25MB scared my and my GPRS phone off 🙂
Thanks AB.
Direct link to HOTFIX HERE