Unable to connect to Microsft dynamics GP2010 server because of an unknown error

(0) Share

Report

Posted on by Community Member

Hello,

The client system that has Microsft Dynamics GP2010 on them could not conect to the server and i have ensured that the prot is on the exception list of the firewall also the symentec antivirus has been removed. Anytime we want to connect to the server it says it could not log u on because of an unknown error.

Please help me out on how to resolve this issue.

Thank you

Akintayo Kemi

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

sueconrod 337 on at

Like (0)

Report

This problem occurs when the DEX_LOCK and DEX_SESSION tables do not exist in the database TEMPDB Database in the SQL Server that is being used for Microsoft Dynamics GP.

There is an article on this TK: 865801

And this was right through BING using: Great Plains login due to unknown error

You can read the solution there.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

Thanks for your responce.

But i have tried the solution it did not solve my problem. Please help me more.

Also i noticed that if the internet is unpluged it connect to the server but if the internet is available it does not connect to the server. Please help me more.

Thank you and God bless

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

When you set up the 32-bit system odbc connection, are you able to connect? Or, is it just when you try to Dynamics GP?

If you use Windows authentication, can you log on to the server? (outside of Dynamics GP)

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No i can't connect when i try to reconfigure the ODBC.

With window authentication i cant login to the server.

Please help me out.

Thanks

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

OK,

This tells us it isn't a Dynamics problem. When you try to connect using the ODBC set up, what EXACTLY does the error message say? Is there a More Info button? If so, what does it say?

Kind regards,

Leslie

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Yoy may have a DNS issue here. Can you launch SSMS and log in with Window Authentication and also with SQL credentials. Do you have an IT person who can help? Can you ping your server by name and then also by IP address? If only by IP adress try setting up the DSN using the IP address.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Is the SA login even enabled?

Was this reply helpful? Yes No