GetLinked® Software Forum

Point of Sale and Financial Systems Integration
It is currently Thu Jul 18, 2019 5:55 am

All times are UTC - 7 hours

Forum rules

Please click here to view the forum rules

Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Mon Jan 20, 2014 10:39 am 

Joined: Wed Jan 11, 2012 5:56 pm
Posts: 89
GETLinked Software installations in Microsoft Dynamics GP sometimes require a small amount of manual SQL configuration to work correctly. The SQL scripts referenced below can be run using the SQL Server Management Studio. We recommend making a fresh backup of the Microsoft Dynamics GP databases before proceeding.

There are two (2) SQL scripts required:
    1. GETLinked_Initial_Tables.sql
    This script creates the initial tables in your Microsoft Dynamics GP system database and should be run BEFORE you install GETLinked Software . This creates the tables used to store your GETLinked Software registration information. If the tables don’t exist Microsoft Dynamics GP will freeze during the login process.

    2. Dynamics_POSLink_Permissions(two).sql
    This script is used to grant permission to the required tables in your company database after they have been created by the GETLinked Software “Create initial tables” setup button. This script must be run against each Microsoft Dynamics GP company database that will be used with GETLinked Software. The script is set to run against the sample company “TWO” and will need to be modified to reference your specific company database.

    To modify the script change the first line “use [TWO]” to reference your company database name. For company database “ABC” the line should be “use [ABC]”.

The two SQL scripts listed above can be downloaded from our support site:

If you need help installing these scripts consult your Microsoft Dynamics GP (GreatPlains) dealer or IT technician.

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 7 hours

Who is online

Users browsing this forum: No registered users and 0 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group

© Copyright 2015 Accounting Solutions, Inc. All rights reserved. GetLinked® is a registered trademark of DEFEDE. Other product names listed herein are trademarks or registered trademarks of their respective companies.