0

I have been trying to deploy a solution from SQL Server Data Tools to my sql server. However, whenever I try to, i get the following error (I'm sorry its in french, the second screenshot in an equivalent of it I found online):

Error in french

Error in english

I set up my server name in the project properties

Deployment properties as it is in the my server properties

Server properties

I'm doing this for an academic project (which is why I'm using sql 2014), but I'm kind of stuck here and can't get any further, I hope someone can help me.

Thom A
  • 88,727
  • 11
  • 45
  • 75
H. Ka
  • 1
  • That error says you're deployed to the `localhost` not the server `HAMZA`. – Thom A Oct 14 '20 at 14:24
  • 1
    Also [please do not upload images of code/errors when asking a question.](//meta.stackoverflow.com/q/285551). – Thom A Oct 14 '20 at 14:25
  • What type of project are you trying to deploy here? That's an express instance, which means that it does not support SSAS and SSIS, and if you're deploying an SSRS report, then I would suggest that the error is correct, and SSRS isn't running (that last screen shot is of the Data Engine, which is unrelated to the problem) – Thom A Oct 14 '20 at 14:27
  • I'm trying to deploy a cube into my sql server, to be honest I'm new to sql and I'm just following a guide in the book our teacher gave us (Business Intelligence with SQL server 2014) – H. Ka Oct 14 '20 at 14:37
  • 1
    *"I'm trying to deploy a cube into my sql server,"* You're using Express, you can't. ONly Standard, Enterprise and Developer support SSAS. – Thom A Oct 14 '20 at 14:38
  • I just upgraded to Enterprise edition, the same problem occurs. – H. Ka Oct 14 '20 at 15:02
  • I tried Developer edition too, just in case, it still doesn't work – H. Ka Oct 14 '20 at 15:05
  • And is the SSAS service running? I suspect not. – Thom A Oct 14 '20 at 15:08
  • No, when I check my services I dont see Analysis Services – H. Ka Oct 14 '20 at 15:14
  • You didn't install it then. You need to install and run SSAS to be able to deploy to it. – Thom A Oct 14 '20 at 15:15
  • I have been trying to install the analysis services through "Add features" in sql setup , but I cant find analysis services in the features tree even though it says that this instance is Enterprise in the wizard screen before. Any idea why? – H. Ka Oct 14 '20 at 16:15
  • @H.Ka Mircosoft has a lot of documentation, some even titled [Install SQL Server Analysis Services](https://learn.microsoft.com/en-us/analysis-services/instances/install-windows/install-analysis-services?view=asallproducts-allversions) – Brian Oct 14 '20 at 18:04
  • @H.Ka before you try to deploy your cubes via SSDT, try to connect to the SSAS instance first by using SSMS (SQL Server Management Studio). You'll need to select proper "Server Type" when connecting to instance. – Dmitrij Kultasev Oct 15 '20 at 08:40

0 Answers0