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

● Ian Grieve ●  ● 0 Comments   ● 

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

● Categories: Microsoft, SQL Server, SQL Server 2016, SSIS 2016 ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

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

● Ian Grieve ●  ● 0 Comments   ● 

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

● Categories: Dynamics, GP, Microsoft, SQL Server, SQL Server 2016, SSRS 2016 ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft SQL Server 2016: Series Index

● Ian Grieve ●  ● 13 Comments   ● 

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.

● Categories: Microsoft, SQL Server, SQL Server 2016, SSAS 2016, SSIS 2016, SSRS 2016 ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes

● Ian Grieve ●  ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In the last post, I installed the Analysis Cubes server. The next step is to configure the Analysis Cubes.

There are a choice of three Analysis Cubes Configuration Wizards available, one for each of the supported versions of SQL Server. I have selected the SQL Server 2016 version as this is the version of SQL Server I have installed:

Analysis Cubes Configuration Wizards

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes

● Categories: Analysis Cubes for Excel, Dynamics, GP, Microsoft ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Configure Web Components For Service Based Architecture

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Service Based Architecture (SBA) is a feature introduced in Microsoft Dynamics GP 2015 RTM which provides a REST web service which exposes Dynamics GP business logic as service operations.

The installation is a three part process, the previous but one post in this series covered adding the SBA feature to the desktop client on the web server, the previous covered the installation of the SBA web components and this one will cover the configuration.

After the installation of the web components completes, the Microsoft Dynamics GP Web Components Configuration Wizard will automatically launch. Click Next to proceed:

Microsoft Dynamics GP Web Components Configuration Wizard: Welcome

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Configure Web Components For Service Based Architecture

● Categories: Dynamics, GP, Microsoft, Service Based Architecture ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Create Installation Package

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

If you have a number of clients which need Microsoft Dynamics GP installed, this can become somewhat burdensome to ensure that they are all installed exactly the same way; if you do it manually at least. However, via the Microsoft Dynamics GP setup utility, you can build an installation package which much simplifies the job.

To create an installation package, launch the setup utility and select Create Installation Package from under the Install heading:

Microsoft Dynamics GP 2016 setup utility

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Create Installation Package

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Configure & Use OData Service

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

I am not going to cover the configuraion and use of OData in this post, as it is not an area with which I have much experience. However, I know a man who does and I wrote a book with him in 2016:

Microsoft Dynamics GP Cookbook

Mark Polino is one of the three top people for reporting from Microsoft Dynamics GP and, in Chapter 13: Modern Business Intelligence for Microsoft Dynamics GP of the Microsoft Dynamics GP 2016 Cookbook, Mark covered how to configure and use the GP OData Service.

The full outline of topics covered by Mark is as follows:

  • Introduction
  • Activating OData for better external analysis
  • Secure OData to control access
  • Connecting OData to Excel for Business Intelligence
  • Connecting GP to Power BI with OData
  • Adding Power BI to the home page in Dynamics GP

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

● Categories: Dynamics, GP, GP OData Service, Microsoft, Packt Publishing, Publishing ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Use GP PowerShell To Create a Company

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In the last post, I covered the installation of GP PowerShell; in this I’m going to refer back to a Hands On With Microsoft Dynamics GP 2016 R1 post I did back in May 2016 on how to use GP PowerShell to create a company.

Everything in that post is still relevant and unchanged in Dynamics GP 2016 R2.

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

● Categories: Dynamics, GP, GP PowerShell, Microsoft ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Install GP PowerShell

● Ian Grieve ●  ● 5 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Microsoft Dynamics GP has a number of PowerShell cmdlets which can be used to, for example, create new companies. To use these cmdlets, GP PowerShell needs to be installed. Launch the setup utility and select GP PowerShell from under Additional Products:

Microsoft Dynamics GP 2016 setup utility

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Install GP PowerShell

● Categories: Dynamics, GP, GP PowerShell, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Verify Web Services

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Over the last couple of posts, I have installed and configured the Web Services for Microsoft Dynamics GP, it is now time to verify that they are working correctly; there are four items I’d recommend checking.

Firstly, open the Services applet from Computer Management and make sure the Microsoft Dynamics GP Service Host is set to a Startup Type of Automatic and that the service is Running:

Services

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Verify Web Services

● Categories: Dynamics, GP, Microsoft, Web Services ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●