SBX - Search With Button

SBX - Forum Post Title

Connect GP from server with client local desktop

Microsoft Dynamics GP Forum

Shumaila asked a question on 9 Aug 2018 8:28 AM

Question Status

Unanswered

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.

Reply

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?

Reply
Shumaila responded on 10 Aug 2018 3:41 AM

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.

Reply
Shumaila responded on 20 Aug 2018 5:33 AM

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

Reply

SBX - Two Col Forum

SBX - Migrated JS