This is a migrated thread and some comments may be shown as answers.

Connection String help

1 Answer 806 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Simon
Top achievements
Rank 1
Simon asked on 10 Apr 2017, 09:44 PM

Probably a dumb question. 

I've successfully installed Report Server, and am trying to input a Data Connection, and enter the provider (SQL) and the connection string, which the Report Server accepts. I then use IE to create a report,however, when I chose the Data Connection I entered, I get an error saying that there is an error in index 107.

 

So I'm guessing I'm not putting in the data string correctly even though it is accepted. Can someone give me the format of the conneciton string for SQLClient Data Provider (seems like a dumb question; however, it is not working with the one I'm entering).

 

In advance, thanks for your help.

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 13 Apr 2017, 03:08 PM
Hi Simon,

When you download the Standalone Report Designer you can start designing reports.
To configure a SqlDataSource component, please follow How to: Connect to a SQL Database.
The wizard will help you build the connection and to store it in the repo4rt or save it by name.

If you save the connection by name(alias), after publishing the report the connection string will be saved on the server, and you will be able to modify it from the Admin module (Data tab) of the Report Server.
An example of a connection string to MSSQL database.
<connectionStrings>
      <add name="Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"
          connectionString="Data Source=.\mssqlserver2014;Initial Catalog=AdventureWorks;Integrated Security=SSPI"
          providerName="System.Data.SqlClient" />
  </connectionStrings>

More manually written connection strings can be found here.


Let us know if you need further help.

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Simon
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or