Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server 2014 - No services installed in SQL Configuration Manager

Tags:

sql

sql-server

I have Installed Microsoft® SQL Server® 2014 Express , but I can't find SQL Server Services to run it in the "SQL Server Configuration Manager", so I can't connect to SQL server.

It's a problem because when I launch Sql Server Management Studio and that I try to connect me on the database server with server name "(local)", "localhost", "SQLEXPRESS",(local)/SQLEXPRESS, it doesn't work

I've seen in services.msc and I saw "SQL Server VSS Writer" launched automatically.

Do you have a solution ?

Thank you

like image 613
user3714203 Avatar asked Jun 09 '14 09:06

user3714203


2 Answers

If you download from http://www.microsoft.com/en-us/download/details.aspx?id=42299, make sure use SQLEXPRADV_x86_ENU.exe or SQLEXPR_x86_ENU.exe. SQLManagementStudio_x86_FRA.exe does not contains database engine.

like image 190
qxg Avatar answered Sep 22 '22 01:09

qxg


I want to think that I had the same issue. When this happened to me, I went to the Configuration Manager only to learn that I had no Services whatsoever. I solved it by installing the SQL Server Express with with Advanced Services version from Microsoft.

I don't know whether you do need all its functionality, though. But what I do know is that it will solve your issue.

like image 31
Edd Avatar answered Sep 25 '22 01:09

Edd