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/SYSTEM
to access SQL Server Windows Authentication mode in IIS or IIS EXPRESSIn 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 access Windows authentication mode in Bold BI.