title: How to work with Sql Server and Visual C# 2010
body: <p>I've been at this for many, many hours and I've run into nothing but roadblocks.  All I want to do is to start a project in Visual C# 2010 that connects to a SQL database.  I've always worked with Access databases and I want to learn how to with SQL Server.  Who would have thought it would be this much trouble. </p>
  
  <p>In my programs files (on my home computer) I have Microsoft SQL Server and Microsoft Server Compact Edition. Under Sql server there is a folder <code>80</code>, <code>90</code>, <code>100</code>, <code>110</code>, <code>MSSQL10.SQLEXPRESS</code>. In the Server compact Edition folder there is <code>v3.5</code> &amp; <code>v4.0</code>. I have MS SQL Server Managment Studio (installed &amp; reinstalled 2 times to finally work) and when I open it it says <code>SQL Server 2008 R2</code>.</p>
  
  <p>I Downloaded the <code>Adventuresworks</code> database and finally got it to connect in management studio, but when i try to connect in Visual studio (add new data source) I get errors, wrong version, etc. So I now try connecting using connection string, but I don't know which database to connect to.. nor how to write it. There are multiple databases in <code>C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA</code> from my adventure works install.  </p>
  
  <p>I also read that with Windows Vista there is a permissions issue (only Administrator can install and access databases).</p>
  
  <p>How do I resolve this error?  </p>
  
  <p><img src="https://i.stack.imgur.com/QKXNe.jpg" alt="enter image description here"></p>