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

Install SQL Server 2014

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

Hands On With Microsoft Dynamics GP 2015 RTM: Business Analyzer 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.

In my experience, one of the lesser used add-on products for Dynamics GP is Business Analyzer. For the clients I deal with, the majority of them don;t make much investment in creating SSRS reports; instead they use SmartLists, Excel Reports or BI products such as QlikView.

However, even just using the out-of-the-box SSRS reports can make the Business Analyzer program useful, so I figured I’d give a run through of the installation process. Business Analyzer is installed from the same media as Dynamics GP itself. Start setup.exe and, under Additional Products, click on Microsoft Dynamics GP Business Analyzer:

Microsoft Dynamics GP 2015

Continue reading

Hands On With Microsoft Dynamics GP 2015 RTM: Web Services Management Tools 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.

In the last few posts, I’ve covered the installation and configuration of the web services and rounded off with verifying that they are working correctly. The final item I’m going to cover is the optional installation of the Web Services Management Tools; which means the installing the Dynamics Security Console on another machine. Doing this is best practice as it means you don’t have to give access to the server running the web services themselves to all users who might maintain security.

To install the Web Services Management Tools, open the setup.exe from the installation media and, under Additional Products, select Web Services Management Tools:

Microsoft Dynamics GP 2015

Continue reading