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

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

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

1 thought on “Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite

Leave a Reply

Your email address will not be published. Required fields are marked *