Share via

Error when creating a new SSRS Subscription in SSRS 2017

Arturo G. Jovellano 0 Reputation points
2023-03-07T03:09:57.6133333+00:00
  • SQL Server 2017 Enterprise Edition
  • With Administrator Permission

While creating a new SSRS Subscription with the ff:

delivery option -> Windows File Share

Render Format->PDF

Credentials -> Windows User Credential

Overwrite Option -> Overwrite existing file with new version

When I click the button "Create Subscription"; Error message-> An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.

We have a QA environment with same SQL Sever 2017 Ent Ed, when I created the new ssrs subscription I did not encounter the error message.

The difference between our QA and Prod environment is that in Prod we have Power BI Report Server installed; while in QA we did not install the Power BI Report Server.

Your help is highly appreciated.

Thanks,

Art Jovellano

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2023-03-07T06:41:39.1766667+00:00

    Hi @Arturo G. Jovellano

    This should not be a problem with Power BI Report Server. I also don't have Power BI Report Server installed, but my subscription works just fine.

    According to your error message, this should be an error caused by the database, please check whether your report server instance can connect to the database.

    Configure a Report Server Database Connection (Report Server Configuration Manager)

    If it is a timeout connection problem caused by too much data, you can refer to this link.

    For more details, you can refer to this link: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/37934c15-7128-4130-bb33-509dea58cfea/an-error-occurred-within-the-report-server-database-this-may-be-due-to-a-connection-failure?forum=sqlreportingservices.

    If the answer is helpful, please click "Accept Answer" and upvote it. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya