a connection could not be made to the data source

I am trying to process a cube still it failed since "Errors in the high-level relational engine. A connection could not be made to the data source with the DataSource of "MY-DATASOURCE", Name of "MY-DATASOURCE").

The sql instance is running on the same machine in where I am working the solution. Can someone provide some hints on what to do to resolve this issue?

By looking at the "AdventuresWorks" sample the main difference that I have in my solution is that I have an instance and the AW sample is pointing to the default instance using the "localhost" reference only. My datasource connection is refered as "MyHost\MySqlInstance"...
I used the wong impersonation settings! I changed those and now I am processing the cube.

A connection cannot be made to Analysis Services 2005

Please help!

I have been trying to deploy an Analysis Services 2005 cube to a server from a local PC. I have had no luck. This was working yesterday and I cannot work out what might be different. This is the error message I am getting:

The project could not be deployed to the 'qccatsvr1' 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.

By the way this works on another PC that is set up the same way...the only thing I can see different is the Novell user account I used to log in to the PC.

This is what I have tried so far:

Checked that the Analysis Services service is running on the server - it is. Check the target server - this is ok. Re-install Analysis Services 2005 - no problems occurred during this Tried all different changes to the security log on in the Analysis Services service - nothing worked. Tried to open the AS solution file from the actual server and deploy - no luck.

So you can see that I am now getting quite frustrated. I know (hope) it is something simple that I have missed.

Does anyone have any ideas/solutions for me.

Thanks in advance!!!

Steve

SSAS uses windows authentication exclusively. It will not authenticate using a Novell account, but there should be a setting in your Novell client which controls how the user is logged on to the local machine. It is the local windows account that needs to have administrator priviledges in SSAS in order to be able to deploy a new database.

Were you using the same user account when you logged on to the server and tried to deploy the solution? If you use the same account that was used to install SSAS you should not have any issues.

If you want to deploy a solution from a remote machine on a Novell network you will need to setup a local account on the remote workstation which is set to log on to the local machine when the Novell user logs in and then you will need to set up an identical local account (with an identical password) on the server machine and assign the account on the server to the server administration role in SSAS.

|||

I have setup exactly the same account on the server as the windows username used to logon to the remote PC. The account also has exactyl the same password and has been given full access to SSAS. However this does not work either.

The things that has got me confused is that this user was able to deploy a few days before I posted this thread with no problems...that was without a username and password set up on the server with access to SSAS.

Do you have any aother ideas?

|||

I thought you mentioned in your original post that you were now using a different user account. Which is what made me think that it must be something to do with the Novell account/local account connection.

You could have a look at the following link, it contains information on troubleshooting SSAS connection issues: http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

|||

Darren,

Thank-you for your advice. I got onto that document and tried a couple of things. The one that helped the most was the SQL Server Profiler. This showed me what was happening with particular accounts and I was able to change the account permission accordingly.

Everything is now ok.

Thanks again for your help with this one...

A connection cannot be made to Analysis Services 2005

Please help!

I have been trying to deploy an Analysis Services 2005 cube to a server from a local PC. I have had no luck. This was working yesterday and I cannot work out what might be different. This is the error message I am getting:

The project could not be deployed to the 'qccatsvr1' 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.

By the way this works on another PC that is set up the same way...the only thing I can see different is the Novell user account I used to log in to the PC.

This is what I have tried so far:

Checked that the Analysis Services service is running on the server - it is.

Check the target server - this is ok.

Re-install Analysis Services 2005 - no problems occurred during this

Tried all different changes to the security log on in the Analysis Services service - nothing worked.

Tried to open the AS solution file from the actual server and deploy - no luck.

So you can see that I am now getting quite frustrated. I know (hope) it is something simple that I have missed.

Does anyone have any ideas/solutions for me.

Thanks in advance!!!

Steve

SSAS uses windows authentication exclusively. It will not authenticate using a Novell account, but there should be a setting in your Novell client which controls how the user is logged on to the local machine. It is the local windows account that needs to have administrator priviledges in SSAS in order to be able to deploy a new database.

Were you using the same user account when you logged on to the server and tried to deploy the solution? If you use the same account that was used to install SSAS you should not have any issues.

If you want to deploy a solution from a remote machine on a Novell network you will need to setup a local account on the remote workstation which is set to log on to the local machine when the Novell user logs in and then you will need to set up an identical local account (with an identical password) on the server machine and assign the account on the server to the server administration role in SSAS.

|||

