November 8, 2007 at 7:06 pm
Hello People
I recently upgraded a production SQL2000 server to SQL2005 and also installed a clean test SQL2005 instance onto two separate servers. In both instances I cannot get SSIS to startup. These two servers do not have access to the internet via the domain account (which starts up the SQL services) and I'm wondering if this is the issue.
Thanks in Advance
Adonia
November 9, 2007 at 4:02 am
This is a known issue. It's better to apply sp2 directly than sp1 and then find the patch that fixes the int services service. However, there is a workaround after applying sp1 if sp2 is not possible as yet: there is a registry key that has to be modified - unfortunately I cannot find the exact registry key now as I don't have any work docos with me.
I would say to apply sp2 on your test sql2k5 to see that's fixing the service.
Hope this helps.
November 9, 2007 at 7:29 pm
Here's the KB article on this:
November 11, 2007 at 5:16 pm
Registry Key: HKEY_USERS\S-1-5-20\Software\Microsoft\Windows\Current Version\WinTrust\Trust Providers\Software Publishing
Value: State
Original Data: dword:00023c00
New Data: dword:00023e00
Good luck
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply