This is 2nd day I'm spending on this sql server problem! long story short, I have downloaded/installed sql server 2014 express version on my windows 8.1 operating system. sql server works fine however when I get in it and create tables or etc, when I run asp.net (mvc 4) and click on login page or register page it throws following error:
error: 50 - Local Database Runtime error occurred. Cannot create an automatic instance. See the Windows Application event log for error details.
I have searched in stackoveflow and also msdn, few other forums but did not find a specific and solution to nail this down.
on my machine I have:
SQL SERVER (MSSQLSERVER) service running (Automatic) Microsoft LocalDB is installed
However, SQL Server Browser stopped SQL Server Agent stopped
every time I am trying to restart or start them I get this message:
The service cannot be started, either because it is disabled or because it has no enabled device associated with it[0x80070422]
I also tried this solution but it didn't help. please see this URL
http://www.aspneter.com/2013/08/error-50-local-database-runtime-error-occurred/
Can this be something in web.config?
any help will be appreciated greatly.
Thanks. amit
Ok the problem is resolved by downloading Microsoft SQL Server 2012 SP1 Feature Pack. Service Pack SP1
User contributions licensed under CC BY-SA 3.0