Search results

Login failed for user in Windows Authentication mode

When connecting the SQL Server Windows Authentication mode in Bold BI, it will throw the following error login-failed

Why this issue occurred

NT AUTHORITY/SYSTEM is not added in IIS/IIS EXPRESS to access SQL Server Windows Authentication mode.

The steps for adding NT AUTHORITY/SYSTEM to access SQL Server Windows Authentication mode in IIS/IISEXPRESS

In Microsoft SQL Server Management Studio, do the following in the Server.

  1. Right click on “Login” and select New Login to add respective login into SQL Server. add-login

  2. Click on “Search” button, then select Advanced -> Find Now -> SYSTEM in the newly opened windows. login-search

    authority-system-add

  3. 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.