Share
Report
1,023Hi Guy's
I have been assigned a task of POS installation and configuration on three different servers. Out of those, two went fine but facing some issues on the third one.The server on which i am trying to install and configure POS is a development server with AOS running on it but the SQL server is installed on other machine, which means i need to create Retail Channel Database on other machine(DB server) and configure it from Development machine for Retail POS.
I have successfully installed the POS and Retail Channel Configuration Utility through the AX setup. But when i am trying to create a new Retail Channel database through the Retail Channel Configuration Utility, i am facing an error. Below is the error that appears when clicking the Test Connection button, after specifying the server name and database name.
Also upon clicking the Apply button a different error is appearing.
The utility is not allowing me to create a new retail channel database. Upon looking into the log file of retail database utility available at location."C:\Program Files (x86)\Microsoft Dynamics AX\60\Retail Database Utility". I found few errors logged in this file. Here is the exact error details.
"RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Master connection string: Data Source=SS-DEVSQL-02;Initial Catalog=master;Integrated Security=True;Persist Security Info=False;Pooling=True;Encrypt=True;TrustServerCertificate=True
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: database name: TestDB
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: Database 'TestDB' is not found.
RetailDatabaseUtility.exe Error: 0 : EmbeddedInstall: CheckDatabase failed:System.IO.FileNotFoundException: Directory C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data does not exist.
at Microsoft.Dynamics.Retail.Pos.CreateDatabaseService.EmbeddedInstall.CreateDatabase(String databaseName, String databasePhysicalFilePath, DbCommand dBCommand)
at Microsoft.Dynamics.Retail.Pos.CreateDatabaseService.EmbeddedInstall.CheckDatabase(String connectionString, String databasePhysicalFilePath, Boolean includeDemoData, String userGroupName)
RetailDatabaseUtility.exe Error: 0 : DBUtilityCoreCreateStoreDatabase: CheckDatabase failed:System.IO.FileNotFoundException: Directory C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data does not exist.
at Microsoft.Dynamics.Retail.Pos.CreateDatabaseService.EmbeddedInstall.CreateDatabase(String databaseName, String databasePhysicalFilePath, DbCommand dBCommand)
at Microsoft.Dynamics.Retail.Pos.CreateDatabaseService.EmbeddedInstall.CheckDatabase(String connectionString, String databasePhysicalFilePath, Boolean includeDemoData, String userGroupName)"
By looking at this error, i just verified whether the Directory C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data" exists on the SQL server or not and it looks fine and also this folder has full read and write privileges to the admin user.
Also there are some errors, logged in SQL server logs. below are the error details.
The user has given the maximum rights to create Database on this server. But still i am unable to create the database on the SQL server from the retail channel database utility.
Any help will be highly appreciated.
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
