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

October 2007 - Posts

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.

Script to Determine Members of a Group

Back in February I needed a script to display the groups a user belonged too. Today I was asked about the opposite. I needed to find a way to list the members of a group. Thankfully I blogged about the first issue in February because that led me to the solution. I'm actually using the same DSGET command but instead of using the user command I'm using the group command.

DSGET GROUP CN=West_Coast_Sales,OU=Sales,OU=GROUPS,DC=adminprep,DC=com -MEMBERS –EXPAND

"CN=bmiller,OU=Sales,DC=adminprep,DC=com "
"CN=jsmith,OU=Sales,DC=adminprep,DC=com "
"CN=dregan,OU=Sales,DC=adminprep,DC=com "
"CN=lramero,OU=Sales,DC=adminprep,DC=com "
"CN=cpeters,OU=Sales,DC=adminprep,DC=com "
"CN=jhorton,OU=Sales,DC=adminprep,DC=com "

Hopefully this solution works for you too.