Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

eConnect connecting to wrong SQL instance

Posted on by 65

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!

Categories:
  • Linda_AGI Profile Picture
    Linda_AGI 65 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?

  • Nanook Software Profile Picture
    Nanook Software 587 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
    Linda_AGI 65 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.

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

    No, this is our first time installing eConnect.

  • Nanook Software Profile Picture
    Nanook Software 587 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
    Linda_AGI 65 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
    Nanook Software 587 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...

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans