Hi Jerry,
The error was not a connection string error, it was actually an error with
IIS settings.
I figured out that the asp application had an issue with anonymous users on
the IIS server.
Here is my fix.
Resolution:
1. Open IIS
2. Go to Default Web Site
3. Right Click on Web Project of interest
4. Select Properties
5. Select Directory Security
6. Go to "Anonymous access and authentication control"
7. Select "Edit"
8. Uncheck "Anonymous access"
9. Select OK
10. Select Apply
11. Select OK
In the Web.config file add the following line after the <system.web> tag and
before the </system.web> end tag
<identity impersonate = "true"/>
Hope that helps,
Alvin