I was demonstrating Business Analyzer for a client and of course I pick a workstation where the KPI'S will not appear. They do not appear for any users. These same users can go to any other computer and they are there. This is a W10 workstation. What I check? They are using Chrome on this workstation.
Now I'm confused...
How was the user added to the SQL security ?
Unless you're providing individual SQL user access in SSRS, this normally goes by using Windows authentication and adding corresponding AD users to SQL security..
If you want to discuss the topic tomorrow, send me a PM
She was made a sysadmin viA SSMS. This was just to see if it was a security issue. There is no AD group in their domain. I could play around the GP security roles.
How was the user added to SQL Security ?
Microsoft provides base SQL security role starting with rpt_ which you can use to provide access to GP back-end data..
I usually grant access for SSRS thru AD groups, not individual users, as it's easier to manage.
OK, this makes no sense. Making her a SQL sysadmin solves the problem. I had granted her the DYNGRP role on all GP databases. What other security settings would she need?
I agree,
at this point this seems to be an authentication / permission issue with the computer or user.
Can the user in general browse the SSRS report manager site ?
i.e. : http://yourSQLserver/Reports
Hi Richard and Beat,
Overall, I would stay as far away from the companion app as you can.
The "Business Analyzer" SSRS reports are just the canned SSRS reports you can deploy out of the Reporting Tools Setup window.
Richard, this is only happening from one workstation, correct? I wonder if there is some odd issue with the workstation. My first reaction is some odd domain issue that would probably be fixed by taking the workstation off the domain, then back on it.
Thanks!
Yes, SQL 2019 on a W2019 server.
I agree the information is old and was valid for GP 2015 and prior.. so maybe that has massively changed and no longer has the companion app deployed..
You mention a Windows 2019 server.. is the SQL server 2019 too ?
There is no SSL certificate here simply a W2019 server not an Azure server. I just installed this on the server and I can see the KPI's just like I did before before installing. Installing the CompanionApplicationServer never ask for any server information. Does it now require setup?
Richard,
I guess you've gone already thru this post:
community.dynamics.com/.../business-analyzer-installation-and-configuration
Could this be a certficate issue ?
I'm a little curious, because the .RDL report file might contain and point to a data source, but that's not the one that is actually used once the report is uploaded to the SSRS server.. the one that is used is the one that is defined in the security & connection properties of the report.
The SSRS report can be created / designed anywhere with Visual Studio tools and then exported / saved / uploaded to an active SSRS web site, you just have to make sure it's linked to a valid source to pull data.
Report security is another topic in itself to access it.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
