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.