Friday, February 24, 2012

Integration Services in SSMS

We use Windows Authentication to connect to SQL Server, is there any special permissions required to connect to Integration Services in SSMS?

Whenever I try to browse the servers available with Integration Services (from Object Browser), none of the servers gets listed. If I directly give server name and try to connect to Integeration Services I get the following error. But I'm able to connect to the database engine.

TITLE: Connect to Server

Cannot connect to <servername>.


ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "<servername>" failed:
Access is denied.

Connect to SSIS Service on machine "<servername>" failed:
Access is denied.

Thanks

Have you searched this forum or the Internet?

A well documented issue exists. Make sure you follow:

http://www.ssistalk.com/2007/04/13/ssis-access-is-denied-when-connection-to-remote-ssis-service/|||I think I went through those threads, forgive me for my ignorance, these steps of DCOM configuration needs to be done on the server where SSIS is running? since the final step says restart Integeration Services, I assume this needs to be done at the server.

Thanks
|||

Karunakaran wrote:

I think I went through those threads, forgive me for my ignorance, these steps of DCOM configuration needs to be done on the server where SSIS is running? since the final step says restart Integeration Services, I assume this needs to be done at the server.

Thanks

Correct. This is all on the server.

No comments:

Post a Comment