Share via

SSAS cube deploy failed

Ben 21 Reputation points
2022-01-19T12:29:23.38+00:00

Hi, I encountered an error when I deployed the project. The error as following:
Error The project could not be deployed to the server because of the following connectivity problems :
A connection cannot be made. Ensure that the server is running.
To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.

How can I resolve it? Thanks in advance.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,263 questions
0 comments
Accepted answer
  1. Nandan Hegde 31,511 Reputation points MVP
    2022-01-19T14:05:17.873+00:00

    Hey,
    Please try accessing the server / instance where you are trying to deploy via ssms from some jumpbox.
    Based on the error message it is either the server instance service might not be running or server is incorrect.
    Trying to connect via ssms would help us understand the issue much better in case id it still persists

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 43,331 Reputation points
    2022-01-19T12:38:52.88+00:00

    First do what the error message say: In project properties => "Deployment" check if you have entered the correct SSAS server name.

    0 comments
  2. CarrinWu-MSFT 6,866 Reputation points
    2022-01-20T03:32:38.153+00:00

    Hi @Ben ,

    Welcome to Microsoft Q&A!

    Please refer to this blog that provide detailed steps to troubleshoot this error.

    Best regards,
    Carrin

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments