Connection String Configuration

Question

I have number of web instances in IIS server, where these websites uses connection strings to connect to the SQL Server data.

There is single web.config file for all the website where there resides connection string which used by these websites.

Few websites have its own web.config file where these uses connection string from this rather than using from common web.config.

My doubt it, when we take the properties tab and click on general. We can see Connection Strings over there with the values. We can create and edit those.

Is this related to the connection string in web.config? If we edit it ,,will this effect in web.config? How can we know which web.config this value is showing in IIS setting , whether in common web.config or web.config of individual web instance folders? can we add a new connection string in IIS rather than adding in Web.config file?

Answer 1

Settings edited via the web application ASP.net properties interface will edit or create a web.config file at the point in the web server tree the application properties box was opened.

It is inherited from above, it will be inherited downwards, and it will override any inherited settings that it specifies.

This took me all of 3 minutes to establish, by...doing it.