Error 50 local database runtime error occurred

• Remove From My Forums

SQL Network Interfaces, error: 50 — Local Database Runtime error occurred

• Question

• I installed the new version of SQL but I am still getting this same error : 

  

  

  //Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
   //string temp = @"Data Source=MOXL0063TEW_SQLEXPRESS; Integrated Security = True";
   string temp = @"Data Source=(LocalDB)v11.0;AttachDbFilename='C:App_DataWrestling.mdf';Integrated Security=True";
  // string temp = @"Data Source=(LocalDB)MSSQLSERVER;AttachDbFilename='C:App_DataWrestling.mdf';Integrated Security=True";

  but nothing is working… why?

  A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)
  

  I have a service that can pull data from a (LocalDB)MSSQLLocalDB database.
  This works fine on my computer, but then I run the service on my AWS server and it does not work

• Remove From My Forums

• Question

• From Robert Luongo @RobertLuongo via Twitter

  I got stuck at the point when you need to run the update-database command on the NuGet Package Console. I have followed all exact instructions, and the default connection string that has been created is as follows. <add name=»DefaultConnection»
  connectionString=»Data Source=(LocalDb)MSSQLLocalDB;AttachDbFilename=|DataDirectory|aspnet-ContactManager-20160302022257.mdf;Initial Catalog=aspnet-ContactManager-20160302022257;Integrated Security=True» providerName=»System.Data.SqlClient»
  />.

  When I run the update-database command I get the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct
  and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 — Local Database Runtime error occurred. The specified LocalDB instance does not exist. Using NuGet Package Manager 3.3.0 with Visual Studio 2015 Community
  Version 14.0.24720.00.

  EDIT: This is now sorted !!

  Issue was as you anticipated the NuGet Package Manager was not able to create the instance specified in the DefaultConnection string. Data Source=(LocalDb)MSSQLLocalDB. I changed it to Data Source=(LocalDB)v11.0 and it now works, probably this is how the
  instance should be specified when using SQL Express Edition ??

  Thanks,
  @AzureSupport

  ---

  Thiene Schmidt

  • Edited by

    Thursday, March 3, 2016 11:33 AM

score:127

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

score:1

My issue was that i had multiple versions of MS SQL express installed. I went to installation folder C:/ProgramFiles/MicrosoftSQL Server/ where i found
3 versions of it. I deleted 2 folders, and left only MSSQL13.SQLEXPRESS which solved the problem.

score:2

In my case, we had several projects in one solution and had selected a different start project than in the package manager console when running the «Update-Database» Command with Code-First Migrations.
Make sure to select the proper start project.

score:2

 <add name="DefaultConnection" connectionString="Data Source=(LocalDb)v12.0;AttachDbFilename=|DataDirectory|aspnet-Real-Time-Commenting-20170927122714.mdf;Initial Catalog=aspnet-Real-Time-Commenting-20170927122714;Integrated Security=true" providerName="System.Data.SqlClient" />

score:3

score:4

score:4

I ran into the same problem. My fix was changing
<parameter value="v12.0" />
to
<parameter value="mssqllocaldb" />
into the «app.config» file.

score:8

connectionString="Data Source=(LocalDB)v12.0;....

score:18

C:>sqllocaldb stop MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" stopped.
 
C:>sqllocaldb delete MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" deleted.
 
C:>sqllocaldb create MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" created with version 13.0.1601.5.
 
C:>sqllocaldb start MSSQLLocalDB
LocalDB instance "MSSQLLocalDB" started.

score:25

Possible Issues

 1. `cmd> Sqllocaldb.exe i` 
 2. `cmd> Sqllocaldb.exe s "whicheverVersionYouWantFromListBefore"` 
if this step fails, you can delete with option `d` cmd> Sqllocaldb.exe d "someDb"
 3. `cmd> Sqllocaldb.exe c "createSomeNewDbIfyouWantDb"` 
 4. `cmd> Sqllocaldb.exe start "createSomeNewDbIfyouWantDb"`

// SQL SERVER RECENT VERSIONS
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server(instance-name)

// OLD SQL SERVER
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesMSSQLServer
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer
// SQL SERVER 6.0 and above.

HKEY_LOCAL_MACHINESystemCurrentControlSetServicesMSDTC
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesSQLExecutive
// SQL SERVER 7.0 and above

HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesSQLServerAgent
HKEY_LOCAL_MACHINESoftwareMicrosoftMicrosoft SQL Server 7
HKEY_LOCAL_MACHINESoftwareMicrosoftMSSQLServ65

SELECT registry_key, value_name, value_data  
FROM sys.dm_server_registry  
WHERE registry_key LIKE N'%SQLAgent%';

DECLARE     @SQL VARCHAR(MAX)
SET         @SQL = 'DECLARE @returnValue NVARCHAR(100)'
SELECT @SQL = @SQL + CHAR(13) + 'EXEC   master.dbo.xp_regread

 @rootkey      = N''HKEY_LOCAL_MACHINE'',
 @key          = N''SOFTWAREMicrosoftMicrosoft SQL Server' + RegPath + 'MSSQLServer'',
 @value_name   = N''DefaultData'',
 @value        = @returnValue OUTPUT; 

 UPDATE #tempInstanceNames SET DefaultDataPath = @returnValue WHERE RegPath = ''' + RegPath + '''' + CHAR(13) FROM #tempInstanceNames 

 -- now, with these results, you can search the reg for the values inside reg
 EXEC (@SQL)
 SELECT      InstanceName, RegPath, DefaultDataPath
 FROM        #tempInstanceNames

