Analysis Services server failed to build OLAP database - Help needed

• ramana3327

  SSCoach

  Points: 19722

  More actions

  June 5, 2022 at 2:21 pm

  #4044625

  Hi All,

  We are building the OLAP Cube from Share point Central Administrator tool for Project Server 2019 and receiving below error message. The issue looks similar to the below link. Here we are using SQL Server 2017 so SSAS is also same version that comes with 2017 on windows 2016. As mentioned in the article it suppose to resolve the issue with SQLnativeclient11 connection but still I am seeing the same issue. What should I do to solve the issue?

  https://techcommunity.microsoft.com/t5/project-support-blog/project-server-2013-building-cubes-when-tls-1-2-is-enforced/ba-p/362116

   

  Error Message

  Analysis Services server failed to build OLAP database. Error: Error Adding DataSourceView 'Name' to database 'DBNAME'. Error: Error Adding Table '' to database. Error: Login timeout expired

  A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

  Named Pipes Provider: Could not open a connection to SQL Server [5].

   

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  June 6, 2022 at 3:10 pm

  #4045096

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.