Sql-server – Cannot find sqlserver service

sql serversql-server-2019ssmswindows

I installed Sql Server 2019 in Windows PC.

In Sql Server Configuration Manager into SQL Server Service I stopped all the instances.

But still I can loggin to Sql Server via SSMS.why is that? Where is the Sql Server service?

In Windows Services I can see SQL Server (MSSQLSERVER01) that running and when I stopped it,I can't login to sqlserver. But why I can't see that service running in Sql Server Configuration Manager into SQL Server Service.

I login with server name:DESKTOP-IJ7544\MSSQLSERVER01

Best Answer

There are 2 types of SQL Server installed on a PC:

Server based - named instances such as \sqlexpress, \instance name or unnamed instances such as . All of these instances can be stopped by going to services.msc and stopping the service. By default, most people install unnamed instances on PCs unless they fully intend to install a named instance.
File-based - this is your localDB that may come with an installation of Visual Studio

From all indications, you may have more than one server-based installation - a unnamed instance for which you have stopped the service in services.msc and a named instance which you can still connect to.

I would go to services.msc and check to see if any of the sql instances services have a status of running. If they do, that’s why. While in services, typing “s” or “sq” fast enough should get you there faster.

Sql configuration is great for particular versions but may not reveal other instances beyond the version for which it was installed.

Related Solutions

Sql-server – SQL Server is started but didn’t listen on any port

What made my SQL server listen for TCP connections on port 1433 was the following...

Configuration Tools / SQL Server Configuration Manager
click the instance name in SQL Server Network Configuration
enable TCP communication
Right-click the TCP communication entry, choose Properties
Click the IP addresses tab
Enable all non-VMnet IP addresses and enter 1433 in the Port entry for "IPAll".
Restart the SQL Server on SQL Server Services tab

Check your configuration with netstat -an:

C:\>netstat -an | find "1433"
  TCP    0.0.0.0:1433           0.0.0.0:0              LISTENING
  TCP    [::]:1433              [::]:0                 LISTENING

sql-server – SQL Server Services Empty in Configuration on Windows 10

I did the upgrade on my laptop with SQL Server 2008 R2 and SQL Server 2012 already installed. The issue I had was that SSCM actually disappeared from the Start Menu, if after repair it would not put them back. I ended up finding them under the Windows root directory, but have since done a complete reinstall of Windows 10 on my laptop, and reinstalled SQL Server.

I would expect you are looking at a similar situation that is going to require a reload of Windows 10. You might try just doing the refresh, where it does not completely remove everything...but I doubt that is going to work. I did a factory reset where I went back to Windows 8.1, then forced an upgrade to Windows 10. Which I might add, doing that seemed to have improved Windows 10 at least on my laptop (Lenovo Y 40-80) compared to running it after the upgrade.

One last chance you might attempt is to install the SSMS preview (standalone of SSMS) from here.

Best Answer

Related Solutions

Sql-server – SQL Server is started but didn’t listen on any port

sql-server – SQL Server Services Empty in Configuration on Windows 10

Related Question