How To Deploy The Demo Company In Microsoft Dynamics GP 2010

● Ian Grieve ●  ● 3 Comments   ● 

In the last couple of posts, I showed how to configure the server of Microsoft Dynamics GP by creating the System database and how to create a new company. In this post I’m going to run through deploying the Fabrikam, Inc. demo company.

To create the company, open GP Utilities (Windows Start menu ¯ All Programs ¯ Microsoft Dynamics ¯ GP Utilities) by right clicking and select Run as Administrator. Log in as the SQL System Administrator (sa);

Welcome to Microsoft Dynamics GP Utilities

Continue reading → How To Deploy The Demo Company In Microsoft Dynamics GP 2010

● Categories: Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Create A Company In Microsoft Dynamics GP 2010

● Ian Grieve ●  ● 2 Comments   ● 

In the last post, I showed how to configure the server of Microsoft Dynamics GP by creating the System database. In this post I’m going to run through the company creation process.

To create the company, open GP Utilities (Windows Start menu ¯ All Programs ¯ Microsoft Dynamics ¯ GP Utilities) by right clicking and select Run as Administrator. Log in as the SQL System Administrator (sa);

Welcome to Microsoft Dynamics GP Utilities

Continue reading → How To Create A Company In Microsoft Dynamics GP 2010

● Categories: Dynamics, Excel Reports, GP, GP Utilities, Microsoft, Reporting Services Reports ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

How To Install Microsoft Dynamics GP 2010 – Server Configuration

● Ian Grieve ●  ● 2 Comments   ● 

In the last post I explained how to install the Microsoft Dynamics GP client and in this one I’m going to cover the server configuration. There is no server installation as such, as this can all be done from any client installation of Microsoft Dynamics GP.

To configure the Microsoft Dynamics GP server, right click on GP Utilities and choose Run as Administrator (Windows Start menu ¯ All Programs ¯ Microsoft Dynamics ¯ GP 2010) and log in as the SQL System Administartor (sa);

Welcome to Microsoft Dynamics GP Utilities

Continue reading → How To Install Microsoft Dynamics GP 2010 – Server Configuration

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

How To Install Microsoft Dynamics GP 2010 – Client

● Ian Grieve ●  ● 2 Comments   ● 

Having installed Microsoft SQL Server 2012 into a test environment and created the ODBC for connecting GP to SQL Server the next step is to install the Microsoft Dynamics GP client.

Microsoft Dynamics GP 9 was the last version which had a separate Server and Client installation; all versions since then have had only a single setup utility for both server and client.

When the setup utility (setup.exe) from the Microsoft Dynamics GP installation media is run, the Microsoft Dynamics GP 2010 Bootstrapper Setup will run to install the prerequisites;

Microsoft Dynamics GP 2010 Bootstrapper Setup

Continue reading → How To Install Microsoft Dynamics GP 2010 – Client

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

How To Create An ODBC For Microsoft Dynamics GP 2010

● Ian Grieve ●  ● 9 Comments   ● 

I’ve recently had the need to document the install process for Microsoft Dynamics GP 2010 for a new client so I thought I might as well finish off the task and but turning it into a small series of blog posts, the first of which will cover the manual creation of an ODBC connection.

To connect the Microsoft Dynamics GP client to the databases on SQL Server, an ODBC connection needs to be setup. In an x86 version of Windows this can be done using the ODBC Control Panel applet, but in an x64 version you need to use the x86 version of the ODBC Data Source Administrator.

The easiest way of accessing this is by using the Run window and opening %windir%\SysWOW64\odbcad32.exe;

Run

Continue reading → How To Create An ODBC For Microsoft Dynamics GP 2010

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

I’m On Holiday This Coming Week

● Ian Grieve ●  ● 1 Comment   ● 

Well, this coming week I am off on a holiday to Scotland to take in some of the historic sites and other attractions.

There are a few blog posts scheduled to go up over the coming days (only one of them is GP 2013 related) but there won’t be much interaction with where I have an active hand as I intend to relax as much as possible.

● Categories: Site ● Tags: ,  ● Permalink ● Shortlink ●

How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – How To Install The Web Client

● Ian Grieve ●  ● 2 Comments   ● 

In this post I’m ging to give a run through of the installation process of the web client itself.

To install the web client run the Microsoft Dynamics GP 2013 setup utility and select Web Client from the list;

Microsoft Dynamics GP 2013 setup utility

Continue reading → How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – How To Install The Web Client

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

How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Installing a Self-Signed Certificate In IIS

● Ian Grieve ●  ● 5 Comments   ● 

Now that IIS is installed, we need to create a security certificate for use with the Microsoft Dynamics GP 2013 web client.

In a production environment I would use a proper signed certificate but for testing purposes, I’m going to go with a self signed certificate.

To create a self-signed certificate, open Internet Information Services (IIS) Manager, select the machine running the web site (in my case the machine is called GP2013TEST) and then double click on Server Certificates;

Internet Information Services (IIS) Manager - GP2013TEST Home

Continue reading → How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Installing a Self-Signed Certificate In IIS

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

MDGP 2013 Feature of the Day: Multitenant SQL Server Reporting Services Reports

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The forty fourth feature they’ve announced is Multitenant SQL Server Reporting Services Reports.

The current version of Microsoft Dynamics GP only supports a dedicated instance of SQL Server Reporting Services for each Microsoft Dynamics GP data instance. With the introduction of the Multi-tenant System Database Architecture, the SQL Server Reporting Services needed to be updated to allow for similar functionality.

With this Multi-tenant SQL Server Reporting Services Reports feature, multiple data instances can be deployed to a single SQL Server Reporting Services instance by allowing the implementer to to deploy the reports to a “tenant” folder.

Continue reading → MDGP 2013 Feature of the Day: Multitenant SQL Server Reporting Services Reports

● Categories: Dynamics, GP, Microsoft, Reporting Services Reports ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Web Server Installation

● Ian Grieve ●  ● 4 Comments   ● 

To function the Microsoft Dynamics GP 2013 web client requires a web server running IIS with a web site bound to an SSL certificate.

The operating system of the web server must be one of the following:

  • Microsoft Windows Server 2008 R2
  • Microsoft Windows Server 2012

Once you have installed one of the above, I chose Windows Server 2008 R2 for this install, the Web Server (IIS) role needs to be installed via Server Manager.

Open Server Manager and click the Add Roles link;

Server Manager

Continue reading → How To Install The Microsoft Dynamics GP 2013 (Beta) Web Client – Web Server Installation

● Categories: Dynamics, GP, IIS 7, Internet Information Services (IIS), Microsoft, Web Client ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●