New answers tagged ssrs
0
you are using this PowerShell module from the gallery.
You need to use Copy-RsSubscription if the subscription on the destination does not already exist. Set-RsSubscription updates only already created subscriptions.
Get-RsSubscription -ReportServerUri 'http://sql2017/reportserver' -RsItem '/Cooperative Technologies/1035/1035YellowPages/Billing Reports/...
2
The MFA auth flow is interactive. For me, for instance, it opens a browser window, displays an code, and I get a notification on my phone to approve the login.
So you can't use it in background services like SSRS.
answered Feb 17 at 14:41
David Browne - Microsoft
30.2k2 gold badges32 silver badges67 bronze badges
-1
Use OLEDB connector and type the connection string directly:
Provider=MSOLEDBSQL;Data Source=myServer;Initial Catalog=myDatabase;Authentication=ActiveDirectoryInteractive;User ID=myUserName;Use Encryption for Data=true;
0
Chrome browser does not request a kerberos ticket with delegation flag by default.
Therefore when report was viewing via Chrome I get
Operating system error 5(Access is denied.)
exception, because it's as if anonymous user for endpoint, while IE request a kerberos ticket with delegation flag. And a report works fine in Chrome after it was open in IE ...
Top 50 recent answers are included
