Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

eConnect connecting to wrong SQL instance

(0) ShareShare
ReportReport
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!

*This post is locked for comments

  • 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,492 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans