+ Reply to Thread
Results 1 to 5 of 5

Error with SSAS project

  1. Error with SSAS project

    Hello,

    I am learning how to use the BI tools with SQL Server 2005. I am following
    the tutorials on creating an SSAS project. My connection string tests
    successfully and all SQL Server services are running, but when I try to
    analyze a cube or deploy the package, I get the following error:

    Error 1 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.

    Any idea as to what's causing this to occur? SQL is running on my machine, I
    have admin rights and the DB is there and viewable.

    Thanks in advance,

    Frank



  2. Re: Error with SSAS project

    Try entering the full name of the server instead of localhost.


    MC


    "Frank Doosey" wrote in message
    news:Oo9Vj7XFIHA.280@TK2MSFTNGP03.phx.gbl...
    > Hello,
    >
    > I am learning how to use the BI tools with SQL Server 2005. I am following
    > the tutorials on creating an SSAS project. My connection string tests
    > successfully and all SQL Server services are running, but when I try to
    > analyze a cube or deploy the package, I get the following error:
    >
    > Error 1 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.
    >
    > Any idea as to what's causing this to occur? SQL is running on my machine,
    > I have admin rights and the DB is there and viewable.
    >
    > Thanks in advance,
    >
    > Frank
    >




  3. Re: Error with SSAS project

    I realized my error, Analysis/Integration/Reporting Services weren't
    installed. All is well now.


    "MC" wrote in message
    news:eLbBmUZFIHA.284@TK2MSFTNGP02.phx.gbl...
    > Try entering the full name of the server instead of localhost.
    >
    >
    > MC
    >
    >
    > "Frank Doosey" wrote in message
    > news:Oo9Vj7XFIHA.280@TK2MSFTNGP03.phx.gbl...
    >> Hello,
    >>
    >> I am learning how to use the BI tools with SQL Server 2005. I am
    >> following the tutorials on creating an SSAS project. My connection string
    >> tests successfully and all SQL Server services are running, but when I
    >> try to analyze a cube or deploy the package, I get the following error:
    >>
    >> Error 1 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.
    >>
    >> Any idea as to what's causing this to occur? SQL is running on my
    >> machine, I have admin rights and the DB is there and viewable.
    >>
    >> Thanks in advance,
    >>
    >> Frank
    >>

    >
    >




  4. Re: Error with SSAS project

    Hi,

    I am having the same problem you did. Can you tell me how to get to Analysis/Integration/Reporting Services/ ? Is this in Windows? SQL Server? Visual Studio?

    Thanks!

  5. Re: Error with SSAS project

    Quote Originally Posted by Database Administrator View Post
    I realized my error, Analysis/Integration/Reporting Services weren't
    installed. All is well now.


    "MC" wrote in message
    news:eLbBmUZFIHA.284@TK2MSFTNGP02.phx.gbl...
    > Try entering the full name of the server instead of localhost.
    >
    >
    > MC
    >
    >
    > "Frank Doosey" wrote in message
    > news:Oo9Vj7XFIHA.280@TK2MSFTNGP03.phx.gbl...
    >> Hello,
    >>
    >> I am learning how to use the BI tools with SQL Server 2005. I am
    >> following the tutorials on creating an SSAS project. My connection string
    >> tests successfully and all SQL Server services are running, but when I
    >> try to analyze a cube or deploy the package, I get the following error:
    >>
    >> Error 1 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.
    >>
    >> Any idea as to what's causing this to occur? SQL is running on my
    >> machine, I have admin rights and the DB is there and viewable.
    >>
    >> Thanks in advance,
    >>
    >> Frank
    >>

    >
    >
    Hi, can you tell me how to do what you did here. That is go to Analysis/Integration/Reporting Services to install it. Im not sure where you are talking about Control Panel, SQL Server, Visual Studio?

    Thanks

+ Reply to Thread