Troubleshooting Windows Authentication Login to SQL Server

[intapiuser]

Symptom

You can connect to the server and preview is showing data, but the build process fails due to connectivity issues.

Cause

The ElastiCube server service is running on the system account, but not on the logged on user’s account.

Solution

For Sisense version < 7.2:

Change the logon properties of the ElastiCube Management Service.

For Sisense version >= 7.2:

Change the logon properties of the Sisense.ECMS and Sisense.ECMServer services.

Steps:

1. Go to Control Panel > Administrative Tools > Services
2. Find ElastiCube Management Service, right-click and select Stop.
3. Find ElastiCube Management Service, right-click and select Properties.
4. Select the Log On tab, select This Account then click Browse.
   
5. Click Locations.
   
6. Choose your domain (e.g., Sisense.local in this example) and click OK.
   
7. Click Advanced.
   
8. Click Find Now, choose the user logged on to the machine and click OK.
   
9. The selected user will be added to the names box, click OK.
   
10. Enter and verify the user’s password, click OK.
    
11. Restart the service.