Skip to content


SmartConnect and AD

I had posted on this topic, Security and Active Directory, recently – but wanted to raise it again.

The important concept here is that who you log into GP as – no longer matters. Security is driven by who you log into windows as. I saw a support call today that was based on the following error :

” Could not read the DYNAMICS database. The server may not be accessible or you may not have access”. The customer of couse was adamant that they were logged in as ‘sa’ so should have access. Unfortunately ‘sa’ is irrelevant in this situation. It is all about the user you have logged into Windows as – having access to the SQL server and database describes.

The full answer to the support call was:

It means that the user you are logged into Windows as does not have rights to the Dynamics database.

Do this in management studio.

Select * from [SmartConnect]..[User]

The user you are logged into windows as – must be one of the people marked as an administrator in the SmartConnect security window.


  1. Fred on May 18, 2011 at 11:22 am

    Got a stumper for you.

    What if the active directory account we're logged in as, has admin rights to the Dynamics SQL DB and still we get that error message?

    Any advise is greatly appreciated.

    Our setup consists: Windows domain. Users access Dynamics GP 2010 through Terminal Server Session. Terminal Server is able to connect with SQL server, both apart of

    • Darren Hunt on June 14, 2019 at 9:49 am

      The AD account must be setup as a user within the SmartConnect app itself. This is necessary for all users, including AD accounts having admin rights to the DYNAMICS database.

Leave a Comment


eOne Welcomes Incremental Group as a New eOne iPaaS Integration Partner
Employee Spotlight: Floyd Jones, Front End Developer
NEW WEBINAR: Popdock Onboarding - Fall in Love with Your Data
Employee Spotlight: Calum McGrath, Implementation Consultant
A Pricing Update Regarding the SmartConnect Perpetual Plan


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 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

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.