Thursday, March 7, 2013

Dynamics AX Retail Store DB is not able available

A quick post on troubleshooting issues for the connectivity between the AX 2012 Retail POS and Store DB.   
This error thrown by the application is "Dynamics AX Retail Store DB is not able available", You might run into this issues especially if the components communicating are located in different domains. 

Check first the POS config file, focus on the value for the StoreDataBaseConnectionString attribute. If you think that the issue might be due to domain issues, complete avoid the Domain authentication and try to leverage on the SQL login id/password in the connection string.


<?xml version="1.0" encoding="utf-8"?>
        <section name="AxRetailPOS" type="LSRetailPosis.Settings.ConfigFile.AppConfiguration, SystemSettings, Version=, Culture=neutral, PublicKeyToken=31bf3856adxxxxxx" />
    <AxRetailPOS OfflineDatabaseConnectionString="" StoreDatabaseConnectionString="Data Source=XXXXXX;Initial Catalog=AXRetailXXXX;User id=sa;Password=XXXXXX"
        StoreId="Store" TerminalId="Term-01" DATAAREAID="CERW" />

I have left just the important settings in the connection string like Server name, Database name, SQL Id and Password.

Now if you notice that the application connects to the database properly work with your networking team to identify and resolve the domain authentication failure issue. And finally make sure to change back the settings in the config with the appropriate security level.

Cumulative Update 1 (KB2807685) Released for AX 2012 R2

Cumulative update 1 for the Dynamics AX 2012 R2 has been released. It is very important to download and update this fix for your AX 2012 R2 environments as it has all the previous hotfixes for the known issues resolved in this cumulative update.

As usual the Cumulative update is accessible via Partnersource or Customersource, for complete release notes, setup installation and the hotfixes covered, visit the CU1 release page.

There will be two self extracting Exe's for this Cumulative update, one for Binary files and the second one for the Application. After the environment is update with CU1 the build number would be 6.2.1000.156