topic Re: Connecting to Reporting Server instance from SSMS in Report Server

Connecting to Reporting Server instance from SSMS

Anonymous — Wed, 19 Jan 2022 06:11:43 GMT

I have Power BI Reporting Server Jan 2021 installed. It is configured with Custom Security (as per this: https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample)

PBIRS is working abosultely fine. I am able to access the portal and do all the reporting operations.

However I am required to update some headers and trying to follow the steps from this link https://docs.microsoft.com/en-us/sql/reporting-services/tools/server-properties-advanced-page-reporting-services?view=sql-server-ver15. I am getting invalid user credentails, no matter what combination I try. Please help!

Re: Connecting to Reporting Server instance from SSMS

Icey — Mon, 17 Jan 2022 06:23:11 GMT

Hi Anonymous ,

https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample>)

<https://docs.microsoft.com/en-us/sql/reporting-services/tools/server-properties-advanced-page-reporting-services?view=sql-server-ver15>.

First of all, the two documents in your original post are attached with incorrect links. Please correct them.

Reporting-Services/CustomSecuritySample at master · microsoft/Reporting-Services · GitHub

Server Properties Advanced Page - SQL Server Reporting Services (SSRS) | Microsoft Docs

Then, do you mean that after you configured custom security, you can access to PBIRS, but cannot access to the corresponding report server instance in SSMS?

Or, do you mean that after you updated some headers and you want to connect to the corresponding report server instance in SSMS, this error occurrs?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Connecting to Reporting Server instance from SSMS

Anonymous — Wed, 19 Jan 2022 06:13:53 GMT

Thanks Icey , I have corrected the hyperlinks.

This statement is true...

"do you mean that after you configured custom security, you can access to PBIRS, but cannot access to the corresponding report server instance in SSMS?"

Re: Connecting to Reporting Server instance from SSMS

Icey — Fri, 28 Jan 2022 07:02:53 GMT

Hi Anonymous ,

1. What authentication method did you use when connecting to the corresponding report server instance in SSMS?

2. Can the database in Report Server Comfiguration Manager connect successfully?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Connecting to Reporting Server instance from SSMS

Anonymous — Thu, 10 Feb 2022 11:49:40 GMT

Hi Icey ,

1. I have configured it use my windows authentication and also have a SQL Server credential setup

2. Yes, the database is connecting correctly.