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


2021 Q4 Promotions
Connect with us at Directions EMEA 2021 in Milan!
eOne at Summit North America 2021
Employee Spotlight: Megan Tripp, Business Development Representative
eOne is now compatible with Microsoft Dynamics GP October 2021 Release


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 Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.