Skip to content


SmartConnect and Active Directory

SmartConnect 2010 uses Active Directory-based security instead of SQL security. This has caused some confusion among partners who are used to the ‘sa’ user being able to access everything. We have received calls from partners who are frustrated because the ‘sa’ user cannot get into SmartConnect Setup or SmartConnect security.

During the initial installation of SmartConnect, one of the last steps after launching Great Plains should be to go into Tools – SmartConnect – Security. If there are no users configured, a window will pop open informing the user that there are no users setup, and asks if you would like to setup the current user as an administrator. When the user clicks OK, it adds the users Windows login as an administrator and not their SQL or Great Plains login.

This user will then be able to access SmartConnect security setup, and should add the additional domain users to SmartConnect security. The user lookup is actually looking for Active Directory domain users and not SQL users.

If no users are unable to access SmartConnect setup or security, you need to find out who the SmartConnect administrator is by: logging into SQL Server Management Studio and running a select query on Users table in the SmartConnect database. Any domain user listed there that has the “IsAdmin” checkbox marked is an Administrator in SmartConnect. If you log out of Windows, and log back in as that user, you then will be able to access SmartConnect security and add additional users.

There are a number of reasons why SmartConnect is configured to work with AD. The primary reason being that many of the users that will execute a map (especially via Excel or other remote applications) may not have any login access to GP. In order to control access for these users the security needs to be based on something other than traditional GP security.

1 Comment

  1. AnnB on April 29, 2016 at 11:59 am

    I’ve followed the above and determined non of the folks who are designated as admin in the ‘users’ table are still at the company I’m working with. Any work arounds here?

Leave a Comment


Popdock Data Lake Upload Tool for Dynamics NAV Data - FREE TRAINING
US Office Closed, Memorial Day - May 29, 2023
Accessing Historical Dynamics GP Data in NetSuite: The Azure Data Lake
New Webinar Series: What is the Azure Data Lake?
UPCOMING WEBINAR: Top 10 New Popdock Features


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.