Cannot connect to RS instance after Change IP of server!

Dear All,

We had changed the IP address of our SQL Database server(include the Report Server).

After we finished this, we restarted the server, but now, we cannot connect to the Report instance, database instance have no problem.

How to fix it?

Thank you.

Jeffers

Your connection string is likely stored in the installation folder in the file

<YourProjectName>.exe.config

You can open this file from the installation folder of client computer and modify the IP address manually

<connectionStrings>
<add name="MyTestApplication.My.MySettings.cnnConnection" connectionString="Data Source=123.456.789.234;Initial Catalog=TestDatabase;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>

Otherwise if you can open the VS project, open the app.config file and change the IP as above, then recompile and package up a new version to install on client computers.

Yet another way to change the connection string is open project properties(double click on My Project), goto "Settings" tab, change the value of the connection string from there.

Hope this helps.

Kiavash