Appendix B: Windows Integrated Security
A typical installation creates a user ASPNET and gives it access to the Transaction Insight database. The password for ASPNET is stored in the Web.config file on the web server
You can avoid storing this sensitive information in Web.config by using Windows Integrated Security. In that case, the username will be the one that is running the web server.
You will need to give that username access to the Transaction Insight database:
-
Edit the XML file Web.config on the web server machine.
Look for <appSettings> and replace the UID and PWD entries with Integrated Security=true
-
On the database machine, check SQL Server Login to be sure that the user that will run the web server has owner privileges for the Transaction Insight database. In this example, the Transaction Insight database is called TIWEB and the user running the web server is ASPNET.