Reports applicaion in different report servers

Question

0.00/5 (No votes)

See more:

I have created a WindowsForm project with reportviewer control in VS2012. During the creation of the project, the connection string was defined (e.g. ServerNmae.myDatabase). the project is compiled and a projectName.exe.config file is also created with contents as follows.

<configuration>
<configsections>

<connectionstrings>
<add name="ServerName.Properties.Settings.myDatabaseConnectionString">
connectionString="Data Source=SERVERNAME;Initial Catalog=mydatabase;Integrated Security=True"
providerName="System.Data.SqlClient" />

<startup>
<supportedruntime version="v4.0" sku=".NETFramework,Version=v4.5">

Works great. now I want to take this application and run it in a different server that contains the same database (e.g. mydatabase). Can this be done just by editing the Data source SERVERNAME?
That is what I have done so far but the report does not get populated. so I need to know if it should work or troubleshoot something else.

Posted 1-Jun-15 19:16pm

picasso2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2015-06-01T19:34:00

There are few options to check what is the issue when running application on different pc or server. You con display exception details by using message box or write exception details to a log file. Then you know exactly what's happening in run time. Use try.. catch. Block to capture exceptions.
When you using integrated security in the connection, it will check whether application exciting user has privileges to sql server. If your application and sql server running in the same machine then integrated security will work most of the time. When you connect from different pc to sql server, make sure that windows user/executing domain user having pevileges to sql server or you can change to sql server authentication by using sql server user name and password in the connection string. Check https://www.connectionstrings.com/sql-server/[^] for connecting string formats