Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Connect GP from server with client local desktop

Posted on by Microsoft Employee

Hello, I would really appreciate if anyone could help me out. 

I have created an ASP.net with c# code that communicates with Dynamic GP for integration purpose. Up till now, I was using my local machine where I have installed eConnect and dynamic GP to test my coding, which is working fine. Now I have created a server on Amazone with Dynamic GP and eConnect to full fill real use case where client are on different server and my code will be running on separate machine.

Although, I can connect the SQL server with the following information
Data Source=(IP address),(TCP port number of SQL on server);Initial Catalog=(databaseName);Persist Security Info=False;User ID=sa;Password=(password);Network Library=dbmssocn

however, when I am trying to create a customer using eConnect methods with the same SQL connectionstring I am facing different errors.


- Initially, I was encountering the following error: 

eConnectException: There was no endpoint listening at net.pipe://localhost/Microsoft/Dynamics/GP/eConnect/EntityOperations.

In order to resolve this issue, I have installed different features on my server and restarted my server. Added <add key="ServiceAddress" value="net.pipe://GP server NETBIOS name /Microsoft/Dynamics/GP/eConnect/EntityOperations" /> in my config file.

-Now I am facing a different error when I am trying to connect (Integration Security is required in connectionstring). And when I am providing Integration Security = true; in my connectionstring, it takes little time to process and prompt an error "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." 

 

Can anyone please help me? Thank you very much.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Connect GP from server with client local desktop

    Is this a right way to provide IP address along with port number in connectionstring to connect eConnect methods.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Connect GP from server with client local desktop

    Thank you Mariano for the response.

    In my case my Asp.net website is on my local host (local PC) and dynamic GP with eConnect is install on AWS server. I am tryng to connect my local desktop code with Dynamic on AWS. There are two paramter to execute the eConnectMethod, 1st is the connection string, which I have mentioned above. I am able to conenct SQL server which is also on AWS server. However, the 2nd paramter of eConnectMethod is xml string in which I am retriving customer information.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Connect GP from server with client local desktop

    So, on your AWS server, you installed Dynamics GP with eConnect, correct? What about the web server hosting your ASP.NET application? Is that also an AWS server? If both servers are installed, are they on the same domain?

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans