db_dtsadmin role

Our DBA has given me access to MSDB on the SSIS service on one of our servers as db_dtsadmin. When I try to connect to the server using Integration Services in the connect drop down menu, I get the following generic error msg: connect to SSIS service on server 'xxxx' failed: access is denied.

I'm told this role should be sufficient to give me access. Do I need other server access roles to use in conjunction with db_dtsadmin or are we missing something really easy here.

Thanks.

DBRICHARD wrote:

Our DBA has given me access to MSDB on the SSIS service on one of our servers as db_dtsadmin. When I try to connect to the server using Integration Services in the connect drop down menu, I get the following generic error msg: connect to SSIS service on server 'xxxx' failed: access is denied.

I'm told this role should be sufficient to give me access. Do I need other server access roles to use in conjunction with db_dtsadmin or are we missing something really easy here.

Thanks.

This link might help: http://msdn2.microsoft.com/en-us/library/aa337083.aspx|||Thanks! This looks to be the answer. We'll try it.|||

DBRICHARD wrote:

Thanks! This looks to be the answer. We'll try it.

If that works for you, be sure to mark this thread as answered. Thanks!|||Thanks. We're still trying to work on this. We followed the instructions on the link (connecting to a remote integration services server) but I still can't connect and still receive the same generic 'access denied' error message. There must be some other permissions needed besides what is outlined on the link. Back to the drawing board.|||You could also ask this question over on the SQL Server security forum... Might generate a few more responses.