When connecting the SQL Server Windows Authentication mode in Bold BI, it will throw the following error
NT AUTHORITY/SYSTEM is not added in IIS/IIS EXPRESS to access SQL Server Windows Authentication mode.
NT AUTHORITY/SYSTEMto access SQL Server Windows Authentication mode in IIS/IISEXPRESS
In Microsoft SQL Server Management Studio, do the following in the Server.
Right click on “Login” and select
New Login to add respective login into SQL Server.
Click on “Search” button, then select
Advanced -> Find Now -> SYSTEM in the newly opened windows.
Then click “OK” to add the login
NT AUTHORITY/SYSTEM. Once it was added, we can able to access Windows authentication mode in Bold BI.