Install SQL Server 2014: SSRS Configuration for Microsoft Dynamics GP

Microsoft Dynamics GPIn the previous two posts, I stepped through the installation and configuration of SSRS. To deploy the Microsoft Dynamics GP SSRS reports to the SSRS server there is one last piece of configuration which needs to be completed.

There is a setting in the web.config file which needs to be added for the reports to deploy successfully. I have previously blogged about that setting here. The only change in the path will be the version number in the folder name will be higher.

Once you have completed that step you can then move onto deploying the SSRS reports in Dynamics GP; this post was written on Dynamics GP 2010 R2, but the process for deploying them is the same in Dynamics GP 2015.

Click to show/hide the Install SQL Server 2014 Series Index

Install SQL Server 2014
SQL Server Installation
SSRS Installation
SSRS Configuration
SSRS Configuration for Microsoft Dynamics GP

Install SQL Server 2014: SSRS Configuration

SQL ServerIn this small series of posts I’m going to take a step through the installation of SQL Server 2014 and SSRS (the series index can be found at the bottom of each post).

In the last post, I stepped through the installation of SSRS. As I mentioned in that post, I prefer to do the configuration separately, as I have had problems with the automatic configuration.

To configure SSRS, launch Reporting Services Configuration Manager from the Windows Start screen.

The first window launched is the Reporting Services Configuration Connection one; ensure the Server Name is correct and that the Report Server Instance is the one to be configured and click Connect:

Reporting Services Configuration Connection

Continue reading

Install SQL Server 2014: SQL Server Installation

Microsoft Dynamics GPIn this small series of posts I’m going to take a step through the installation of SQL Server 2014 and SSRS (the series index can be found at the bottom of each post).

The first item I’m going to cover is SQL Server itself; I have had problems before installing and configuring SSRS at the same time as SQL Server, so I now always separate these into three separate steps.

The first part is to install SQL Server; do so in SQL Server Installation Center by launching the setup.exe from the installation media:

SQL Server Installation Center - Planning

Continue reading

Install SQL Server 2014: Series Index

Microsoft Dynamics GPI thought I had posted this a while ago, but it seems not. This is a short series on the installation of SQL Server 2014 as it would need to be installed for Microsoft Dynamics GP.

Click to show/hide the Install SQL Server 2014 Series Index

When Installing The Web Client Reboot Your Server First

Microsoft Dynamics GPThis probably seems like an obvious one, but when you’re going to install the web client for Microsoft Dynamics GP make sure that any previous installs have had a reboot done.

I had this come up recently when trying to do an install. Earlier that day I had installed a new feature on the server (in this case the Windows Authentication feature of the Internet Information Services IIS role), but not done a reboot as one wasn’t asked for.

However, the web client installation ended prematurely and it was only when I checked the Windows Event Viewer that I found the error relating to the pending reboot.

This was particularly annoying as the premature end was only after I clicked on the Install button after entering all of the required information at the preceding steps.

Based on this error, and when it appeared, from now on I am going to reboot the server I’m installing the web client before starting.

Hands On With Microsoft Dynamics GP 2015 RTM: Installing GP PowerShell

Microsoft Dynamics GPNow that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts on how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here.

Microsoft Dynamics GP 2015 has seen the introduction of some PowerShell cmdlets. This is something new in the Dynamics GP arena which I am going to need to investigate. The first step in this, is to install GP PowerShell. This is done by starting the setup.exe on the GP 2015 installation media and, under Additional Products, select GP PowerShell:

Microsoft Dynamics GP 2015

Continue reading

Hands On With Microsoft Dynamics GP 2015 RTM: Installing the Microsoft Dynamics GP Add-in for Microsoft Word

Microsoft Dynamics GPNow that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts on how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here.

One of the very useful additions in Microsoft Dynamics GP 2010 was the ability to create invoice, remittance and other types of documents in a Word Template rather than having to do it all in Report Writer (although Report Writer is still needed if you want to create a custom field or make other fields available to the Word Template). While much of the editing and changing of formatting can be done using Word as is, if you want to add any new fields then the Microsoft Dynamics GP Add-in for Microsoft Word is required on any machine which will be used for doing this.

To install the Microsoft Dynamics GP Add-in for Microsoft Word open the setup.exe from the Microsoft Dynamics GP 2015 installation media and, under Additional Products, select Microsoft Dynamics GP Add-in for Microsoft Word:

Microsoft Dynamics GP 2015

Continue reading

Hands On With Microsoft Dynamics GP 2015 RTM: Integration Manager First Run

Microsoft Dynamics GPNow that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts on how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here.

The first run of Integration Manager is something needed on each client. When staring Integration Manager for the very first time it is important to Run as Administrator.

When Integration Manager starts for the first time, you will be prompted to Register Now or Register Later; if you choose the latter option, Integration Manager will close:

Integration Manager

Continue reading

Hands On With Microsoft Dynamics GP 2015 RTM: Integration Manager Installation

Microsoft Dynamics GPNow that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts on how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here.

Integration Manager is a handy tool to have around; it allows easy integration of CSV or text files from a multitude of sources (once a suitable integration template has been created).

Its installation process is straightforward. Start the steup.exe and, under Additional Products select Integration Manager:

Microsoft Dynamics GP 2015

Continue reading

Hands On With Microsoft Dynamics GP 2015 RTM: Install Trusted Configuration

Microsoft Dynamics GPNow that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts on how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here.

The Microsoft Dynamics GP web client is as functional as the desktop one, even to the extend to which it integrates with Microsoft Office. However, whenever a user wants to integrate with Office on their machine, they first need to install a new component which allows the Silverlight web client to interact i the user’s installation of Microsoft Office.

To do this click on the padlock/globe/page icon next to the blue help icon in the bottom right of the window and then click on the Install Trusted Configuration link:

Trusted Application

Continue reading