New blank report guide, Connection Timeout Expired

[Morten]

In https://docs.telerik.com/reporting/getting-started/first-steps-designing#step-2-create-the-sample-report in step 3, "Click Next to execute the query and the Execute Query... button on the next screen to preview the result. Then, click Finish." (selecting Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString), I get this error message:

Configure SQL Data Source - sqlDataSource1

An error has occurred.
Parameter information cannot be retrieved: Connection
Timeout Expired, The timeout period elapsed while
attempting to consume the pre-login handshake
acknowledgement, This could be because the pre-login
handshake failed or the server was unable to respond back in
time. The duration spent while attempting to connect to this
server was - [Pre-Login] initialization=15089;
handshake=7147;

I have the same problem when trying to create a new connection.

Turning off the Windows Defender firewall for private network and trying again:

Configure SQL Data Source - sqlDataSource3
An error has occurred.
Parameter information cannot be retrieved: Cannot open
database AdventureWorks• requested by the login. The login
failed.
Login failed for user 'xxx•.

Turning on the firewall again, and I still get "The login
failed"

See screenshots.

In the c:\Program Files (x86)\Progress\Telerik Reporting 2024 Q1\Examples\Data\AdventureWorks OLTP\ folder, there is an instawdb.sql that creates and populates the AdventureWorks db. There is no AdventureWorks db in my local SQL server installation. Should I/can I run this script manually?

Or am I doing something else wrong?

 

[Todor]

Hello Morten,

Indeed, the getting-starting articles and some of our demo reports require the sample AdventureWorks database.

When you install the product, you are asked by the Wizard whether and where to install the examples and to provide a connection to the database server where to install the sample database.

If you have skipped this part of the installation or it has failed for some reason, you may indeed install the sample database manually, through the provided script 'instawdb.sql' that will deploy the data from the CSV files in the same folder in the corresponding tables of the AdventureWorks database. You may execute it in the MSSQL Server Management Studio.

After creating the database, ensure you provide the correct connection string to the reports.

Regards,
Todor
Progress Telerik