Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite

April 5th, 2017 by

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’ve encountered this particular issue around the prerequisites so rarely, that I usually forget to mention it.

When installing the Web Services for Microsoft Dynamics GP there is a step where the SQL Server Connection Information is entered. This is the server where the Dynamics Security data will be stored.

You will receive the following message when clicking Next if the Windows user account you’re logged in as, is not a SQL Server sysadmin:

Invalid SQL Information - The current user must be a member of the sysadmin SQL role.

Invalid SQL Information

The current user must be a member of the sysadmin SQL role.

To apply the sysadmin permissions, open SQL Server Management Studio and connect to the server using an existing sysadmin account, such as sa. If the login for your does not exist create the login or select the one which is there.

Click on Server Roles in the right pane and mark the checkbox next to sysadmin:

Login Properties

Click OK to save the role changes.

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

Hands On With Microsoft Dynamics GP 2016 R2
Install Dynamics GP Client
Deploy System Database
Desktop Client First Run
Create A Company
Install eConnect
Install Integration Manager
Integration Manager First Run
Add Web Client Runtime
Install Web Client Single-Machine Deployment
Configure Web Components
Install Web Components Help
Manage Web Client SQL Server Login
Test Web Client
Install GP Web Resource Cache
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Web Services Runtime SQL Server Prerequisite
Install Web Services Runtime
Configure Web Services
Verify Web Services
Install Companion Application Service
Install GP PowerShell
Use GP PowerShell To Create a Company
Install GP Add-in for Microsoft Word
Install GP OData Service
Configure & Use OData Service
Create Installation Package
Add Service Based Architecture Feature
Install Service Based Architecture Web Components
Configure Web Components For Service Based Architecture
Add Analysis Cubes Client
Install Analysis Cubes Server
Configure Analysis Cubes
SmartList Designer Favorites In Advanced Lookups
SmartList Favourite Protection
Cancel A Purchase Order Linked To A Purchase Requisition
Batch Edited Message
Purchase Requisition Inquiry Icon
Display Tax Percent for Historical Sales Transactions
GL Distribution Line Display UI change
Link Credit Card Invoices To Original Invoice
Receivables & Payables Distribution Line Display UI Change
Bank Reconciliation Tracks History
Bank Reconciliation Tracks History
POP To FA Link Includes Taxes
Save Fixed Assets With Suffix

Read original post Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite at azurecurve|Ramblings of a Dynamics GP Consultant

Source: azurecurve

Leave a Reply