0

TITLE: Connect to Server

Cannot connect to


ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

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


Exception from HRESULT: 0xC00160AE (Microsoft.SqlServer.DTSRuntimeWrap)

For help, click: http://go.microsoft.com/fwlink/?LinkId=506689


Exception from HRESULT: 0xC00160AE (Microsoft.SqlServer.DTSRuntimeWrap)


BUTTONS:

OK

0

I believe that you have fallen prey to a permissions / authorization error:

0xC00160AE. Description: Connecting to the Integration Services service on the computer "Server Name" 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

  • Hey team, I was already using the administrator privileges. But now i resolved this issue. It was the ssis catalog creation in sql server 2017. – Manish Kumar Sep 28 at 14:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.