Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "[SQLServer] Only members of the securityadmin role can execute this stored procedure" while running IDR Server Manager on Linux
Problem Description
When running Informatica Data Replication (IDR) Server Manager on Linux, the following error is displayed while accessing MS SQL Server:

​java.sql.SQLException: [informatica][SQLServer JDBC Driver][SQLServer]Only members of the securityadmin role can execute this stored procedure.
Cause
​After establishing the connection from the Server Manager to MSSQL, the error message is coming from MSSQL due to lack of permissions for the Data Replication user.
Solution
​To resolve this issue, grant the role securityadmin to the Data Replication user.
More Information
Applies To
Product: Universal Data Replication
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version: Informatica Data Replication 9.8.0
Database: Microsoft SQL Server
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:7/29/2020 8:51 AMID:576995
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)