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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Econnect

(0) ShareShare
ReportReport
Posted on by 90

Hello , 

I have a  problem with my ecconect v12 with visual studio, 

When i do my connection string in my local machine there are no problem,  but when some one else try to connect to my machine with ecconect there are a problem 

Code:

public void conectar ()
{
GetNextDocNumbers econectinstance = new GetNextDocNumbers();
econectinstance.RequireServiceProxy = false;
try
{
string sConnectionString = "data source=MEXSIST012\\DYNAMICSGP;initial catalog=TWO;integrated security=SSPI;persist security info=False;packet size=4096";
string conectar = econectinstance.GetNextGLJournalEntryNumber(IncrementDecrement.Increment,sConnectionString);
}

When i put the code in my michine there are no problem, but when someone else put the same code in his visual studio the problem is the next :

Error : SQL Exception Thrown in the GetNextNumber method.

The things that i Have done was

1.- The service of my ecconect is started and have the same user and password when i configure my ecconect

2.- In the event Viwer the service indicates thats is correct

eConnect Service Host has started at URI: net.pipe://localhost/Microsoft/Dynamics/GP/eConnect/
The Following Endpoints are now active:

3.- My sql accepts remote conections.

I really do not know what else do..

I hope some one help me.

Thnks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    remember you are using integrated security. Does the user have proper credentials for sql? The credentials you use for the service are not relevant to the connection you are making in visual studio to initiate the service call. Event manager should provide you more details on the actual error details.

  • marcos cristales Profile Picture
    90 on at

    so, the user of the other machine that is trying to connect to my econnect , Shoul it have permissions to connect to my sql?

    For example:

    In my local machine have Userone and it is  on my SQL login and have the correct credentials,

    The other user is UserTwo and that user is not on my sql  login, that user is in other computer and try to enter to my econnect trough visual aplication but send the error.

    the event manager of my visual studio send me only this ---Error : SQL Exception Thrown in the GetNextNumber method.

    Sorry for my english

  • Community Member Profile Picture
    on at

    they need to have integrated security access to the SQL instance they are connecting to. An easy way to test this is to use SQL Server Management Studio to login into the instance of SQL they are using with integrated security and make sure they can see the databases.

  • marcos cristales Profile Picture
    90 on at

    Ok Thank you very much we will  give permission to the other user to connect to SQL and give the result.

    Marcos Cristales

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans