On-premises deployment : Create the database

(0) Share

Report

Posted on by w.sallam

2,259

Hi all,

I'm trying to deploy on-premises D365 finance ,

when trying to initialize the database with the script .\Initialize-Database.ps1 -ConfigurationFilePath .\ConfigTemplate.xml -ComponentName AOS

I got this error

Creating empty database AXDB
Invalid backup file for database refName AXDB
At C:\infrastructure\Initialize-Database.ps1:168 char:14
+ ... throw "Invalid backup file for database refName $($db.ref ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: (Invalid backup ...se refName AXDB:String) [], RuntimeException
+ FullyQualifiedErrorId : Invalid backup file for database refName AXDB

I make sure the database is in the infrastructure folder with the name AXDB

can anyone help with this?

I have the same question (0)

All responses (9)

Answers (2)

Community Member on at

Like (1)

Report

Hi sallam

Did you check if the path[database backup file path] has full access for your account? if possible please use a shared network path.

Was this reply helpful? Yes No
w.sallam 2,259 on at

Like (0)

Report

thanks AKHILESH for reply.

the backup file is in the infrastructure folder and the user and sql service user have full access to the folder.

Was this reply helpful? Yes No
Verified answer

A.Prasanna 8,223 on at

Like (1)

Report

Just check your Database name on ConfigTemplate.xml and DatabaseTopologyDefinition.xml (in D365FO-OP folder) are match with each other .

refer this too , may useful : www.atomicax.com/.../d365ffo-prem-node-and-database-topology

Thanks & Regards,

Amith Prasanna

Was this reply helpful? Yes No
w.sallam 2,259 on at

Like (0)

Report

thanks a lot Amith for the link

it helped me a lot.

now when I run the Initialize-Database script it shows me this error,

C:\infrastructure\Initialize-Database.ps1 : Cannot bind argument to parameter 'LoginName' because it is an empty

I make sure the user part in both b and DatabaseTopologyDefinition.xml has this part

<User refName="axdbadmin" type="SqlUser" userName="axdbadmin">

also tried to create a sql user name axdbadmin but still same error,

please help with this

Was this reply helpful? Yes No
Verified answer

A.Prasanna 8,223 on at

Like (1)

Report

if your config template and Topology definition are ok, then try to debug "Initialize-Database.ps1" using PowerShell ISE, then you can find which parameter has an issue (in this case 'LoginName' empty)

Was this reply helpful? Yes No
w.sallam 2,259 on at

Like (0)

Report

thanks Amith for reply.

could you please tell me how to debug the script with ISE?

I didn't do it before

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi Sallam

use the below mentioned script it will resolve your issue. give your complete sql server instance name.

.\Initialize-Database.ps1 -ConfigurationFilePath .\ConfigTemplate.xml -ComponentName AOS -DatabaseServer [FQDN/Instancename]

let me know the result

Was this reply helpful? Yes No
A.Prasanna 8,223 on at

Like (1)

Report

here it is.
Just Open your script in ( this case DB initialize script) and add a breakpoint on each line you want to debug by pressing F9 key
once you press the line will be highlighted in red.

for full details just refer : https://docs.microsoft.com/en-us/powershell/scripting/windows-powershell/ise/how-to-debug-scripts-in-windows-powershell-ise?view=powershell-7

Thanks,

Amith Prasanna

Was this reply helpful? Yes No
w.sallam 2,259 on at

Like (0)

Report

thanks all for your help,

I edited my scripts using the reference Amith gave and debugged the Initialize-Database.ps1 and could solve the user issue by creating the user manually on SQL and assigned the roles as shown on the databasetopology file

Was this reply helpful? Yes No