Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013

Click here for the download link for Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013  – this installs Microsoft SQL Server Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services that support Visual Studio 2013, SSIS 2012/2014 etc.

Installing Microsoft SQL Server 2014

Below shows a step by step install of Microsoft SQL Server 2014 which was releases on April 1st 2014. in pictures with some notes.

Notes:

For a server install, Microsoft recommends using separate domain accounts for each sql service. Below setup is the same for a server environment install, but works best for a developer workstation. Also, for a stand alone sql server, you will want to place the mdf, ldf, backup files in separate sas,san, ssd, raid configured san setup uptimally for the individual files you are storing.

4-15-2014 9-19-13 PM

4-15-2014 9-19-41 PM

4-15-2014 9-20-16 PM

4-15-2014 9-20-44 PM

4-15-2014 9-21-34 PM

4-15-2014 9-22-08 PM

4-15-2014 9-23-22 PM

4-15-2014 9-24-23 PM

4-15-2014 9-25-16 PM

4-15-2014 9-25-31 PM

4-15-2014 9-26-19 PM

4-15-2014 9-27-05 PM

4-15-2014 9-27-45 PM

4-15-2014 9-28-17 PM 4-15-2014 9-29-00 PM

4-15-2014 9-29-50 PM 4-15-2014 9-30-05 PM

4-15-2014 9-30-38 PM

4-15-2014 9-44-55 PM

4-15-2014 9-52-23 PM

4-15-2014 9-18-29 PM

Below shows SQL Server Configuration Manager 2014.  Remember to enable TCP/IP and restart the SDE and SSA – SQL database and sql server agent engines.

 

4-15-2014 10-10-04 PM

 

4-15-2014 10-11-15 PM