{[{category.name}]}
- {[{section.name}]}
  - {[{article.title}]}
  - {[{subsection.name}]}
    - {[{article.title}]}
    - {[{childsection.name}]}
      - {[{article.title}]}

SELECT Permission Denied Error 42000 at Process Step

Kepion Support

July 07, 2023 16:35
Updated

Symptom

Error 42000 occurs at Process step, stating that the SELECT permission was denied.

Resolution

1. Open SQL Server Management Studio and connect to your SQL Server.

2. Right-click Logins and select New Login...

3. Go to the User Mapping page and make sure the SSAS SI is granted the role of db_datareader and dbo is specified under the Default Schema column of the target database.

Symptom

Resolution

Related articles