SQL Network Interfaces, error: 50 – Local Database Runtime error occurred. Cannot create an automatic instance

by

Breaking Changes to LocalDB: Applies to SQL 2014; take a look over this article and try to use (localdb)\mssqllocaldb as server name to connect to the LocalDB automatic instance, for example:

<connectionStrings>
  <add name="ProductsContext" connectionString="Data Source=(localdb)\mssqllocaldb; 
  ...

The article also mentions the use of 2012 SSMS to connect to the 2014 LocalDB. Which leads me to believe that you might have multiple versions of SQL installed – which leads me to point out this SO answer that suggests changing the default name of your LocalDB “instance” to avoid other version mismatch issues that might arise going forward; mentioned not as source of issue, but to raise awareness of potential clashes that multiple SQL version installed on a single dev machine might lead to … and something to get in the habit of in order to avoid some.

Another thing worth mentioning – if you’ve gotten your instance in an unusable state due to tinkering with it to try and fix this problem, then it might be worth starting over – uninstall, reinstall – then try using the mssqllocaldb value instead of v12.0 and see if that corrects your issue.

More Related Contents:

  1. How do I update a value in C# and SQL Server? [closed]
  2. How to make an algorithm to get all column names from across tables that relations with their primary key in SQL Server and C#?
  3. Procedure or function xxxxx has too many arguments specified [duplicate]
  4. Call a stored procedure with parameter in c#
  5. Insert 2 million rows into SQL Server quickly
  6. Cannot open database “test” requested by the login. The login failed. Login failed for user ‘xyz\ASPNET’
  7. Getting data from stored procedure with Entity Framework
  8. Avoiding SQL injection without parameters
  9. Why should I use int instead of a byte or short in C#
  10. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  11. Connection timeout for SQL server
  12. What SqlDbType maps to varBinary(max)?
  13. How can I convert ticks to a date format?
  14. Retrieve image from database in asp.net
  15. What is passing parameters to SQL and why do I need it?
  16. Fastest method for SQL Server inserts, updates, selects
  17. How to retrieve binary image from database using C# in ASP.NET
  18. Database Error: There is no row at position 0
  19. Is there any benefit to using SecureString in ASP.NET?
  20. Disable *all* exception handling in ASP.NET Web API 2 (to make room for my own)?
  21. DropDownList AppendDataBoundItems (first item to be blank and no duplicates)
  22. How can I determine browser window size on server side C#
  23. How to Check whether Session is Expired or not in asp.net
  24. How can I calculate/find the week-number of a given date?
  25. How do I set return_uri for GoogleWebAuthorizationBroker.AuthorizeAsync?
  26. Adding StyleSheets Programmatically in Asp.Net
  27. Passing Credentials to Sql Report Server 2008
  28. How to determine total size of ASP.Net cache?
  29. Error handling when downloading file from ASP.NET Web Handler (.ashx)
  30. How do I maintain ModelState errors when using RedirectToAction?

Leave a Comment