Tuesday, May 13, 2014

How to Connect SQL Server integration services using SSMS

When connecting to integration services I have faced the below error even though my windows login have admin permissions.




Cannot connect to MALLIREDDY.
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476
Connecting to the Integration Services service on the computer "MALLIREDDY" failed with the following error: "Access is denied."

By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.
For help, click: http://go.microsoft.com/fwlink/?LinkId=220763
Connecting to the Integration Services service on the computer "MALLIREDDY" failed with the following error: "Access is denied."
By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service


For Connecting SQL Server Integration Services run the SQL Server Management studio as run as administrator. SSMS will connect integration service successfully.




Similarly in data tools some times for bulk data load the data tools must run as administrator.




No comments: