D365 Finance and operation

Pre-sales team want to enable CEO and other cash related work space in demo environment, where Microsoft will not give any direct option to enable.

Solution:- Small workaround you can check below to enable work space.

Below you can see, when team trying to open CEO work space.

Solution will start from Azure SQL deployment.

Login to Azure portal with admin account and start SQL database deployment.

Create new database server(AxDw), use admin account axlocaladmin, You can use custom password. Use premium configuration for sql database. Max space you can allocate for this purpose is 30 GB. You can increase or decrease data limit based on your usage.

Start deployment

Deployment will take almost 5-10 min.

Open SQL Server Management studio and and connect to your SQL

Azure Database. As the name of your server, use the one you created in Step 1, something like

ServerName.database.windows.net. User name = axlocaladmin

Create a new Query, make sure you are in the master database and enter the following lines:

CREATE LOGIN axdwadmin WITH PASSWORD = ‘samepasswordasinyourlcsenvironment’;

CREATE LOGIN axdwruntimeuser WITH PASSWORD = ‘samepasswordasinyourlcsenvironment’;

Create another query, make sure you are in the AxDW database (you can choose the database with

Ctrl-U) and enter the following lines:

CREATE USER axdwadmin FROM LOGIN axdwadmin;

CREATE USER axdwruntimeuser FROM LOGIN axdwruntimeuser;

After you have created your logins and database users, your database should look like this:

Database logins:

Reference

https://www.progress.com/documentation/sitefinity-cms/deploy-the-database-to-azure-sql