Connect to SSIS Service on machine “SQLSERVER01″ failed
January 16th, 2008It took me the whole day to troubleshoot the error in the heading.
A client contacted me, yesterday, complaining that he can’t connect remotely to SQL Server 2005 Integration Services. The important word being remotely. When he tries to connect to Integration Services locally, it works. He had this problem with all remote servers.
I thought there was something wrong with his access privileges, so I followed the steps in this article: http://msdn2.microsoft.com/en-us/library/aa337083.aspx. Nope. Still didn’t work.
So I followed the steps in this article: http://mohansmindstorms.spaces.live.com/Blog/cns!69AE1BEA50F1D0E7!213.entry?action=post&wa=wsignin1.0. Nope.
By now I was pretty sure that there was some setting wrong on the client’s PC. The fact that I also could not connect remotely to Integration Services from his PC (even though I could from my PC) supported this claim.
So, using all the knowledge I’ve gained through the day from the hundreds of googles I did, I started comparing settings on my PC with the client’s PC. The problem? One little tick box that wasn’t ticked:
The screen, above, can be found here: Start -> Control Panel -> Administrative Tools -> Component Services -> Expand Component Services -> Expand Computers -> Right Click on My Computer -> Properties -> Default Properties.
After ticking the ‘Enable Distributed COM on this computer’ tick box, click ‘OK’ and restart the computer.
And so, after a whole day of googling, it was only one tick box that needed a tick. 7 hours of my life wasted.
January 16th, 2008 at 20:29
I didn’t understand most of what you wrote but I get the gist of it.
Love how you end the post. ‘7 hours of my life wasted’ Sucks how it’s often the small things that you don’t look at first.
February 6th, 2008 at 20:54
Thanks a lot budy, you saved 7 hours of my life… and probably more regarding the solution to this issue. This probably should have been on MSDN somewhere but I couldn’t find it, so thanks to have it done your own.
April 27th, 2008 at 2:44
Damn fine post! I to was running into the same issue. None of the other steps had worked. I have a small test domain and I’m in the “Domain Admins” group but still couldn’t connect to my Remote SSIS service from my XP development machine. Ticked this check box on my XP machine and all was well. Thanks a bunch!