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
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