Error while deploying report

(0) Share

Report

Posted on by Community Member

I am trying to deploy reports in Dynamics 365. But getting error "A positional parameter cannot be found that accepts argument '.\DeployAllReportsToSsrs.ps1'."

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (2)

Suggested answer

Mea_ 60,284 on at

Like (1)

Report

Hi Richa,

You have incorrect syntax of a command. PS command is an alias for get-process command. So instead of typing "PS C:\...."

you need to first change current directory using "cd" and then execute "DeployAllReportsToSsrs.ps1". Not AX related question tho.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Thanks for reply ! After changing current directory I execute "DeployAllReportsToSsrs.ps1" but getting below error.

Get-ItemProperty : Property BinDir does not exist at path

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (1)

Report

You need to add next -PackageInstallLocation "J:\AosService\PackagesLocalDirectory". Please check drive for PackagesLocalDirectory folder it could be not J in your installation.

So command will look like .\DeployAllReportsToSSRS.ps1 -PackageInstallLocation "J:\AosService\PackagesLocalDirectory"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have tried the above syntax. But now getting write exception error.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Now you need to go to ssrs logs and see what is wrong. But have you checked that it is up and running ? Are you able to print a report from AX ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have checked the log.

Below are the details:-

Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Have not seen this before. You did not answer on my other question and probably you need to tell us more about your environment is it Azure hosted or VM, what is the version ? Also does it work if you deploy report from VS ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It's VM. It doesn't deploy reports from VS. We are using Platform Update 3.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Ok, what about SSRS service, is it running ?

Was this reply helpful? Yes No
Verified answer

Mahmoud Hakim 17,887 on at

Like (1)

Report

your problem now as per below 'The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

so try to check with another user

Was this reply helpful? Yes No