'SSAS process table in tabular model missing Credentials but model is configured with impersonate Service Account
I have the following situation :
- MS SQL Server database 15.0.4188.2 up and running
- MS SSAS configured 15.0.35.19 on same server, up and running, NT Service account MSSQLServerOLAPService has access to database
NT Service account is running the SSAS service
Login configured for NT Service account in MS SQL Database
Login has access to database with db_datareader role
- I created an SSAS tabular project in Visual Studio 2019 and configured the access to the database with Impersonate Service Account
- When I want to import new tables to the model, no credentials are asked to import the tables
Import tables as Service Account
- On deployment of the model to the server or table in model needs processing, an error messages appears that credentials are needed
Why do i get the error message that credentials are missing when impersonate as service account is configured and no credentials are asked when importing new tables from the datasource ? Did I forget to configure something here and what will that be ?
I hope you can help me with this.
Thanks in advance
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|