Post reply

Deployement Problem

  • 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. 0 0 "

    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

  • February 5, 2010 at 10:15 am

    #1114596

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

    Steve.

  • February 5, 2010 at 10:29 am

    #1114610

    Thanks steve for quick reply

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

    thanks

  • February 5, 2010 at 10:39 am

    #1114615

    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.

  • February 5, 2010 at 10:54 am

    #1114629

    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)

  • February 5, 2010 at 8:36 pm

    #1114902

    no body knows the solution for this???

  • February 6, 2010 at 12:05 am

    #1114930

    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.

  • February 6, 2010 at 12:14 am

    #1114932

    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 "

    :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) "

    waiting for ur reply

    Thanks and Regards

    Elchuru

  • February 6, 2010 at 12:36 am

    #1114934

    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.

  • February 6, 2010 at 4:02 am

    #1114971

    Thanks Steve

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

    Thanks

  • February 6, 2010 at 5:40 am

    #1114985

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

    --Ramesh

  • February 6, 2010 at 7:05 am

    #1114997

    Thanks Ramesh for looking into my problem.

    Here i am attaching deployment configuration snapshot.

  • February 6, 2010 at 7:12 am

    #1114999

    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

  • February 6, 2010 at 7:20 am

    #1115000

    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

  • February 6, 2010 at 7:56 am

    #1115005

    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.

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

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