How To Install Microsoft SQL Server 2016: Installing SQL Server Management Studio

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In previous versions of Microsoft SQL Server, SQL Server Management Studio (SSMS) was always part of the standard install, but it seems this has changed with SQL Server 2016.

Instead SSMS is now available as a separate download. I’d recommend downloading the GA rather than any release candidate which might be available:

Download SQL Server Management Studio (SSMS)

Continue reading “How To Install Microsoft SQL Server 2016: Installing SQL Server Management Studio”

How To Install Microsoft SQL Server 2016: SSIS Configuration For Named Instances

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In the last post, I installed SSIS, but if you are using a named Instance of SQL Server, there is a configuration step required.

To make the change, there is a file called MsDtsSrvr.ini which, for SQL Server 2016, is located in C:\Program Files\Microsoft SQL Server\130\DTS\Binn. The ServerName needs to be changed to include the full SQL Server Instance Name (as highlighted below):

MsDtsSrvr.ini file in Notepad

Once the full SQL Server Instance Name was added and the file saved, SSIS is ready to use.

Click to show/hide the How To Install Microsoft SQL Server 2016 Series Index

How To Install Microsoft SQL Server 2016: Installing SQL Server Integration Services

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

When I started the installation of the Analysis Cubes for Microsoft Dynamics GP as part of my ‘Hands On with GP 2016 R2 series, I knew I needed SQL Server Analysis Services (clue was in the name), but I didn’t initially realise that I was going to need SQL Server Integration Services (SSIS) although in retrospect it should have been obvious too.

The reason SSIS is needed, is that the Analysis Cubes in SSAS are populated by integration jobs from SSIS (scheduled using SQL Server Agent).

So I had to come back and install SSIS. You do this by launching the SQL Server setup utility and, under Installation click on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Continue reading “How To Install Microsoft SQL Server 2016: Installing SQL Server Integration Services”

How To Install Microsoft SQL Server 2016: Installing SQL Server Analysis Services

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

I typically don’t install SQL Server Analysis Services (SSAS), but decided to this time as I was installing all of the Microsoft Dynamics GP additional products for my Hands On with Microsoft Dynamics GP 2016 R2 series.

To install SSAS, launch the SQL Server setup utility and click on Installation and then on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Continue reading “How To Install Microsoft SQL Server 2016: Installing SQL Server Analysis Services”

How To Install Microsoft SQL Server 2016: Configuring SQL Server Reporting Services

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In the last post, I installed the SQL Server Database Engine and the Reporting Services, but I did not configure Reporting Services. I mentioned that I have had problems before when doing this, so always do it separately.

To configure SQL Server Reporting Services (SSRS), launch Reporting Services Configuration Manager from the Windows Start menu.

Select the Report Server Instance to connect to and click Connect:

Reporting Services Configuration Connection

Continue reading “How To Install Microsoft SQL Server 2016: Configuring SQL Server Reporting Services”

How To Install Microsoft SQL Server 2016: Installing SQL Server Database Engine

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

In this post, I am going to step through the installation of the Microsoft SQL Server 2016 Database Engine. As most of my work is with Microsoft Dynamics GP, there will be a little focus on the installation required specifically for Dynamics GP, but the basic install is the same regardless of whether it is for Dynamics GP or not.

Launch the SQL Server setup utility (setup.exe), select Installation and click on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Continue reading “How To Install Microsoft SQL Server 2016: Installing SQL Server Database Engine”

How To Install Microsoft SQL Server 2016: Series Index

Microsoft Dynamics GPA new version of SQL Server came out last year, and I’ve been creating some new demo machines for use at work. It has become habit to screenshot everything I install or configure, so I decided I might as well post a small series on how to install Microsoft SQL Server 2016 and it’s component parts.

The posts will be made over the coming days and show in the series index, below:

How To Install Microsoft SQL Server 2016
Installing SQL Server Database Engine
Configuring SQL Server Reporting Services
Installing SQL Server Analysis Services
Installing SQL Server Integration Services
SSIS Configuration For Named Instances
Installing SQL Server Management Studio

The installation of SQL Server has been broken down into different posts, as I don’t install all components all of the time, but only install the ones which are required at the time.