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.
Tag: 2013
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.
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.