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

Announcements

No record found.

News and Announcements icon
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

  • Nanook Software Profile Picture
    2 on at

    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

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

  • Nanook Software Profile Picture
    2 on at

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

  • Linda_AGI Profile Picture
    67 on at

    No, this is our first time installing eConnect.

  • Linda_AGI Profile Picture
    67 on at

    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

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

  • Linda_AGI Profile Picture
    67 on at

    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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans