accelerator connection problem

Open
Philippe asked on May 2, 2022

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
 
 

Attachments:
flexmonster acc.png

1 answer

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster May 3, 2022

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

Please login or Register to Submit Answer