The Life of Brian

Active Directory, Group Policies, Server Core and the Life of Brian

Email Notifications

Blog Search Form

Go

Recent Posts

Tags

Disclaimer

  • This blog is provided "AS IS" with no warranties, and confers no rights. This blog contains my own views and does not necessarily reflect the view of my employer.
    Locations of visitors to this page
    Add to Technorati Favorites

Sites I Visit

Archives

Clustering SQL Server Integration Services

Had the pleasure of clustering SSIS the other day and it was not as simple as a thought it should have been. Not that it was difficult it was just being tricky. To cluster a service like this you have to select the Generic Service resource type for the cluster resource. When I looked at the service name of SSIS I went to services.msc to find that service. On the General tab you can see the "Path to executable:" There the service executable name was listed as msdtssrvr. After putting that name into the Generic Service Parameters it gave me an error that this was not the name. After some digging on the file system I found that the actual name is MsDtsServer. Apparently the letter e was left out of the original entry I had. One other area that needs some attention is the Registry Replication page, here you must enter SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS\ServiceConfigFile.

Hopefully that helps you.

Comments

Vincent Pan said:

MsDtsServer should be MsDtsServer100.

# March 10, 2009 12:22 AM

BrianM said:

Vincent, is that for SQL 2008?  Although it wasn't mentioned above my issue dealt with SQL 2005.  Either way that is is good info to know if it is for 2008.  :)

# March 10, 2009 8:58 AM