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?
To create a reporting database manually please follow this instruction:
1. Execute SQL scripts in this sequence:
2. Write the connection string for the service (maybe it will be needed to change some values for your connection):
"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.
Please sign in to leave a comment.