IIS7 Publish Problems with Database

So after testing your website on Visual Studio and made sure everything is working fine, especially database connections, you now published your new site on IIS7 and to your surprise connections don't work as you've set. Try these following steps..

Open IIS by going to Control Panel > Administrative Tools > Internet Information Services (IIS) Manager. On the left menu, click on Application Pools.

Click on DefaultAppPool and then Advanced Settings...

Click on the Identity selector under Process Model.

Change it to LocalSystem and click Ok.

Now try running your website again and it should have no more connection problems.

-k