Power BI Report Server Schedules

Power BI Report Server Schedules SQLServer Error 15404

5
(1)

When working with Power BI Reports, you want dashboards and reports to be regularly updated with data sources, the Interactive Reports and Data Visualizations should reflect current information and charts.

Symptom

SQLServer Error: 15404, Could not obtain information about Windows NT group/user COM\sales, error code 0x5 ConnIsLoginSysAdmin>SQLSTATE 42000

Updating the reports is performed by the Power BI Report Server scheduler. You get the SQL Server Error 15404 during a SQL Server On-Prem installation in the SQL Server Management Studio – SQL Server Agent – Log File Viewer.

SQLServer Error Could not obtain information about Windows NT group/user
Microsoft SQL Server Management Studio – SQL Server Agent – Log File Viewer

Cause

The upgrade tasks scheduled by Microsoft SQL Server Reporting Services (SSRS) and Power BI Report Server (PBRS) are performed by SQL Server Agent. SQL Server Agent is a Windows service that performs scheduled management tasks (jobs). For permission to perform the update task to be fulfilled, authentication of an Active Directory domain account is required. The Microsoft SQL Server installation involves running the SQL Server Agent service as NT SERVICE\SQLSERVERAGENT thereby Active Directory is refusing access to SQL Agent.

Solution

Use an Active Directory domain user account to log on.

SQL Server Configuration Manager

Change SQL Server Agent authentication with ran the services.msc MMC-console to enable SQL Server Agent service through PropertiesLog on, or use the SQL Server Configuration Manager.

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Leave a Reply

Your email address will not be published. Required fields are marked *