title: Can't connect to SQL Server from asp.net application
body: <p>Hi i want to publish my application in a IIS server.</p>
  
  <p>First i create a database in my sql server and put all my needed data on it.</p>
  
  <p>Then i update my <code>web.config</code> to use the new remote Database. Unfortunatly i get an error</p>
  
  <p>ConnectionString:</p>
  
  <pre><code>&lt;add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=IntranetDatabase;Data Source=SRVDEV2010\SRVDEV2010" /&gt;
  </code></pre>
  
  <p>Stacktrace :</p>
  
  <pre><code> [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: 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.)]
  </code></pre>
  
  <p>I cheked if i can access database remotly. I create a <code>udl</code>file to verify my <code>connectionstring</code>, Here is the result.</p>
  
  <p><img src="https://i.stack.imgur.com/cEZh7.png" alt="enter image description here"></p>
  
  <p>I don't know why the udl file can connect but not my application. Any help is appreciated</p>