SELECT registry_key, value_name, value_data  
FROM sys.dm_server_registry  
WHERE registry_key LIKE N'%SuperSocketNetLib%';  

score:36

<add name="ASP.NET v4.0" autoStart="true" managedRuntimeVersion="v4.0"     managedPipelineMode="Integrated">
    <processModel identityType="ApplicationPoolIdentity" loadUserProfile="true" setProfileEnvironment="true" />
</add>

score:42

Related Query

• Why am I getting this database connectivity error in SQL Server?
• C# local database update error
• Error when trying to insert data to a SQL Server database through a C# application
• C# connection to SQL database error
• I´m trying to make a login from a sql database but keep getting this error
• Error when restoring SQL Server database from C#
• Connecting to local SQL Server CE database issue?
• Saving records into database throws runtime error in ASP.Net C#
• Azure SQL database backup to local server in weekly automatically
• Connect to a SQL Server database on another network via asp.net and c#
• SQL database creation error while executing «ExecuteNonQuery» in C#
• What is the best local sql database for a .net client application?
• Entity Framework returns empty data for a local database that shows data in SQL Server Object Explorer
• Error with adding records to SQL Server database (nvarchar)
• «A non-recoverable error occurred during a database lookup» on Windows 7 with KB4103718 in Dns.GetHostAddresses()
• Even after i specify login credentials in a connection string, users are still getting an error that their user cannot access a database
• Cannot copy database from solution to local package folder on UWP
• Local SQL Server database in Visual Studio 2017 C# (‘Incorrect syntax near the keyword ‘FROM»)
• An arithmetic overflow error occurred while converting varchar to numeric data type in SQL Server 2008
• Error connecting to Local Database con.open()
• ADO.NET : Error occurred while establishing a connection to SQL Server
• CreateUserWizard error during SetPropertyValue: Unable to connect to SQL Server database
• What’s the Concept of local database of sql server in .net
• Trying to connect to an Microsoft Sql database but get error instead
• Cannot insert data into SQL Server database
• I can’t connect to my local SQL Server database
• error deploying C# project with sql database : unable to open physical file
• How should I handle «&» in StringBuilder as later this is being used as XML and parsing that XML throws error in SQL Server database
• SQL Server connection string error cannot connect
• Where is the error in my syntax? Getting values from SQL Server database

More Query from same tag

• Resolving using Autofac within an object
• Retrieving Windows 8 product key
• How can set right-to-left align in devexpress gridcontrol component?
• Trouble loading images not in application folder Images
• Why am I likely to be getting an error in GDI in a c# screen recording app?
• Referencing a .Net Core 3.1 project from a .Net Standard Class Library
• Displaying an image in a foreach
• How can I change a cell of a DataGrid depending on the data it is bound to using MVVM?
• Add some extra work to SaveChangesAsync
• WPF — language changes only in MainWindow?
• Null Reference Exception when object is clearly defined
• SQL/C# Get ID of the row affected by Insert
• What does it mean to filter a collection ‘vertically’ and ‘horizontally’?
• How drag & drop and resize comnponents dynamically ASP.NET?
• ‘Session’ does not exist in the current context. How can I use it?
• Telling *.csproj formats apart
• Minify dynamically generated JavaScript at runtime for ASP.NET Core
• Self referencing loop detected for property when inserting into database
• Why does my Application.Exit(); call fail?
• what this code mean in wcf
• Perform Select at odd positions in the string
• Is there a way to internally set an object equal to a reference?
• Get Worksheets in Excel Workbook without opening file
• In SOAP i got a property as a json. How to pull properties from there and make new string
• Data type confusion when inheriting ToString() from base class
• Create JavaScript element within razor foreach loop
• SharePoint running a method when item added to a library
• Elements in list are getting overwritten when adding to list
• How to make a simple «encrypted» password in an ASP.NET MVC application?
• C# — Variable with 2 arguments, by string

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Exception message:
Scaffold-DbContext "Server=(localdb)\desktop-ne78ema;Database=Test2;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Specified LocalDB instance name is invalid.
) ---> System.ComponentModel.Win32Exception (0x89C5011B): Unknown error (0x89c5011b)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.EntityFrameworkCore.SqlServer.Scaffolding.Internal.SqlServerDatabaseModelFactory.Create(DbConnection connection, IEnumerable`1 tables, IEnumerable`1 schemas)
   at Microsoft.EntityFrameworkCore.SqlServer.Scaffolding.Internal.SqlServerDatabaseModelFactory.Create(String connectionString, IEnumerable`1 tables, IEnumerable`1 schemas)
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.ReverseEngineerScaffolder.ScaffoldModel(String connectionString, IEnumerable`1 tables, IEnumerable`1 schemas, String namespace, String language, String contextDir, String contextName, ModelReverseEngineerOptions modelOptions, ModelCodeGenerationOptions codeOptions)
   at Microsoft.EntityFrameworkCore.Design.Internal.DatabaseOperations.ScaffoldContext(String provider, String connectionString, String outputDir, String outputContextDir, String dbContextClassName, IEnumerable`1 schemas, IEnumerable`1 tables, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContextImpl(String provider, String connectionString, String outputDir, String outputDbContextDir, String dbContextClassName, IEnumerable`1 schemaFilters, IEnumerable`1 tableFilters, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContext.<>c__DisplayClass0_1.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
Stack trace:

Console.WriteLine("Hello World!");