Local Database Runtime error occurred

Question

I have a MVC project (download from here). I can run this without any error from Visual Studio. But if I hosted the project into IIS using a tool (code from here). If I launch the page from web browser, it shows error as "Local Database Runtime error occurred" like below screenshot.

In your dev environment you are pointing to a local instance of Sql Server, right?....now, when you deploy your site to IIS is in another server, am I correct? — Hackerman, Jul 22 '16 at 13:22
[this](http://stackoverflow.com/questions/26248293/sql-network-interfaces-error-50-local-database-runtime-error-occurred-canno) and [this](https://blogs.msdn.microsoft.com/gaurav/2013/12/21/deployment-of-sql-express-localdb-on-iis/) can be helpful for you.. — mmushtaq, Jul 26 '16 at 04:49
[this](https://blogs.msdn.microsoft.com/gaurav/2013/12/21/deployment-of-sql-express-localdb-on-iis/) helped me. Thanks. — Mathivanan KP, Jul 27 '16 at 07:18

Mathivanan KP · Accepted Answer · 2016-07-27T08:39:55.677

0

Edit the applicationHost.config file by adding the below child element into the appPool fixed the issue for me.

<processModel identityType="ApplicationPoolIdentity" loadUserProfile="true" setProfileEnvironment="true" />

File location: C:\Windows\System32\inetsrv\config\applicationHost.config

Example:

<add name="SampleAppPool">
     <processModel identityType="ApplicationPoolIdentity" loadUserProfile="true" setProfileEnvironment="true" />
</add>

edited Jul 27 '16 at 08:39

answered Jul 27 '16 at 07:20

Mathivanan KP

1,979
16
25

Note that if you want to edit this file make sure you use a 64 bit text editor like notepad. If you use a 32 bit one like Notepad++ it will automatically edit a different copy of the file in SysWOW64 instead. – Dipen Dedania Mar 20 '17 at 12:45

Local Database Runtime error occurred

1 Answers1