How to add Microsoft AdventureWorks2012 Data File to SQL Server

Please fallow the below steps::

Step 1:Right click > Attach

Step 2:Click 'Add' button.

Step 3:Select the adventureworks database .Then click 'OK'.

 Step 4: Now you can see,AdventureWorks2012 in your left panel(Under the database).

YOU DONE the job.

Problem:SQL Server 2012 install error enabling Windows Feature NetFx3

Enable the .NET Framework 3.5 in Control Panel

1. Press the Windows key on your keyboard, type Windows Features, and press Enter. This brings up the Turn Windows features on or off dialog box. ...
2. Select the .NET Framework 3.5 (includes .NET 2.0 and 3.0) check box, press OK, and reboot your computer if prompted.

Then your computer will automatically update that particular version.Don't forget to connect to the internet before click install button.

More Details:https://msdn.microsoft.com/en-us/library/hh506443(v=vs.110).aspx

Lost SQL Server 2014 BI Tools

In past versions of SQL Server, the BI tool set used to develop SSIS, SSAS, and SSRS solutions was always included as part of the SQL Server installation, in particular under the Shared Features section as shown below(This is introduced with SQL Server 2012.Before that there given name  Business Intelligence Development Studio).

If you try to add data tool to your current SQL Server 2014 as previous SQL Server 2012,It will give.......

........to you.

Following are the steps for check "Is there SQL Server Data tool in SQL Server 2014.."

Therefore you need to install those tools separately.Go to below link and download latest BI tool set.

https://msdn.microsoft.com/en-us/mt429383

Now you are ready to work with SQL Server data tool.