1

So on my development machine I have SQL Server Express and Visual Studio installed. I finished creating the application and everythings working. Here is the connection string in the App.config file:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="ColegioDBEntities"
         connectionString="metadata=res://*/Repositories.ColegioModel.csdl|res://*/Repositories.ColegioModel.ssdl|res://*/Repositories.ColegioModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;Initial Catalog=ColegioDB;Integrated Security=True;MultipleActiveResultSets=True&quot;"
         providerName="System.Data.EntityClient" />
  </connectionStrings>

  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" />
  </startup>
</configuration>

I created an installation project and want to install the application on a Virtual Machine (to simulate deployment conditions) which is on the same network as where the SQL Server Express is installed. What would the connection string be? Like, 192.168.2.102/SQLExpress?

Any ideas?

  • The first thing you should check is are you able to ping the machine with the database from your VM? Next if you have SSMS installed on your VM can you use it to connect to the database from your VM? The Data Source portion of your connection string will be "ip\SQLExpress" or machinename\SQLExpress. Where ip and machinename are the ip and netbios name of the machine running the database server – Shiv Kumar Feb 07 '11 at 18:57

2 Answers2

0

surely the IP address or host name will be needed then the instance name of SQL Express. Consider that by default SQL Express is installed with tcp and named pipes disabled so you have to enable those facilities in the configuration manager before you could access it remotely from another machine.

Davide Piras
  • 43,984
  • 10
  • 98
  • 147
  • "surely the IP address or host name will be needed then the instance name of SQL Express" That's the question. ;) What would that ipadress+hostname look like? Example? –  Feb 07 '11 at 13:59
0

The sql connection string is part of the "connectionString" attribute and is encoded as a substring with masked quotes:

provider connection string=&quot;Data Source=.\SQLEXPRESS;Initial Catalog=ColegioDB;Integrated Security=True;MultipleActiveResultSets=True&quot;

so the config for your ip adress must look like:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="ColegioDBEntities"
         connectionString="metadata=res://*/Repositories.ColegioModel.csdl|res://*/Repositories.ColegioModel.ssdl|res://*/Repositories.ColegioModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=192.168.2.102\SQLEXPRESS;Initial Catalog=ColegioDB;Integrated Security=True;MultipleActiveResultSets=True&quot;"
         providerName="System.Data.EntityClient" />
  </connectionStrings>

  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0" />
  </startup>
</configuration>
Rezun
  • 93
  • 3