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
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
Post a Comment