Solved

Issue when deploying Analysis Server project; connection cannot be made to redirector

Posted on 2013-06-03
3
2,352 Views
Last Modified: 2016-02-18
Hi

I'm trying to deploye a CUBE To a server from the development server.
It is throwing an error:

Error      113      The project could not be deployed to the 'SERVER NAME'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.            0      0      


Can anyone help on this, why this error comming and not allow to deploye the CUBE.

Thanks in Advance.
0
Comment
Question by:keplan
  • 2
3 Comments
 
LVL 32

Assisted Solution

by:bhess1
bhess1 earned 305 total points
Comment Utility
Here are your most likely candidates to cause this problem.

1. Check that Analysis Services is installed and running on the target server


To check if it is installed, do the following on the destination server:
A) Open up the services monitor (Run -> services.msc  will do it)
B) Find the Analysis Services service (SQL Server Analysis Services (MSSQLSERVER))
C) If the service is not found, you probably need to install SSAS
D) If the service is not running (in a stopped or disabled state), start the service.  If it is disabled, you will have to re-enable it first.

2. Check that the project is deploying to the target server


To do this, you will need to:
A) Select your project in SSMS or open the project
B) Right-Click and select Properties
C) Click Deployment (in the left of the pop-up window)
D) Change the server name to the target server, or "localhost" if deploying on the same server that the project is on
Now try to deploy the project again, and see if it works.
0
 

Accepted Solution

by:
keplan earned 0 total points
Comment Utility
k
0
 

Author Closing Comment

by:keplan
Comment Utility
w
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

728 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

11 Experts available now in Live!

Get 1:1 Help Now