web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

eConnect connecting to wrong SQL instance

(0) ShareShare
ReportReport
Posted on by 67

We are trying to use eConnect with our GP2016 install.  The GP2016 app and eConnect are on one server and the GP 2016 database is on other server.  The GP database is a named instance on the SQL server.  We have all the correct security settings for the user we are using for the connection between eConnect and the SQL Server.  We set up eConnect properly using the named instance as the server and Dynamics as our System database.  However, when eConnect trys to log on to the SQL server it is going to the Default instance and not the named instance.  We can see this in the default instance SQL Logs where the login fails because of course that user doesn't exist in the default instance.  Is there some configuration change we are missing in eConnect to make it go to the named instance instead of the default instance?

Thank you!

*This post is locked for comments

I have the same question (0)
  • Nanook Software Profile Picture
    2 on at
    RE: eConnect connecting to wrong SQL instance

    Can you verify that the server name is the same as it is defined in the SQL...

    select @@SERVERNAME

    From your instance should return the correct name that SQL thinks it is...

  • Linda_AGI Profile Picture
    67 on at
    RE: eConnect connecting to wrong SQL instance

    Yes, the Select @@Servername returns the correct server name that we used when we set up eConnect.

  • Nanook Software Profile Picture
    2 on at
    RE: eConnect connecting to wrong SQL instance

    Question.... Has eConnect ever been installed on the SQL Server? Any form?

  • Linda_AGI Profile Picture
    67 on at
    RE: eConnect connecting to wrong SQL instance

    No, this is our first time installing eConnect.

  • Linda_AGI Profile Picture
    67 on at
    RE: eConnect connecting to wrong SQL instance

    Sorry I might have answered that wrong.  We have eConnect installed on the GP App server since the documentation said that was the best configuration.  We have not tried installing it on the SQL Server and we really don't want to do that kind of configuration.

  • Nanook Software Profile Picture
    2 on at
    RE: eConnect connecting to wrong SQL instance

    Can you connect to the correct DBF from the eConnect Release Information program?

  • Linda_AGI Profile Picture
    67 on at
    RE: eConnect connecting to wrong SQL instance

    I'm not sure what the eConnect Release Information program is so I can't answer that question.  For eConnect to work does the SQL named instance need to be running on a fixed port?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans