Hello,
I've followed the installation https://www.flexmonster.com/doc/getting-started-with-accelerator-ssas/ to connect to a local ssas database on sql server 2019
The flexmonster accelerator configuration file is
CONNECTION_STRING=Data Source=L-PLOYER\KSSAS
PORT=50005
HTTPS=false
CACHE_MEMORY_LIMIT=0
CACHE_ENABLED=true
GZIP=true
ALLOW_ORIGIN=*
WINDOWS_AUTH=false
The definition of the pivot is
var pivot = new Flexmonster({
container: "#pivotContainer",
toolbar: true,
report: {
dataSource: {
type: "microsoft analysis services",
/* URL to Flexmonster Accelerator */
proxyUrl: "http://localhost:50005",
/* Catalog name */
catalog: "AWDW2019Multidimensional-SE",
/* Cube name */
cube: "Adventure Works",
// Flag to use the Accelerator instead of XMLA protocol binary
binary: true
}
}
});
The server is running as shown in flexmonster acc.png
But I get the following error on the screen:
ERROR Unauthorized.
and this message in the javascript console "Failed to load resource: the server responded with a status of 401 (Unauthorized)" http://localhost:50005/FlexmonsterProxy/Handshaking
Hello, Philippe,
Thank you for reaching out to us.
Please check the permissions and make sure that your current user has access to the cube. Also, we recommend restarting the Flexmonster Accelerator service.
Additionally, could you clarify whether the SSAS instance and the Accelerator are hosted on the same machine?
Looking forward to hearing from you.
Kind regards,
Nadia