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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP close itself at the...
Microsoft Dynamics GP (Archived)

GP close itself at the login screen

(0) ShareShare
ReportReport
Posted on by Abdullah Kamal 230
Hi, This morning I tried to open GP in the server, where I used to open it remotely from client machine using windows "remote desktop connection". After choosing the company name GP closed by itself. Still working fine in the remote mode, but not working in the server itself. Any suggestions! Kamal

*This post is locked for comments

I have the same question (0)
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    At what stage does it close itself? Before, during, or after the login process? What version of GP are we talking about? Are you logging in with a profile used to log in remotely?

  • Abdullah Kamal Profile Picture
    Abdullah Kamal 230 on at
    Thank you for your prompt reply. When I put the password, it moves to the company drop down menu, I choose the company and click OK, then it closes itself. It version 10.0. Yes, it is administrator Please advise.
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    When you say "administrator" are you referring to the domain administrator or the server's local administrator profile? Which did you use to install GP? Sorry, but I have to ask.

  • Abdullah Kamal Profile Picture
    Abdullah Kamal 230 on at
    It's OK. It is domain administrator, as my GP server is part of my domain
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Abdullah, you may need to setup a DEXSQL.LOG from your server to see what the issue may be. Edit your DEX.INI file located under the GP\Data folder on your server and change the following entries, as follows:

    SQLLogSQLStmt=TRUE
    SQLLogODBCMessages=TRUE
    SQLLogAllODBCMessages=TRUE

    To do this, all users will need to be out of the system. Once you edit the DEX.INI file, log back into GP from the server. Post back with the lines generated in the DEXSQL.LOG, especially the last group of lines.

  • Abdullah Kamal Profile Picture
    Abdullah Kamal 230 on at
    Thanks, I will try and let you know
  • Abdullah Kamal Profile Picture
    Abdullah Kamal 230 on at
    Sorry, I have only Dex. chm/dic/tlb, Dex_US.dic, Dexfield.tlb, Dexrfld.tlb, Dexvba.dll and Dexvba.tlb
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    You need to locate your DEX.INI file. In v10 you can find under Program Files\Microsoft Dynamics\GP\Data.

  • Abdullah Kamal Profile Picture
    Abdullah Kamal 230 on at
    Unfortunately, the same problem. Please see the LOG details for the last group /* Date: 06/01/2009 Time: 19:57:01 stmt(20480704):*/ {CALL DYNAMICS.dbo.zDP_SY003001F_1(NULL,NULL)} /* Date: 06/01/2009 Time: 19:57:01 stmt(20467752):*/ { CALL DYNAMICS.dbo.zDP_SY01500SS_1 ( 1 ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20482864):*/ SELECT COUNT(Machine_ID) FROM DYNAMICS.dbo.STN41100 /* Date: 06/01/2009 Time: 19:57:01 stmt(20482864):*/ { CALL DYNAMICS.dbo.zDP_STN41200SS_1 ( 7, '_DEFAULT' ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20482864):*/ { CALL DYNAMICS.dbo.zDP_STN41200SS_1 ( 7, '_DEFAULT' ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20483944):*/ { CALL DYNAMICS.dbo.zDP_STN41250SS_1 ( 'NTSERVER3', 7, '_DEFAULT', '' ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20482864):*/ { CALL DYNAMICS.dbo.zDP_STN41200SS_1 ( 7, '_DEFAULT' ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20482864):*/ { CALL DYNAMICS.dbo.zDP_STN41200SS_1 ( 7, '_DEFAULT' ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20483944):*/ { CALL DYNAMICS.dbo.zDP_STN41250SS_1 ( 'NTSERVER3', 7, '_DEFAULT', '' ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20485024):*/ { CALL DYNAMICS.dbo.zDP_STN41300SS_1 ( 'NTSERVER3', 7, '_DEFAULT', '', 1, '', 0 ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20481784):*/ { CALL DYNAMICS.dbo.zDP_STN41100SS_1 ( 'NTSERVER3', 'DEFAULT' ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20486104):*/ SELECT COUNT(Machine_ID) FROM DYNAMICS.dbo.STN41100 /* Date: 06/01/2009 Time: 19:57:01 stmt(20482864):*/ { CALL DYNAMICS.dbo.zDP_STN41200SS_1 ( 8, '_DEFAULT' ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20482864):*/ { CALL DYNAMICS.dbo.zDP_STN41200SS_1 ( 8, '_DEFAULT' ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20483944):*/ { CALL DYNAMICS.dbo.zDP_STN41250SS_1 ( 'NTSERVER3', 8, '_DEFAULT', '' ) } /* Date: 06/01/2009 Time: 19:57:01 stmt(20475200):*/ { CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( 1, 0, 8, 0 ) }
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    Abdullah,

    I acknowledge you will have the same problem. Nonetheless, the DEXSQL.LOG displays no apparent issues with your log in and subsequent attempt to enter a company. Perhaps if you can delete the DEXSQL.LOG and email me a new one I could take a look at the entire file, rather than just a fraction of it.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans