title: Connection String for SQL Server 2008 (version 10.0.1600) in Application Configuration File
body: <p>I am new to create connection string and application configuration file. I use an example which showed connection to SQL Server CE using file which is what I do not want instead I want to connect to SQL Server 2008 Standard edition.</p>
  
  <p>While exploring about connection string on several links like <a href="http://www.connectionstrings.com/sql-server/" rel="nofollow">http://www.connectionstrings.com/sql-server/</a> i found that the Connection string uses the Property "Data Source = " and in some places it uses "Server=" which is quiet confusing.</p>
  
  <p>Here is what I have in my application configuration file. </p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name="ShareManagement" 
           connectionString="Data Source=localhost" 
           providerName="System.Data.SqlClient"/&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I want someone to tell me which properties need be used and what should be their respective values. (I am using default sa user as UserID and a password and using SQL Server authentication mode. My SQL Server database is installed on same machine/server on which my Visual Studio solution / application reside).</p>
  
  <p>Ragards.</p>