title: DotNetNuke Configuration issues for Sql Server 2008 R2
body: <p>I am using the following tools;</p>
  
  <pre><code>Visual Studio 2010 Professional Edition.
  Sql Server 2008 R2
  DotNet DNN_Platform_07.02.01
  Microsoft Windows 7 Ultimate.
  </code></pre>
  
  <p>I have successfully configured DotNetNuke on IIS but when practically installing it creates problem during database connection. In visual studio i use connection string as.</p>
  
  <pre><code>&lt;connectionStrings&gt;
  &lt;clear /&gt;
  &lt;add name="myConnectionString" providerName="System.Data.SqlClient"
  connectionString="Data Source=localhost; Integrated Security=SSPI; Initial Catalog=MyDB"
  &lt;/connectionString&gt;
  </code></pre>
  
  <p>And in the web.config file of my DNN setup i have written my connection string as;</p>
  
  <pre><code>  &lt;connectionStrings&gt;
  &lt;!-- Connection String for SQL Server 2008/2012 Express --&gt;
  
  &lt;add name="SiteSqlServer" connectionString="Server=(localhost);Database=dnn6003; Integrated Security=True;User Instance=True;" providerName="System.Data.SqlClient" /&gt; 
  </code></pre>
  
  <p>
    
      </p>
  
  <pre><code>&lt;add key="SiteSqlServer" value="Server=(localhost);Database=dnn6003;Integrated Security=True;User Instance=True;"/&gt;
  
  &lt;add key="InstallTemplate" value="DotNetNuke.install.config" /&gt;
  &lt;add key="AutoUpgrade" value="true" /&gt;
  &lt;add key="UseInstallWizard" value="true" /&gt;
  &lt;add key="InstallMemberRole" value="true" /&gt;
  &lt;add key="ShowMissingKeys" value="false" /&gt;
  &lt;add key="EnableCachePersistence" value="false" /&gt;
  &lt;add key="HostHeader" value="" /&gt;
  &lt;!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" --&gt;
  &lt;add key="RemoveAngleBrackets" value="false" /&gt;
  &lt;!--optionally strip angle brackets on public login and registration screens--&gt;
  &lt;add key="PersistentCookieTimeout" value="0" /&gt;
  &lt;!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure--&gt;
  &lt;!-- set UsePortNumber to true to preserve the port number if you're using a port number other than 80 (the standard)
      &lt;add key="UsePortNumber" value="true" /&gt; --&gt;
  &lt;!-- Services Framework Tracing is primarily useful for developing and debugging --&gt;
  &lt;add key="EnableServicesFrameworkTracing" value="false" /&gt;
  &lt;add key="InstallationDate" value="2/9/2014" /&gt;
  </code></pre>
  
  <p></p>
  
  <p>with this setting i am getting erros as.</p>
  
  <pre><code>ERROR:Index #: 0
  Source: .Net SqlClient Data Provider
  Class: 20
  Number: 53
  Message: 
  </code></pre>
  
  <p>Have i written my connection string wrong? Any help in this regard will be appreciated</p>