Hi all,

Recently we changed connection string in web.config file of our DNN 07.01.02 site. After the connection string change many times i found site s down and getting error like below

DNN error
Site unavailable

Immediately I will restart IIS and the problem will solve. How can I solve this issue permanent?

Web config I changed like below


add name="SiteSqlServer" connectionString="Data Source=LocalSname;Initial Catalog=DNN070102DB;User ID=Uidtest;Password=uidpass" providerName="System.Data.SqlClient"
add name="omanConnectionString" connectionString="Data Source=LocalSname;Initial Catalog=Dbforexec;Integrated Security=True" providerName="System.Data.SqlClient"

changed to

add name="SiteSqlServer" connectionString="Data Source=*.*.*.*;Initial Catalog=DNN070102DB;User ID=Uidtest;Password=uidpass" providerName="System.Data.SqlClient"
add name="omanConnectionString" connectionString="Data Source=*.*.*.*;Initial Catalog=Dbforexec;User ID=uid;Password=pas" providerName="System.Data.SqlClient"


I found one forum reply related to this issue which is below. But couldnt understand how to do so?

http://www.dnnsoftware.com/forums/t...or-message

Hi Meenu,

Very hard to help you out here based on that short error message.

I would check the web server windows log to see if there is any error going on that is bringing the db down or crushing the app pool.

Andy

Dear Andy, I checked DNN eventlog and System log and not found any related errors.

Meenu,

As I said, very hard to troubleshoot without more details.

These guys have some guidelines about troubleshooting DNN which you may find useful:

http://www.dnnhero.com/Premium/Tuto...e-Part-1-5

Andy