CODEWITHSUNDEEP
sqlconnectionssasolapcube
Daniel Martin
Daniel Martin

Reputation: 570

OLAP Cube deployment issues

I'm really new to this, so I am probably making a simple mistake.

I need to make an OLAP cube using a remote database. After I set up the dimensions and measures and create the cube, I can not get the cube to launch to the local server. I keep getting the error, "The project could not be deployed to the 'localhost' 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."

However, the local SQL server is running(from as far as I can tell), and I have no idea on how to go about fixing this. I've tried replacing "localhost" with "." and the IP, but that hasn't worked either.

Here's the guide I was following: http://www.mssqltips.com/sqlservertip/1532/build-a-cube-from-an-existing-data-source-using-sql-server-analysis-services/

Maybe the SQL Server isn't really running? How can I check? Or am I skipping over something important when I try to process the cube?

Upvotes: 14

Views: 47064

Answers (10)

rose
rose

Reputation: 31

I had the same issue today after I installed SQL server 2022. the problem is that you did not enable Analytic Service feature after installing SQL server. follow these steps to fix that:

  • open the SQL Server 2022 Installation Center (it's installed as you install SQL server, so just search
  • choose Installation from the left panel
  • choose New SQL Server standalone installation or add features to an existing installation. It will ask for your SQL server installation media. if you can't find it just download the SQL server from MS website (I used Developer server).
    • if you have problems with this step, just run the SQL server installer and choose custom install. it checks if SQL server is installed (although it says install again). after that it will open Installation Center and if you select New SQL Server standalone installation or add features to an existing installation from there, it will not ask for choosing media.
    • I ended up doing just that, if anyone has a better solution, please tell in comments.
  • a window called SQL Server 2022 Setup will open. press Next a few times until you reach Installation Type page.
  • choose Add features to an existing instance of SQL server 2022 and press Next.
  • when you reached the Features Selection step, check Analysis Service and press Next a few more times.
  • when reached the Analysis Services Configuration step (it will be shown if you did the previous step), choose Multidimensional (not sure about the exact text, but other one was tabular which was not what I wanted). don't press Next yet.
  • press the Add Current User button and then press Next
  • just Next-spam it through the end :)
  • at this point I tested my Analysis project in Visual Studio, and I could finally deploy the Dimensions to the Data Base (a basic DW Cube project).

I come across this video that helped a lot: YouTube Link

Upvotes: 0

Vityata
Vityata

Reputation: 43595

This is what solved it for me:

  1. Copy the connection from the MSSQL Server Management Studio:

enter image description here

  1. Project > Properties > Deployment > Paste:

enter image description here

Upvotes: 1

IMEDBOU
IMEDBOU

Reputation: 1

In Microsoft SQL server go to registered servers and click on:

Analysis services icon -> open local server groups

Click right on your username for the server and

service control -> start

It will work ;)

Upvotes: 0

Vasyl Korzhyk
Vasyl Korzhyk

Reputation: 11

One more reason can be Express version of SQL Server. Only standard version has Analysis Service.

Upvotes: 0

GeorgeD
GeorgeD

Reputation: 21

I got the same error while following that tutorial. I solved it by:

  • Double Clicking the Project Data Source
  • In the Impersonation Information Tab, I entered the credentials for the Windows user instead of using the service account.

Make sure you have the proper Server\Instance name instead of local host in the project deployment server.

Upvotes: 0

Mask
Mask

Reputation: 657

You need to change the target Server name as the remote sql server name or ip.

In BIDS right click on your project solution and select properties window. There you can give the server name as given below figure.

enter image description here

Hope it helps...

Upvotes: 8

Abdeloihab Bourassi
Abdeloihab Bourassi

Reputation: 1005

to deploy a cube AS you need an SQL instance as source, and an SSAS instance as destination.

regards,

Upvotes: 0

Diego
Diego

Reputation: 36176

you need to deploy the cube to a SSAS instance. See here I have the SQL Server instance and the SSAS instance (check the icon to see the difference):

enter image description here

you can check if you have it running on the services:

enter image description here

if you dont have it, yo ucan install from the sql server installation CD

Upvotes: 8

Kenneth
Kenneth

Reputation: 1364

OLAP cubes will not deploy to a SQL server instance. They must be deployed to an Analysis Services instance. It will be listed as 'SQL Server Analysis Services' in your service list.

Upvotes: 7

Nat
Nat

Reputation: 14305

"localhost" refers to the machine you are running the Business Intelligence Studio from.

You say you want to deploy to a remote server, so replace localhost with the server name or the ip address (e.g. "74.125.237.146")

Upvotes: 0

Related Questions