web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Error: Unable to conne...
Microsoft Dynamics AX (Archived)

Error: Unable to connect to the OLAP server name currently set as the default Please ensure that it is a valid OLAP server instance and that it is running. The value can be changed in the Analysis servers form.

(0) ShareShare
ReportReport
Posted on by Nadeem 815

Hi,

AX: AX 2012 R3 CU8.

Reporting and SSAS server:  windows server 2012 R2.

SQL Server version: 2013 - SP1 + latest update.

I have installed reporting services on this machine with AX SSRS extension and AOS can connect to this machine and reports are working fine.

Issue:

I installed Analysis services on this machine with multidimensional mode and setup completed successfully. I installed the AX analysis extension successfully. I checked the analysis database in sql management studio and there was no database created.

I also checked the analysis server settings in AX and correct server name is added but database tab is blank.

I ran the analysis server wizard from AX to deploy cubes thinking that it might create the database but received below error.

Error: Unable to connect to the OLAP server name currently set as the default Please ensure that it is a valid OLAP server instance and that it is running. The value can be changed in the Analysis servers form.

So the question is that whether AX analysis database must be created when analysis extension were installed or these will be created when deploying the cube where above error is being thrown.

Any help will be appriciated.

Regards,
ND

*This post is locked for comments

I have the same question (0)
  • Nadeem Profile Picture
    Nadeem 815 on at

    Correction:  SQL Server version is 2014.

  • Verified answer
    Nadeem Profile Picture
    Nadeem 815 on at

    Issue resolved.

    AX Client and  remote desktop service integration insalled on Reporting server.

    AX ports opened on Reporting server.

    Analysis server should have the connection provider as SQL Server native client 11.0

    Above steps helped successfully install the Analysis service extension and deployment of cubes.

  • Community Member Profile Picture
    Community Member on at

    Can you update with detailed steps as I have the same issue , I can not see the database, I have two partitions but I can not do deploy or have connection.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    An old thread but want to give away my opinion.

    The error message simply means ‘it cannot reach you SSAS Server’. Now coming to reason there can be many reason, such as for example.

    • Server name is not correct in AX Analysis service configuration form.

    • Port 2383 is not open SSAS machine. (this could be different port as well, by default 2383)

    A simple test could be Telnet to Port of SSAS server name. Don’t forget to add role of Telnet client from server administration, if you haven’t done already 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans