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.
Comments
0 comments
Please sign in to leave a comment.