How to start sql server

Question

How to start sql server

Kailas Rautrao 0

When I am trying to open sqlserver file from binn folder it giving me an error as, Your SQL Server installation is either corrupt or has been tampered with(Error getting instance id from name). Please uninstall then re-run setup to correct this problem.
How ever I 7-8 times I done uninstallation and installation still problem is not resolved .

2 answers

Your answer

Answer 1

Michael Taylor 60,161

You cannot "start" SQL Server directly. It is a service and can only be run as such. By default SQL Server should be running all the time (assuming you installed Standard or higher edition). Express may not run by default.

The UX approach is to go to Services (as an admin), scroll down to Microsoft SQL Server and then Start the service. If you want a non-UX approach then start Powershell as an admin (only admins can start services) and run this.

start-service MSSQL

Note that this assumes you are using the default instance name of SQL. If you named your SQL instance then the service name is different. To get the service name do this.

get-service mssql*

The actual SQL instance will be something like MSSQL$instancename.

If SQL is not configured to auto-start and you need it running all the time then ensure the start type is set to Automatic.

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-02-26T22:36:00.5766667+00:00

To be picky, you can start SQL Server directly from the BINN folder, but it is something we do for very special operations, so Michael is right on the money that it should run as a service. The normal place to start the service is the SQL Server Configuration Manager.

As for the error message, this occurs when you try to run sqlservr.exe without the -s option and you don't have a default instance. But that is a moot point, as you would only start SQL Server this way under very special circumstances.

Answer 2

LiHongMSFT-4306 31,566

Hi @Kailas Rautrao

How to start sql server

Manually start in the Windows Services console (Administrative Tools->Services), or make it start automatically when Windows starts.
Manually start in SQL Server Configure Tools->SQL Server Configuration Manager.
Manually start in SQL Server Management Studio.
In the Windows command line window, run "sqlservr.exe -c -s INSTANCENAME".

In the first three methods, SQL Server will be started as a background service. SQL Server logs are recorded in a log file. The last way is to run SQL Server as a generic application. SQL Server log information will appear in the current command line window. If you close the command line window directly, the SQL Server process will also be closed.

Best regards,

Cosmog Hong

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".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Kailas Rautrao 0 Reputation points

2024-02-27T04:49:26.8333333+00:00

Hello,
I have followed all this steps, but It giving me an error AS:- sqlservr.exe -c -s INSTANCENAME 2024-02-27 10:16:32.03 Server Error: 17058, Severity: 16, State: 1. 2024-02-27 10:16:32.03 Server initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG'. Operating system error = 32(The process cannot access the file because it is being used by another process.).
Michael Taylor 60,161 Reputation points

2024-02-27T05:54:49.47+00:00

You're already running an instance of SQL Express. You cannot have 2 instances of the same SQL process running at the same time.
Kailas Rautrao 0 Reputation points

2024-02-27T07:06:04.18+00:00

Why should be my next step ? Could help me with it?
Michael Taylor 60,161 Reputation points

2024-02-27T15:01:58.4033333+00:00
We'd be guessing at this point. You really haven't clarified to us what the state of your system is.

Go to Services and check the status of Microsoft SQL Express. Is it running? Can you post the results of running the get-service mssql* powershell command I gave earlier?

Go to SQL Server Management Studio and connect to your SQL Express instance. Does it work?

Possible things that could be wrong:

You don't actually have SQL Express installed and running. Many apps auto-installed SQL Express over the years so it could very well be messed up.

The database files may have their permissions totally messed up preventing SQL from accessing them.

Uninstalling SQL Express and installing a newer version in a different directory may help identify an issue with permissions or the engine that you are currently using.
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-02-27T22:26:00.4166667+00:00

I have followed all this steps, but It giving me an error AS:- sqlservr.exe -c -s INSTANCENAME 2024-02-27 10:16:32.03 Server Error: 17058, Severity: 16, State: 1. 2024-02-27 10:16:32.03 Server initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG'. Operating system error = 32(The process cannot access the file because it is being used by another process.).

Again, this is not how you start SQL Server. And, as Michael points out, the error message suggests that SQL Server is already running. Can you post a screenshot from the SQL Server Configuration Manager?

Share via

How to start sql server

2 answers

Your answer