Ok, Im having some problems with a simple web app hosted on a server with SQL Server installed. I believe the proper term is my project is "Remotely Deployed". Anyways...

After I deploy the web app (using a proper deploy project), the Web.config file has an app settings section for such things as ado connection strings:
[add key="some sql connection object" value="connection string blah blah"]

where "connection string blah blah" is some sort of dynamic string to use for my sql connection object.

Now my question!!
--> Can this string be modified on the server it was installed to AFTER DEPLOYMENT?

(I am getting tired of re-compiling my project and going to the server, installing again, just to find a connection string that works!!)

I appreciate any knowledge here, john.