If you configure your
<!--
If your database uses Windows Authentication and resides on a separate server, you will need to use the settings below, and replace the userName and password with a specific windows user that has access to SQL Server. If the database and web server reside on the same machine, then the line above is sufficient.
<identity impersonate="true" userName="administrator" password="password"/>
-->
The section will look like the example below after modification:
<!--
If your database uses Windows Authentication and resides on a separate server, you will need to use the settings below, and replace the userName and password with a specific windows user that has access to SQL Server. If the database and web server reside on the same machine, then the line above is sufficient.
<identity impersonate="true" userName="administrator" password="password"/>
-->
<identity impersonate="true" userName="windowsUserName" password="password"/>
The user set up as the impersonation user must have db_owner rights to your
Replace windowsUserName with the user name that has access to the
The password will be in clear text and can be read by anyone who has access to the Web.config file.
For security purposes, we recommend you encrypt the user name and password and store them elsewhere. For instructions, visit http://support.microsoft.com/kb and see article #329290.