0

I am not able to connect to my (LocalDb)\v11.0 from OLAP Cube project while deploying because of the SQL Server Browser Service is not running.

I am getting error like

"Error 4 The project could not be deployed to the '(LocalDb)\v11.0' 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"

So I opened the SQL server configuration manager and tried to make the sql server browser service on but I am not able to find it in the configuration manager

Please suggest what should I do?

TheGameiswar
  • 27,855
  • 8
  • 56
  • 94
Vaijinath Harbak
  • 149
  • 3
  • 10
  • What is the exact version of your SQL Server installation. Run `SELECT @@VERSION;` on your target SQL Server database. – TT. Apr 19 '17 at 14:16
  • Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) – Vaijinath Harbak Apr 19 '17 at 14:18
  • This is very odd, maybe you can install it afterwards by running the setup once again ? – Hybris95 Apr 19 '17 at 14:21
  • That is not the whole version. It should include whether it's standard edition, express edition, enterprise edition etc. Copy the whole string please. – TT. Apr 19 '17 at 14:30
  • @TT. Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) Oct 19 2012 13:38:57 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) – Vaijinath Harbak Apr 19 '17 at 14:34
  • 1
    Did you browse through this: http://stackoverflow.com/q/21375014/243373 – TT. Apr 19 '17 at 14:37
  • 1
    Also this: https://serverfault.com/q/383177/250310 – TT. Apr 19 '17 at 14:40
  • Yes, but I am not able to see the SQL Server Services I.e even not able to see the sql server instance – Vaijinath Harbak Apr 19 '17 at 14:45
  • Actually on my local machine SQL server is not installed only SSMS is installed, thats why I am not able to see the SQL services in the SQL Configuration Manager. And I am connecting the (LocalDb)\v11.0 through SSMS. Thank you all for your comments. – Vaijinath Harbak Apr 20 '17 at 06:40

0 Answers0