Credentials from Active Directory stored securely in report server SSRS

Question

I've got problem with setting credentials in my report on SSRS as "Stored securely in the report server".

I've created a user "reportviewer" as active directory user

When I set credentials in my report in SSRS, they don't work.

What is more I've got problem with SQL Server User Login not only this Windows User Login.

I'm using SQL Server Express with advanced services

These are my current settings from AD and SQL Server. (I apologise for not the best image quality).

Settings AD and SQL Server

These are settings from SSRS.

SSRS settings - credentials

Can anybody give me any clues what is wrong?

Answer 1

Create a reportviewer user account in SQL Server, and give it the relevant permissions.

Then use that login and password for your RS reports.

There should be no need to create an AD account for reports.