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.
No comments:
Post a Comment