I am not able to connect to Analysis services

Posted on 2008-11-14
Medium Priority
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
  • 3
LVL 22

Accepted Solution

PedroCGD earned 1500 total points
ID: 22974390
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

ID: 23131931

Author Comment

ID: 23328853
I am trying to connect to SSAS cube from Excel. I have been following this link : http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx 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

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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

864 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