SSRS and Okta

Copper Contributor

We are using Okta to authenticate but I am having issues authenticating to SSRS reports since SSRS is looking for a windows login.  SQL Auth also hasn't worked.  Has anyone been able to get SSRS reports with Okta?

 

Thank you

1 Reply

@kerravon67 , SSRS and database engine do have seperate permission/auth systems, therefore SQL login can't work on SSRS.

SSRS supports mainly Windows auth.

Sorry, don't know Okta, so I can't give further assistent.

You may head out for a custom auth module, which si supported by SSRS, see

Configure custom or forms authentication on the report server - SQL Server Reporting Services (SSRS)...