Share via

SSAS cube deploy failed

Ben 26 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,327 questions
0 comments
Accepted answer
  1. Nandan Hegde 34,436 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

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 46,301 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,891 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
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.