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. Log File Viewer can found in the SQL Server Management Studio – SQL Server Agent – Log File Viewer.

Power BI Report Server Schedules

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 Properties – Log on, or use the SQL Server Configuration Manager.

What is Power BI Report Server

Power BI Report Server is an on-premises report server with a web portal in which you display and manage reports and KPIs. Along with it come the tools to create BI reports, paginated reports, mobile reports, and KPIs. Your users can access those reports in different ways: viewing them in a web browser or mobile device, or as an email in their in-box.

PBI Report Server is similar to both SQL Server Reporting Services and it’s online service, but in different ways. Like the PBI service, PBI Report Server hosts PBI reports (.pbix), Excel files, and paginated reports.

Ping as an IP scanner allows to find reachable ip addresses in a subnet or for a network range

How to find ip addresses and discover devices on the network using ping. Depending on the purpose and task, free IP-scanner tools can be found in plentiful quantity on the Internet. Sometimes there is no tool available because you are at the user’s workplace. Where the guidelines prohibit the installation of non-approved tools the possibility to scan the network segment with Windows built-in tools.

Find IP address in network range using ping

This is where the execution of ping in a for-loop help us. This example send ping to all IPv4 addresses of a subnet from the command prompt. Run in a one-liner to find the IP addresses that are currently online.

for /l %i in (1,1,255) do @ping 192.168.57.%i -w 1 -n 1 | find /i "ttl="

The for loop with counter 1 starts at 1 and ends at 255, which pings a Class C network with 255 hosts (CIDR /24). Class C are the most commonly used network segments, for example, if the netmask 255.255.255.128 (25) is used, the last octet figure 128 is taken.

Option -w 1 represents a timeout of 1 millisecond for each response.
Option -n 1 is the number of echo requests to send.
Option find /i "ttl=" only the ICMP responses will be output.

C:\> for /l %i in (1,1,255) do @ping 192.168.57.%i -w 1 -n 1 | find /i "ttl="
Reply from 192.168.57.1: Bytes=32 Time=2ms TTL=255
Reply from 192.168.57.10: Bytes=32 Time=301ms TTL=64
Reply from 192.168.57.70: Bytes=32 Time=295ms TTL=64
Reply from 192.168.57.80: Bytes=32 Time<1ms TTL=128
Reply from 192.168.57.112: Bytes=32 Time=1ms TTL=255

Conclusion

This Tutorial show how to use the icmp utility to detect reachable devices in a subnet or a netwerk range. It should prove that it is also possible without network tools. Where no tools can be taken, it can be used as a proven procedure.