ole db error: ole db or odbc error: login failed for user 'nt authority\local service'.; 28000. while creating SSAS tabular model

Error : ole db error: ole db or odbc error: login failed for user 'nt authority\local service'.; 28000. while creating SSAS tabular model

Solution:
1. Open SQL Server Management Studio
2. Expand the Security node, Expand Logins, if the username from the errormessage above exists in the list, right click and Properties
3. Otherwise right click Logins, "New Login..." and type in the correct Login Name as authority\local service
4. On the "User Mapping" tab check the data warehouse Map checkbox and select db_datareader and db_Owner for it
5. Click OK

Comments

Popular posts from this blog

Failed to execute the package or element. Build errors were encountered

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

On-premises data gateway December release