iis express mysql配置,本地IIS无法连接本地数据库

I am using a db from (localdb)\V11.0 server and able to connect successfully when using IIS express from VS2013, but when deployed in LocalIIS, it gives me an error below -

A network-related or instance-specific error occurred while

establishing a connection to SQL Server. The server was not found or

was not accessible.

In order to fix that I have updated applicationHost.config file as below

Now, though database is not connected, it has displayed a home page, but all data-driven dropdown values are empty. I have also tried changing Application pool to LocalSystem but website unable connect db. Is there any specific area that I need to investigate?

解决方案

To get local db running with IIS on my machine, I followed the guidance in this msdn blog

The solution that worked best for me was to configure IIS application pools to run as my windows user.

This is done via the IIS interface. In the "Application Pools" section, right click on one (or more) and choose "Advanced Settings". Choose "Identity" and "Custom" then enter your username and password.