All geek questions in one place

SQL Server service is not available in the list of services after installing SQL Server Management Studio

I have Windows 7 Home Edition SP1 installed on my system and downloaded SQL Server 2008 R2 Management Studio and installed it. But when I try to connect through. \ SQLEXPRESS, SSMS shows an error

When connecting to SQL Server, a network-related or specific instance error occurred. The server was not found or was not available. Verify the instance name is correct and configure SQL Server to connect remotely. (vendor: SQL network interfaces, error: 26 - server / instance location error) (Microsoft SQL Server, error: -1) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+ Server & EvtSrc = MSSQLServer & EvtID = -1 & LinkId = 20476 .

I am returning to check on-premises services where I cannot find SQL Server services.

What should I do for this? Do I need to install any SQL service on my system? or how should I proceed?

+6
source share
2 answers

downloaded Sql server management 2008 r2 and installed it. this is during installation, but when I try to connect it through. \ SQLEXPRESS it shows an error. Do I need to install any SQL service on my system?

You have installed management studio, which is just a management interface for SQL Server. If you do not have (however), you already have SQL Server installed, you need to install it so that it is included in your system and uses it.

http://www.microsoft.com/en-us/download/details.aspx?id=1695

+12
source

You need to start SQL Server manually. Click

windows + R

a type

services.msc

Find the entry that says

SQL Server (SQLEXPRESS)

right click and run.

0
source

Source: https://habr.com/ru/post/973480/

More articles:


All Articles