Hello,

You help is very much appreciated.

I have an Intranet environment that contains tens of apps that use a specific database.

I want to create an Intranet test environment (which will use a test database), by basically copying the existing Intranet environment to a new location.

* I cannot change the connection strings in the applications level since each app stores it differently (some store it in Web.Config, some hard coded, etc….).

 

 

Then, have a layer that sits between the Intranet Apps and SQL SERVER (or inside SQL SERVER itself), that will intercept the connections requests.
Once intercepted, the code will check if the connection request comes from Intranet Test environemnt, and if so, change the connection string on the fly to point to the test database.

The question:

Is there a way in SQL SERVER 2005, to intercept connections, and then, based on the application that requested the connection, modify the connection on the fly (so that if the calling app is from test_Intranet – intercept the connection and change it to point to a test database, otherwise leave the connection as it is (live database).

 

Thank you,

Roy

Report Abuse