Insufficient permissions to update linked server connections
search cancel

Insufficient permissions to update linked server connections

book

Article ID: 276038

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

The following error is displayed when attempting to update the properties of a data source integration in the Information Centric Analytics (ICA) console:

The service account may not have sufficient permissions on the SQL Server to perform this operation. Exception: User does not have permission to perform this action.

Cause

The sysadmin role has been removed from the ICA service account but the account has not been granted the Microsoft SQL Server permission Alter any linked server. The use of the sysadmin role in SQL Server is typically limited by organizational security policies.

Resolution

Follow the procedure provided in the following Broadcom technical document to configure the ICA service account to operate without the sysadmin role:

https://techdocs.broadcom.com/us/en/symantec-security-software/information-security/information-centric-analytics/6-6/ssms_permissions.html