Unable to connect the SQL Database to Dynamic SL 2018

(0) Share

Report

Posted on by Raghavendra Reddy

Hi Team,

After configuring webapps and DynamicSL webservices when trying to connect the Dynamic SL to SQL Database I am receiving below error when I am trying to run the Database maintenance wizard by selecting 2018 to 2018 CU5 .

We are setting up a new environment with Dynamic SL 2018 hence need to integrate with Database.Request you to help me as I have given all the access wherever it is needed and I am also sysadmin for the SQL Server and added my alias to Administrator group but still receiving the below error.

Database Name: VEXCELAPP
Error Code: 0
Error Text:
Statement: FAREAST\v-rkapa has insufficient Rights to Update Report Rights on Report Server. You will need to execute this application as a user that is associated with an SL user that has rights to the RSDEPLO screen.

End Time: 1:00:30 PM

All responses (1)

Answers (0)

Raghavendra Reddy on at

Like (0)

Report

RE: Unable to connect the SQL Database to Dynamic SL 2018

Using the Virtual Service account and when Iam integarting Dynamic SL with database using Database Maintenance wizard with my credentials it is prompring as Insufficient rights so Do I need to use any service account as Reporting Services running with NT SERVICE\SQLServerReportingServices.