How to fix SQL Server data tools deployment error

Onwuchekwa, Jane Adaeze 20 Reputation points
2023-03-15T04:50:47.34+00:00

I have tried everything in a similar thread but still having errorsScreenshot (432)

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
2,762 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,076 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
6,638 questions
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,054 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. PercyTang-MSFT 3,086 Reputation points Microsoft Vendor
    2023-03-15T08:00:38.74+00:00

    Hi @Onwuchekwa, Jane Adaeze

    The error message shows that the problem appears to be caused by the instance not functioning properly. You can solve your previous problem before proceeding. One of our colleagues has already answered another question, you can go and check it out.

    Best regards,

    Percy Tang

    If the answer is the right solution, please click "Accept Answer". 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.

  2. Olaf Helper 27,136 Reputation points
    2023-03-15T08:15:11.59+00:00

    select Project Properties, click on the Deployment tab, and then enter the name of the server."

    As the message says, check project deploy properties, if the right SQL Server is entered and that server is reachable.

  3. Limitless Technology 15,936 Reputation points
    2023-03-15T15:05:24.71+00:00

    Hello there,

    Log on to the server running SSAS as Administrator Launch Windows Firewall and advanced Security Add Inbound Rule, give it a meaningful name like SQL Server - SSAS Action: Allow the connection On Program and Services Tab: For 'This Program' use Browse and identify msmdsrv.exe For SQL Server 2014, it is by default here: %ProgramFiles%\Microsoft SQL Server\MSAS12.SQLSVR14\OLAP\bin\msmdsrv.exe (Very similar for 2012 and 2016, the numbers are different) Click OK; You should see a green dot with check mark Try your project again; It should connect, did for me.

    NOTE: If this also work for you, consider going back to the Inbound Rule and consider adding connection restrictions for security reasons.

    Hope this resolves your Query !!

    --If the reply is helpful, please Upvote and Accept it as an answer--