Connect to Integration Services from Management Studio

[TeamGD]

I’m unable to connect to Integration Services from the SQL Server Management Studio. However the Network Administrator can. I can connect to Database Engine using Windows Authentication. Where is the connection access to Integration Services from SQL Server Management Studio administered?

cheers

 

[MDXer]

Security issue. You probably aren't a member of the proper windows groups.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[TeamGD]

Thanks Paul

Where do I determine the Windows Group(s) that have permissions to connect to Integration Services from the SQL Server Management Studio?

Greg

 

[MDXer]

Computer Management there are a number of QLServer2005 security groups.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[TeamGD]

I have resolved my issue … but the path took a few twists and turns.

I added my user name to the SQLServer2005DTSUser$<server name> local group … however this still did not allow me to connect to Integration Services via the Management Studio.

After doing more research I discovered that the Network Administrator could only connect to Integration Services from Management Studio on the server itself. The Network Administrator was unable to connect to Integration Services via Management Studio from any other PC.

This was not a Groups issue. Rather the problem was the inability to remotely connect to Integration Services.

I then found the following:

http://mohansmindstorms.spaces.live.com/Blog/cns!69AE1BEA50F1D0E7!213.entry

http://msdn2.microsoft.com/en-us/library/aa337083.aspx

These resolved my issue.

Cheers

Greg