I am not able to connect to Analysis services

Posted on 2008-11-14
Last Modified: 2016-02-13
I have installed a SQL server 2005.

i built a cube in SQL server BI studio but unable to deploy the project. giving a msg

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service 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.

please help me in getting the project deployed.

thanx in advance.
Question by:amiteshanand
    LVL 22

    Accepted Solution

    1. You can connect to SSAS Server via SQL Server Management Studio?
    2. Is your server in LOCALHOST?
    Check the attached image... to change the server name...

    Remember: You have 2 connections in a normal SSAS Project... one the OLTP/Source database and one to the OLAP/Destination database.

    LVL 22

    Expert Comment

    LVL 1

    Author Comment

    I am trying to connect to SSAS cube from Excel. I have been following this link : This worked for in the staging environment where i have WFE and Database server both as same server. On the production environment the database server and WFE are two different server. I am unable to connect to server as it throws an error message: Unable to connect to database.
    LVL 22

    Expert Comment

    Your original question as 2 months ago, and you never replied.
    Open another topic for the new question and close this as resolved.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now