Connect Adventureworks DB to Visual Studio 2012

• Oscar_Boots

  Old Hand

  Points: 362

  More actions

  November 17, 2018 at 2:47 am

  #373073

  Hi,
  I've tried various ways of connecting the Adventureworks DB to Visual Studio 2012. 
  Can anyone provide a step by step on how to do this or post a link to a good video?
  Thanks.

• Eirikur Eiriksson

  SSC Guru

  Points: 182916

  More actions

  November 17, 2018 at 2:50 am

  #2013846

  Oscar_Boots - Saturday, November 17, 2018 2:47 AM

  Hi,
  I've tried various ways of connecting the Adventureworks DB to Visual Studio 2012. 
  Can anyone provide a step by step on how to do this or post a link to a good video?
  Thanks.

  We will need versions, locations, authentication methods etc., no way of helping you without the essential information. Describe your environment in full details please.
  😎

• Oscar_Boots

  Old Hand

  Points: 362

  More actions

  November 17, 2018 at 2:56 am

  #2013847

  Thanks Eirikur,
  I have Windows 7 as an O/s, using SQL Server 2012 with Adventureworks 2008R2 but can download whatever version works.
  Does that help?
  If you need anything else, please let me know.
  Thanks Peter

• Eirikur Eiriksson

  SSC Guru

  Points: 182916

  More actions

  November 17, 2018 at 3:55 am

  #2013848

  Oscar_Boots - Saturday, November 17, 2018 2:56 AM

  Thanks Eirikur,
  I have Windows 7 as an O/s, using SQL Server 2012 with Adventureworks 2008R2 but can download whatever version works.
  Does that help?
  If you need anything else, please let me know.
  Thanks Peter

  Recommend that you use the 2012 version of AdventureWorks, several changes between the versions.
  The next thing to do if the server is on your local machine, is to add you user account as an administrator to the SQL Server instance, then point to the instance and use Windows authentication.
  😎

• Oscar_Boots

  Old Hand

  Points: 362

  More actions

  November 17, 2018 at 7:56 pm

  #2013883

  Thanks again,

  Re the info about User account as administrator, do you anything with a step by step approach to do this?
  

  .....to add you user account as an administrator to the SQL Server instance, then point to the instance and use Windows authentication.

  Thanks

• Eirikur Eiriksson

  SSC Guru

  Points: 182916

  More actions

  November 18, 2018 at 7:49 am

  #2013889

  Oscar_Boots - Saturday, November 17, 2018 7:56 PM

  Thanks again,

  Re the info about User account as administrator, do you anything with a step by step approach to do this?
  

  .....to add you user account as an administrator to the SQL Server instance, then point to the instance and use Windows authentication.

  Thanks

  Google is your friend here, if you're unsuccessful, ping back.
  😎

• Oscar_Boots

  Old Hand

  Points: 362

  More actions

  November 18, 2018 at 3:09 pm

  #2013911

  I've already been all over the internet, the info I've found bypasses the actual connection part which is why I'm on the forum. 
  If you can't help or don't know, that's fine but my question asks for any sources of info or a step by step instruction.
  Has anyone out there seen a video or instruction to connect Adventureworks to Visual Studio?
  Thanks