Last post Sep 19, 2017 02:53 AM by Jean Sun
Sep 18, 2017 10:26 AM|snivas|LINK
We are migrating ASP.NET( IIS6) to azure cloud flatform.
Here issue is we don't have data which application connecting to which database server and which database.
we need help from experts ...Is there any script available to collect the all database connecting string information from IIS servers(all websites) ?
if it available please share.
Thanks in advance
Sep 18, 2017 11:10 AM|PatriceSc|LINK
You should find this in the web.config file. It could be also hardcoded into the application. Porting an app to a cloud environment likely requires knowing quite in détails how it works and what it needs. Try maybe
If you need further help
https://forums.iis.net/1046.aspx/1?Configuration+Scripting might be better as it is rather on the IIS administration side.
Sep 18, 2017 11:53 AM|snivas|LINK
Thank you PatrceSc for Response.
Most of our web applications, ASP.NET properties tab showing "E:\Inetpub\wwwroot\XXXXXXX\web.config" but when we check the location
we are not finding web.config files ,That means connecting string hard coded in Application ?
or Is there any other place we see database configuration file configured(Physical path).
Sep 18, 2017 01:15 PM|PatriceSc|LINK
Don't remember how it looks like in IIS 6. And E:\Inetpub\wwwroot\XXXXXXX is the folder in which the web site is deployed ? It's surprising you don't have a at least a minimal web.config file. Do you have a web.config file in the parent E:\Inetpub\wwwroot
BTW you are 100% sure all sites are really based on ASP.NET ? Try maybe a disk search for all web.config files starting at E:\Inetpub\wwwroot? It is usually found in the connectionStrings section found in the web.config file (or maybe appSettings if it is
Sep 18, 2017 01:31 PM|snivas|LINK
Thank you very much
I will verify as you suggested... Thanks alot.
Sep 19, 2017 02:53 AM|Jean Sun|LINK
I'm not sure if the IIS 6.0 has the Connection Strings feature in the feature panel as follows. You can check the connection strings of each website by using this feature.
And the following link that talks about the Edit/Add Connection String Dialog Box, please take it as reference.