title: The underlying provider failed on Open in SQL Server 2008 remotely
body: <p>The underlying provider failed on Open in SQL Server 2008  remotely </p>
  
  <pre><code>SqlConnectionStringBuilder sqlBuilder =new SqlConnectionStringBuilder();
  sqlBuilder.DataSource = "mary\SQL2008";
  sqlBuilder.InitialCatalog = "StudentDB";
  sqlBuilder.IntegratedSecurity = true;
  sqlBuilder.UserID = "sa";
  sqlBuilder.Password = "mar";
  sqlBuilder.MultipleActiveResultSets = true;
  sqlBuilder.IntegratedSecurity = true;
  sqlBuilder.ApplicationName = "EntityFramework";
  string providerString = sqlBuilder.ToString();
  
  EntityConnectionStringBuilder entityBuilder =new  EntityConnectionStringBuilder();`enter code here`
  entityBuilder.Provider = "System.Data.SqlClient";
  entityBuilder.ProviderConnectionString = providerString;
  entityBuilder.Metadata = "res://*/Student.csdl|res://*/Student.ssdl|res://*/Student.msl";
  EntityConnection en = new  EntityConnection();
  </code></pre>