Unplanned
Last Updated: 17 Jul 2023 08:07 by Lloyd
Raj
Created on: 09 Jun 2022 11:02
Type: Bug Report
1
No message is shown if AdventureWorks database creation fails during installation

In Reporting msi installer no verification is performed if the user exists and has create database permissions on remote database SQL server. No message is shown if AdventureWorks database creation fails.

1. Start Reporting .msi installer.
2. Agree with License.
3. Click button "Examples setup".
4. Enter database server name on remote machine with user with only public server role.
5. Click Next.
6. Click Install.

Expected: Message that database creation failed on step 4,5, or 6.
Actual: Installation proceeds and finishes. AdventureWorks database is not created.

2 comments
Lloyd
Posted on: 17 Jul 2023 08:07

If you go to C:\Program Files (x86)\Progress\Telerik Reporting R1 2022\Examples\Data\ that folder contains the sql script and csv files to create the database. The script is called instawdb.sql.

Modify the script and set @data_path to the path the csv files are in then run the script from ssms.

The issue I had is my sql server is on a different machine to my development machine and the installer silently failed to install the database. I copied the csv and scripts onto the sql server machine, modified the @data_path and then ran it. It created the database and imported the csv files.

 

Joshua
Posted on: 11 Jul 2023 15:20
Did you figure out a way install the database after the fact? I am stuck on this same issue.