I have setup exactly the same account on the server as the windows username used to logon to the remote PC. The account also has exactyl the same password and has been given full access to SSAS. However this does not work either.

The things that has got me confused is that this user was able to deploy a few days before I posted this thread with no problems...that was without a username and password set up on the server with access to SSAS.

Do you have any aother ideas?

|||

I thought you mentioned in your original post that you were now using a different user account. Which is what made me think that it must be something to do with the Novell account/local account connection.

You could have a look at the following link, it contains information on troubleshooting SSAS connection issues: http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

|||

Darren,

Thank-you for your advice. I got onto that document and tried a couple of things. The one that helped the most was the SQL Server Profiler. This showed me what was happening with particular accounts and I was able to change the account permission accordingly.

Everything is now ok.

Thanks again for your help with this one...

A Connection cannot be made

Hello
I try to build my cube on localhost by VS2005, while the data source is on the other machine. When I deploy the cube, it gives me the following error msg:
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.
I tried to fix it by following the instruction, but it does not work. I think my target server should be localhost, since my cube is built on the localhost, is it right? And I check my MS SQL server 2005 has been upgraded to package 1.
I am new to VS 2005, and really appreciate any help.
Thank you so much!
Aurora

Did you install SQL Server Analysis Services?

Take a look in the SQL Server Configuration Manager and see if it is running.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I checked it already, it is running
|||

Can you connect to Analysis Server using SQL Management Studio? If yes, double check your project settings in BI Dev Studio. Try and use machine name instead of localhost as a Target server

Here is some information for you to troubleshoot connectivity problems: http://www.sqljunkies.com/WebLog/edwardm/

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thank you, I fixed it.|||Could you finger out how to fix it, please?

A Connection cannot be made

Hello
I try to build my cube on localhost by VS2005, while the data source is on the other machine. When I deploy the cube, it gives me the following error msg:
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.
I tried to fix it by following the instruction, but it does not work. I think my target server should be localhost, since my cube is built on the localhost, is it right? And I check my MS SQL server 2005 has been upgraded to package 1.
I am new to VS 2005, and really appreciate any help.
Thank you so much!
Aurora

Did you install SQL Server Analysis Services?

Take a look in the SQL Server Configuration Manager and see if it is running.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I checked it already, it is running
|||

Can you connect to Analysis Server using SQL Management Studio? If yes, double check your project settings in BI Dev Studio. Try and use machine name instead of localhost as a Target server

Here is some information for you to troubleshoot connectivity problems: http://www.sqljunkies.com/WebLog/edwardm/

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thank you, I fixed it.|||Could you finger out how to fix it, please?sql

A challenging CUBE related question

Hi,

I have data coming in from our OLTP's view which has the following sales related information:

1) Date of Sale
2) Product Sold
3) Customer to which the Product was sold
4) QTy. sold
5) Total Sale Amount

I am bringing in this information into my "staging area" and from there I am building my Customer, Product, and Time Dimension and obviously my FACT table. The measures in my fact table were TotalSalesand Total QtySold and everything was working fine and I was able to analyze, slice, dice my cube in many ways...

Now the problem:

I also have planning related data available from another OLTP based view which contains the following information:

1) Plan Year
2) Plan Month (using Plan Year and Plan month,I "derived" a date which for any month was the 1st of that month)
3) Planned Product
4) Planned Sale (Amount)
5) Planned Qty (for sale)

You would have noticed that planning is NOT done at "Customer Level" and the planning data is only for product and time level (and that too only upto month level).

After populating my FAct table from the Sales data, I appended the planning related data into my fact table hoping that as long as I do not select any thing in the Customer dimesion and only go as low as the month level on my Time dimension, I will be able to see all of the following (measures) for any/all products:

Planned Sale, Actual Sale, Planned Qty., Actual Qty,

However I am unable to get anything displayed in the Planned Sale and Planned Qty despite applying all of the little knowledge that Ihave so far in the world of BI and making data marts
...

I really hope that my questions and requirement is clear.Can someone please help me get to

the solution.

Many many TIA.I hope I understand you correctly. If I did, I would have thought of doing the following (thinking from OLAP standpoint):

Dimensions:
- Create shared dimension for Time to support Date of Sale and Plan Month, Year
- Create shared dimension for Product

Cubes/facts:
- Create two separate cubes one for Actual and one for Planned using the shared dimensions. The Actual can have the Customer as a Private Dimension (it may help to design the customer also as a shared dimension).
- Create a virtual cube on top of the Actual and Planned.
- Create calculated measures for differentials between Actual and Planned.

Murthy