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.2k22 gold badges3232 silver badges6767 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
Related Tags
ssrs × 555sql-server × 299
sql-server-2012 × 45
sql-server-2008-r2 × 45
ssrs-2016 × 45
sql-server-2008 × 44
reporting × 37
ssrs-2012 × 30
ssrs-2008 × 25
sql-server-2016 × 24
ssrs-2008-r2 × 22
sql-server-2014 × 18
ssrs-2014 × 16
availability-groups × 14
report-builder × 14
t-sql × 13
permissions × 13
security × 12
ssas × 12
sql-server-2005 × 10
ssis × 10
sql-server-2017 × 9
migration × 9
business-intelligence × 9
sharepoint × 9