| Author |
Topic |
|
itmaster
Starting Member
28 Posts |
 Posted - 2012-09-17 : 15:13:08
|
| Hi,I am trying to learn how to build a cube in Analysis Service so I followed the instructions to the end and everything seems to be good but I get the following error when I try to deploy it:"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." Now I am buliding the project with Visual Studio 2010 developer. I am not sure what to do here?Any help would be appreciated,Thank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-17 : 16:12:40
|
| is the server installed as the default instance or named instance?if latter you should provide the correct server name in project-> properties-> Deployment tab under Server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
itmaster
Starting Member
28 Posts |
Posted - 2012-09-17 : 17:06:01
|
| Is the server installed as the default instance or named instance?I am not sure how to know this and I am sorry I should have mentioned that I am working on SQL Server Express on my machine. That is the (Adventure Works DW2008R2.dsv).Thank you |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-17 : 17:35:35
|
| do you've analysis services installed?try connecting to analysis services from management studio by select analysis services in connect menu and choosing your machine/server name------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
itmaster
Starting Member
28 Posts |
Posted - 2012-09-17 : 18:17:52
|
| You are right that is not installed, I thought that it was part of the instaltion. Would you know if that is something that I can install in SQL server express? If so where I can get it?Thank you |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-17 : 19:36:25
|
| express doesnt include analysis services. you need to get Standard Edition, Enterprise Edition or Developer edition for using it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
itmaster
Starting Member
28 Posts |
Posted - 2012-09-17 : 23:03:25
|
| I am using SQl Developer 2012 and I have the AdventureWorks DW in the sql server Express. So is therre something I can do wiht this?Thank You |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-18 : 01:50:58
|
| are you sure you've analysis services also installed?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
itmaster
Starting Member
28 Posts |
Posted - 2012-09-18 : 09:31:37
|
| Upon looking at this I realysed that I was using the Adventureworks DW in 2008 R2 and the developer was in 2012; but I also have SQL Server 2012 express. So I got the Adventureworks DW 2012, so that everything would be the same. Went back and built the whole project from the ground up (Thant is connection and all to Cubes and prespectives) and when I went to deploy it I get the same thing. So I looked in the connections for the Analyis services and it shows "Analyis services" but it is grayed out. So I am nt sure what this means. Is it installed but not turned on in some way or is it not installed at all? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-18 : 11:01:38
|
| i think you've not installed it then------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
itmaster
Starting Member
28 Posts |
Posted - 2012-09-18 : 12:12:56
|
| Ok I will have to see if I can get it and install it,Thank for all you help |
|
|
|
|
Issue deploying a Cube