Retail POS connection to database

(0) Share

Report

Posted on by Community Member

Hi,

Can anyone help me with my concern? I'm trying to run the Retail POS in Microsoft Dynamics AX 2012 R3 with error notification "Retail POS cannot connect to a database. Try again later or contact your system administrator". What setup did I missed?

Thanks,

Chi

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Christiaan 380 on at

Like (0)

Report

Verify that you channel DB is operational. open the POS Database Utility and click verify database. see that it succeeds.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Christiaan,

is POS Database Utility and Retail POS Configuration utility the same? im using 2012 R3 and cant find POS Database Utility.

Was this reply helpful? Yes No
Christiaan 380 on at

Like (0)

Report

Hi Chi, its called the Retail Channel Configuration Utility on the Client where POS runs. it must be run as administrator to hold the settings once you close the app.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Christiaan,

The test connection of the Retail Channel Config Utility was successful but still I can't open the Retail POS.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Open event viewer. Go to Windows > Application logs and open the POS again. It will give you more details on error or you could share it here to let us see what happen.

Was this reply helpful? Yes No
Christiaan 380 on at

Like (0)

Report

Hi Chi, Looking into the event viewer log will help but you need to turn on specific logging behavior of the POS client. while in development phase I always turn on the full logging of POS clients.

Here is how:

C:\Program Files (x86)\Microsoft Dynamics AX\60\Retail POS\POS.exe.config change Warning to All (case sensitive) line 26 if no modifications made <source name="RetailNetTracer" switchValue="Warning"> change to <source name="RetailNetTracer" switchValue="All">
Also change the initializeData="" to a location on the machine example initializeData="C:\RetailLogs"

Run the POS again and review the new log file created at c:\retaillogs\.

Was this reply helpful? Yes No
Suggested answer

A.Prasanna 8,223 on at

Like (0)

Report

Hi,

you may need to enable SQL Server Browser on PC /Server , which is running Channel DB.

By the way can you explain your Deployment topology ? then it will help to find out root cause.

hope this will help!

thanks ,

Amith Prasanna.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Amith,

I've already enable the SQL Server Browser. still I can't run the Retail POS :(

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Christiann,

I've already update the POS.exe and try to run the Retail POS still the error occurs. :(

Was this reply helpful? Yes No
Christiaan 380 on at

Like (0)

Report

Please share the log file that was created it will reveal the issue you are having.

Was this reply helpful? Yes No