eConnect connecting to wrong SQL instance

(0) Share

Report

Posted on by Linda_AGI

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

All responses (7)

Answers (0)

Linda_AGI 65 on at

Like (0)

Report

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 587 on at

Like (0)

Report

RE: eConnect connecting to wrong SQL instance

Can you connect to the correct DBF from the eConnect Release Information program?
Linda_AGI 65 on at

Like (0)

Report

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 65 on at

Like (0)

Report

RE: eConnect connecting to wrong SQL instance

No, this is our first time installing eConnect.
Nanook Software 587 on at

Like (0)

Report

RE: eConnect connecting to wrong SQL instance

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

Like (0)

Report

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 587 on at

Like (0)

Report

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