Empty AdventureWorks database

3 Answers 29 Views
.NET Core DataSource SQL DataSources Report Designer - Web Report Designer (standalone) Report Viewer - Angular Report Viewer - ASP.NET Report Viewer - Blazor Report Viewer - HTML5 Report Viewer - MVC Table
Sergii
Top achievements
Rank 1
Iron
Iron
Sergii asked on 03 Sep 2025, 10:41 AM

Hi,

after installation of Telerik Reporting (with examples option checked) I got installed AdventureWorks database, but it is empty and I can't run any example report without data.

Where can I get backup of AdventureWorks database with data ?

3 Answers, 1 is accepted

Sort by
1
Accepted
Todor
Telerik team
answered on 07 Oct 2025, 12:47 PM

Hi Sergii and Krasimir,

The AdventureWorks database we use for our examples is older, and we keep it for the backup compatibility of our demo reports.

Therefore, we provide the SQL script for creating this sample database with the installation of the Reporting product.

The default location of the SQL is the folder "C:\Program Files (x86)\Progress\Telerik Reporting 2025 Q3\Examples\Data\AdventureWorks OLTP\". Note that the version (2025 Q3) may vary. You need to run the script "instawdb.sql" in the SQL Server Management Studio to restore the database and use it with our examples. The CSV files in the same folder represent the actual data tables.

Regards,
Todor
Progress Telerik

Your perspective matters! Join other professionals in the State of Designer-Developer Collaboration 2025: Workflows, Trends and AI survey to share how AI and new workflows are impacting collaboration, and be among the first to see the key findings.
Start the 2025 Survey
1
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
answered on 04 Sep 2025, 03:25 PM

Hello,

I'm also using AdventureWorks as a reference DB for samples and trainings. You can download it from here -> https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver17&tabs=ssms

The link provides the backups of the DB. You can follow the instructions in order to restore the DB.

Regards,
Krasimir Baylov

Sergii
Top achievements
Rank 1
Iron
Iron
commented on 30 Sep 2025, 03:37 PM

Microsoft db has different structure
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
commented on 01 Oct 2025, 08:15 AM

Hello Sergii,

Can you provide an example for some of the differences? I have AdventureWorks and AdventureWorks2022 locally and they seem to work fine with the samples.

Can you confirm you can connect to the DB through Telerik Reporting? What kind of error do you see? Can you create a new simple report that is using the DB, just to confirm that the problem is not related to connectivity?

Regards,
Krasimir Baylov

Sergii
Top achievements
Rank 1
Iron
Iron
commented on 02 Oct 2025, 05:21 PM | edited

Hello Krasimir,

structure differences (compared with Visual Studio):

 

>Can you confirm you can connect to the DB through Telerik Reporting?

Yes

What kind of error do you see?


>Can you create a new simple report that is using the DB, just to confirm that the problem is not related to connectivity?

sql query:

SELECT TOP (1000) [DepartmentID]
      ,[Name]
      ,[GroupName]
      ,[ModifiedDate]
  FROM [HumanResources].[Department]

 

 

Best r

egards,
Sergii

 

0
Sergii
Top achievements
Rank 1
Iron
Iron
answered on 10 Oct 2025, 06:17 PM

Hi Todor,

first of all thank you for wide and detail answer.

FYI: My issue with empty database happened because I use MSSQL in cloud (Azure) or inside docker as linux container, but script intended to be ran on Windows host with standalone mssql or sqlexpress. In corporate network not always easy to find such configuration.

 

Thanks again

Sergii

Tags
.NET Core DataSource SQL DataSources Report Designer - Web Report Designer (standalone) Report Viewer - Angular Report Viewer - ASP.NET Report Viewer - Blazor Report Viewer - HTML5 Report Viewer - MVC Table
Asked by
Sergii
Top achievements
Rank 1
Iron
Iron
Answers by
Todor
Telerik team
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Share this question
or