Where can I see if the Sql-Sever is running?
SQL Server is a Windows service, so you can see it in Windows Service Manager.
See additional Troubleshoot connectivity issues in SQL Server
Problem accessing SQL Server on local maskin
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 52%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVW%3C/text%3E%3C/svg%3E)
Victor Wallenberg
6
Reputation points
Hi
I have a SQL Server on my local workstation i7/16GB. I us it for development and have several databases on it. I worked on it on Friday and when i started to work on it on Saturday morning i couldn't access the it.
I have tried everything, but nothing works
Where can I see if the Sql-Sever is running?
The eror that i get when trying to logon to the Sql Server
SQL Server | Other
{count} votes
-
Viorel 125.7K Reputation points2023-02-13T08:34:17.6333333+00:00 There is a "SQL Server Configuration Manager" (which can be found in Start menu or with Search) that displays the status of services and available protocols.
-
Victor Wallenberg 6 Reputation points
2023-02-13T09:52:39.4933333+00:00 Hi
The one that I can't access is SQLEXPRESS, the new one NEW works fine. I looks like the process SQL Server (SQLEXPRESS) how to I start that one.
SQLEXPRESS was installed 1 year ago, NEW I installed after that I got the problem with SQLEXPRESS
Sign in to comment
3 answers
Sort by: Most helpful
-
Olaf Helper 47,586 Reputation points2023-02-13T08:22:54.6133333+00:00 -
Erland Sommarskog 128.9K Reputation points MVP Volunteer Moderator2023-02-13T22:38:53.91+00:00 Tjena grabben!
First of all, as Viorel says, use the SQL Server Configuration Manager to view and control the SQL Server services.
Next, try to start the SQLEXPRESS instance.
If it does not, chech the SQL Server errorlog, which is in C:\Program Files\Microsoft SQL Server\MSSQLnn.SQLEXPRESS\MSSQL\LOG\ERRORLOG assuming a default installation. nn here is the version number for the instance.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,676 Reputation points2023-02-23T06:47:41.3133333+00:00 Hi @Victor Wallenberg ,
Comparing your screenshot with mine, it seems that your SQLEXPRESS instance is not started, you can right click to start it.
In addition, you can do some checks:
Go to All Programs –> Microsoft SQL Server –>SQL Server Configuration Manager–>SQL Server Network Configuration–> Protocols
Check if the TCP/IP is ‘Disabled’ then right click on the TCP/IP and click Enable.
For other more comprehensive troubleshooting please see the link Olaf posted.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".