SQL Server 2012 SSDT “The project could not be deployed to … A connection cannot be made …”


I'm a newbie to SQL Server 2012. Here is my condition.

I have a running SQL Server 2012 Business Intelligence SP1. The problem is I cannot deploy a project to my SSAS from another computer.

The error is:


The project could not be deployed to the 'DATABASE-SERVER\MSSQLSERVER' 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.


The following is the things that I've tried:


Check the target name on Project > Properties > Deployment > Target server.

</li> <li>

Check the server service --> all SQL Server services are running.

</li> <li>

The project can be deployed from server.

</li> <li>

The connection to server is clear

</li> <li>

I can connect to the Database Engine and Analysis Service from another computer from SQL Server Management Studio.

</li> </ol>

Please help me to fix this problem, I've been search for many days for this problem.

Thank you, sorry for my bad english.

Best regards, Stella.


I had the same problem, for me the solution was to explicitly specify login information on the Impersonation Information tab on the Data Source.


I know this is an old thread, but I had the same issue and I reckon more will run into this buzz saw.

My problem was that the remote installation of SSAS did not have an Inbound firewall rule for SSAS application; msmdsrv.exe.

Resolution: Log on to the server running SSAS as Administrator Launch Windows Firewall and advanced Security Add Inbound Rule, give it a meaningful name like SQL Server - SSAS Action: Allow the connection On Program and Services Tab: For 'This Program' use Browse and identify msmdsrv.exe For SQL Server 2014, it is by default here: %ProgramFiles%\Microsoft SQL Server\MSAS12.SQLSVR14\OLAP\bin\msmdsrv.exe (Very similar for 2012 and 2016, the numbers are different) Click OK; You should see a green dot with check mark Try your project again; It should connect, did for me.

NOTE: If this also work for you, consider going back to the Inbound Rule and consider adding connection restrictions for security reasons.


  • C# String Filepath Question
  • .NET compiled third-party DLL reference conflict
  • Unable to deploy on Windows 10 Mobile
  • How to handle Twilio postbacks in Cloud9 IDE dev server?
  • How do I recognize a line break with a switch case that evaluates a char in Java?
  • How to add System.Windows dll to Visual Studio 2010 express?
  • (Tcl/Expect) clear screen after exit
  • Scanner nextInt() and hasNextInt() problems
  • Request response issues in biztalk
  • Outlines on links in IE9 remains when focus is changed
  • How to retrieve information from antrun back to maven?
  • netsh acl setting (need alternative method - registry settings?)
  • jQuery: How to AJAXify WordPress Search?
  • cordova is not defined - cordova.js has already been loaded :: Ionic
  • Clear fused location provider's location for testing
  • Trying to get the char code of ENTER key
  • SAVE attribute needed for Fortran variables when only the C_LOC address is returned to a C program?
  • Sonar maven jacoco code coverage for Multimodule project
  • azure media services - The request body is too large and exceeds the maximum permissible limit
  • How to clear text inside text field when radio button is select
  • How to avoid particles glitching together in an elastic particle collision simulator?
  • Recording logins for password protected directories
  • Splitting given String into two variables - php
  • Why ng-show works with ng-repeat but ng-if doesn't? [duplicate]
  • Fetching methods from BroadcastReceiver to update UI
  • Excel - Autoshape get it's name from cell (value)
  • Check if a string to interpolate provides expected placeholders
  • Shallow update not allowed (git > 1.9)
  • jquery mobile loadPage not working
  • RestKit - RKRequestDelegate does not exist
  • Traverse Array and Display in markup
  • Data Validation Drop Down Box Arrow Disappearing
  • How to include full .NET prerequisite for Wix Burn installer
  • How do you join a server to an Active Directory (domain)?
  • Qt: Run a script BEFORE make
  • Observable and ngFor in Angular 2
  • How to Embed XSL into XML
  • UserPrincipal.Current returns apppool on IIS
  • Conditional In-Line CSS for IE and Others?
  • How to push additional view controllers onto NavigationController but keep the TabBar?