Deployement Problem

Question

Deployement Problem

elchuru

Default port

Points: 1435
More actions
February 5, 2010 at 9:36 am

#138669

Hi,
When i try to deploy my SSAS project it is show the following error.I did as it is shown in the error descirption,then also i am getting same erro. Anybody can suggest me how to solve this problem
"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.00"
here i am using following environment
"Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 2) "
Thanks in advance
prvr

Viewing 15 posts - 1 through 15 (of 30 total)

You must be logged in to reply to this topic. Login to reply

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 1

And you do have SQL Server Analysis Services installed to the local server? Your service is either not started, or not installed.

Steve.

elchuru Default port Points: 1435 More actions · Answer 2

Thanks steve for quick reply

Analysis service installed on local server and service and sql browser also started

thanks

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 3

Is it a named instance?

Can/have you connected to it via SSMS? If so, what name do you use when connecting? Have you tried using this same name in the deployment properties?

Steve.

elchuru Default port Points: 1435 More actions · Answer 4

yes it is named instance.

i tried using ssms also.but same error is coming. i tried both localhost and instance.but unable connect

when i tried using either localhost or instance i am getting the following errors

1) Error when using localhost

"Cannot connect to localhost.

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

No connection could be made because the target machine actively refused it 127.0.0.1:2383 (System)"

2)Error when connecting using instance name

TITLE: Connect to Server

Cannot connect to PRVR\MSONE.

ADDITIONAL INFORMATION:

A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

No connection could be made because the target machine actively refused it 127.0.0.1:2382 (System)

elchuru Default port Points: 1435 More actions · Answer 5

elchuru

Default port

Points: 1435

February 5, 2010 at 8:36 pm

#1114902

no body knows the solution for this???

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 6

Using local host is unlikely to work when running a named instance. The fact that you can't connect using SSMS is concerning.

I hate to harp on it, but you definitely have the AS service (not saying it's you, but people have previously thought that simply having SQL server gave them AS, it's a separate service) installed and running, not just the SQL service? (the edition/details etc you posted for re: your environment are what you get from select @@version, again, this is SQL info rather than SSAS info, as SP levels etc can be differen between the 2 services).

Have you checked your event logs to see if the service is logging anything? What account is the SSAS service running under?

No firewall blocking port 2383?

Steve.

elchuru Default port Points: 1435 More actions · Answer 7

Thanks steve, u r only can solve my problem. Please try to help.

Here i can connect to database engine and integration services.Nothing is showing event logs. No firewal blocking. Here i am able deploy .net application and ssis applications.

when i run select @@version "

waiting for ur reply

Thanks and Regards

Elchuru

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 8

What do you see, in the Services control panel applet? e.g. On my machine, I see the following

SQL Server Agent (MSSQLSERVER)

SQL Server Analysis Services (MSSQLSERVER)

SQL Server Browser

Obviously this is just a sampling of the services, but you can see I have a SQL Agent and SSAS (instance names of MSSQLSERVER) and also SQL Browser.

When you look at the "SQL Server Analysis Services (MSONE)" service, what account is the service set to run under?

Steve.

elchuru Default port Points: 1435 More actions · Answer 9

Thanks Steve

I am attaching services snapshot.please look at that one.

Thanks

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 10

Can you also show us the deployment configurations of the project in VS/BIDS?

--Ramesh

elchuru Default port Points: 1435 More actions · Answer 11

Thanks Ramesh for looking into my problem.

Here i am attaching deployment configuration snapshot.

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 12

elchuru (2/6/2010)
Thanks Ramesh for looking into my problem.
Here i am attaching deployment configuration snapshot.

So here lies the problem. Since MSONE is not a default instance, you have to change the "Target Server" property to ComputerName\MSONE

--Ramesh

elchuru Default port Points: 1435 More actions · Answer 13

Dear Ramesh,

Yes it is not default instance. And i changed to target server to PRVR\MSONE.Then also i getting error.For error and target server changes i am attaching snapshots.Please look at it.

Thanks

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 14

Are you a local admin on your machine?

Can you screen shot SSMS as you try to connect the object browser to the SSAS instance?

Steve.