How to create database for reporting services manually?

Question

Is it possible to run database creation scripts for the reporting services database and then connect reporting services to the database created using the scripts?

Answer

To create a reporting database manually please follow this instruction:

1. Execute SQL scripts in this sequence:
C:\inetpub\wwwroot\FlexiCapture12Reporting\CreateDb\StatisticDescription.sql
C:\inetpub\wwwroot\FlexiCapture12Reporting\CreateDb\StatisticDbInitFill.sql

2. Write the connection string for the service (maybe it will be needed to change some values for your connection):
C:\inetpub\wwwroot\FlexiCapture12Reporting\appsettings.json

"AppSettings":  {
                        "ConnectionString":  "Data Source=localhost\\express;Initial Catalog=statDBSection2;Trusted_Connection=yes"

Note: if you have SQL Express, in order to avoid an issue with SQL Partitioning the version of SQL Express must be 2016sp1 or above.

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.