CODEWITHSUNDEEP
sql-servervisual-studio
Ouerghi Yassine
Ouerghi Yassine

Reputation: 1887

Visual Studio 2015 cannot connect to SQL Server LocalDB

I'm just starting to learn C# and Entity Framework 6 ... and it's already far worse than I expected.

I have created a simple new project, and added EF6, while creating to database with Update-Database, I get:

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: 26 - Error Locating Server/Instance Specified)

I haven't changed any config or anything, just created some classed and wanted to generate the database, here is the default connection factory: 

<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
    <parameters>
        <parameter value="MSSQLLocalDB" />
    </parameters>
</defaultConnectionFactory>

I even checked if the instance is running by running this command: 

sqllocaldb info

which resulted in: 

MSSQLLocalDB
ProjectsV13

and same for this: 

SqlLocalDB.exe start
LocalDB instance "MSSQLLocalDB" started.

I have even tried to disable the firewall ... but nothing.

EDIT: App.config: 

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="MSSQLLocalDB" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
</configuration>

Upvotes: 0

Views: 519

Answers (1)

King Jk
King Jk

Reputation: 1089

after i saw your project you just need change the app.config connectionStrings 

<connectionStrings>
<add name="masterEntities"
     connectionString="data source=(localdb)\MSSQLLocalDB;initial catalog=master;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework;"
     providerName="System.Data.SqlClient" /></connectionStrings>

Upvotes: 1

Related Questions