Ssas:ole DB error: OLE db or ODBC error: Login failed for user ' NT Service\mssqlserverolapservice '

Source: Internet
Author: User
Tags odbc ole

Problem description

The following error message appears when you try to use SSAS for OLAP in the official Microsoft Tutorial:

Severity Code Description Project File Line Suppression state

Error OLE DB errors: OLE DB or ODBC error: Login failed for user ' NT service\mssqlserverolapservice '.; 28000. 0

Cause of the problem

This issue occurs because of an authorization authentication error when connecting to a SQL Server data source.

Solution Solutions
    1. Open SSMs
    2. Find Security/login Festival
    3. Add "NT service\mssqlserverolapservice" account
    4. Right-click to open the "NT Service\mssqlserverolapservice" Account property
    5. Find "User Mapping"
    6. Find the database you want to associate on the right, this is "AdventureWorksDW2012"
    7. In the bottom right of "Database role membership for:adventureworksdw2012", tick "db_datareader" "db_datawriter"
    8. Click "OK"
    9. Re-deployment, success
Related illustrations

1. Data Source Property →impersonation information→ Set "Use the service account"

2. Data source properties → Click edit→ to configure the DataSource provider for Native OLE db\sql Server Native Client XX. X

3. Open ssms→ Follow the steps described in the solution to configure

Ssas:ole DB error: OLE db or ODBC error: Login failed for user ' NT Service\mssqlserverolapservice '

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.