September 30, 2024 at 10:19 am
For myself this seems to work and for other users they receive this error:
Errors in the OLE DB provide. We could not establish a connection to the "Server/Instance" Analysis Services server. Please verify that you can connect to this server, and that the SQL Browser redirector service is enabled.
This a 2016 SSAS Tabluar Model deployed to a production server.
I can connect to the database engine and analysis services via SSMS on my machine. My colleague can also do this and we both can write SQL/MDX queries.
I also can connect via Excel (365) from my machine when I get data from Database > Analysis Service within Excel. My colleague receives the above error.
Any ideas on what to check?
Thank you.
October 1, 2024 at 11:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 17, 2024 at 7:25 pm
Make sure the Analysis Services instance is properly configured and accessible on the network, double-checking the server/instance name and any firewall rules that might be blocking the connection. Verify that the SQL Browser service is running on the Analysis Services server, as this service helps route connections to the correct instance. If you and your colleague have the same Excel version and configuration, try comparing the connection settings to see if there's anything different between your setups.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply