topic Reporting server doesn`t connect to rb-superopl.emea.bosch.com... in Report Server

Reporting server doesn`t connect to rb-superopl.emea.bosch.com...

Anonymous — Mon, 26 Sep 2022 10:44:14 GMT

Hello everybody

does anybody know how I can connect Report server with rb-superopl.emea.bosch.com....

With publisher we could connect with our windows user, but in the report server we got following failure message: siehe attachment.

Greetings

Barbara

Re: Reporting server doesn`t connect to rb-superopl.emea.bosch.com...

Anonymous — Mon, 26 Sep 2022 10:45:46 GMT

Re: Reporting server doesn`t connect to rb-superopl.emea.bosch.com...

v-luwang-msft — Tue, 27 Sep 2022 06:57:33 GMT

Hi Anonymous ,

Please help check if you have chosen this opinion in the shared datasource.(don’t choose the option)

Please also try to grant "Allow log on locally" permissions to domain user accounts.

1.On the report server computer, in Administrative Tools, open Local Security Policy.
2.Under Security Settings, expand Local Policies, and then click User Rights Assignment.
3.In the details pane, right-click Allow log on locally and then right-click Properties.
4.Click Add User or Group.
5.Click Locations, specify a domain or other location that you want to search, and then click OK.
6.Enter the Windows account for which you want to allow interactive login, and then click OK.
7.In the Allow log on locally Properties dialog box, click OK.
8.Verify that the account you selected does not also have deny permissions:
a. Right-click Deny log on locally and then right-click Properties.
b. If the account is listed, select it and then click Remove.

More details please refer:

specify-credential-and-connection-information-for-report-data-sources

Remember to restart SSRS server and test.Hope it will be helpful.

Best Regards

Lucien

Re: Reporting server doesn`t connect to rb-superopl.emea.bosch.com...

Anonymous — Tue, 27 Sep 2022 11:32:15 GMT

Hello Lucien, first, thanks a lot for your help. Unfortunately we found nobody who can make this change in this settings. I requested a ticket INC000023018824 therefore. It is strange that the PublishPowerBI had no problems connecting to the Super OPL via Windows User. Greetings from Germany. Barbara