24496

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

Question:

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:

<blockquote>

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.

</blockquote>

The following is the things that I've tried:

<ol><li>

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.

Answer1:

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

Answer2:

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.

Recommend

  • 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?