Know How to Start SQL Server Service While Installing in Windows 11

SQL Server Service in Window 11

How to Start SQL Server Service During Installing in Windows 11


Overview

We recently encountered an issue with the SQL Server service not starting in Windows 11. The error is below-mention:

SQL Server error.


If you have this type of issue while installing SQL, then here is the solution.

Do follow the below-given steps to learn the process

  1. Search the Command Prompt option in your system.
  2. Click on the Run as Administrator option.
Reference image:

Run as administrator.

  1. A new window of administrator will appear in next slide.
  2. Copy the following line: ( REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t   REG_MULTI_SZ /d "* 512" /f )
  3. After that, paste the copied line into the administrator command window.
  4. Then, press enter and close the window with exist button.
Note: To solve this issue, we found the following solution: after changing the value to 512 in place of 4095 the SQL server service works.

Reference image:

Run command to enable SQL server.

  1. After doing above-given process Restart your system and again Reinstalled the SQL server.
Note: There are several reasons why the SQL service is not functioning, but the command error is one of them. So users can do the process as mentioned above for Installation.

      • Related Articles

      • Create GST Input Service Invoice

        How to create GST input service invoice in SwilERP  What is GST Input? 'Input Tax Credit' or 'ITC' means the Goods and Services Tax (GST) paid by a taxable person on any purchase of goods and services used or used for business. ITC value can be ...

      • How to Setup MySQL Server for AllScan Process

        MySQL Installer Guide For successful implementation of the Allscan process in SwilERP software, the initial step involves installing MySQL on your system. This article provides a detailed, step-by-step guide on setting up MySQL. Step: 1 Download & ...

      • SQL Service Auto Not Start (CREATE RETAILGRAPH SHORTCUT WITH ADMIN PRIVILEGES)

        CREATE SwILerp (Retailgraph) SHORTCUT WITH ADMIN PRIVILEGES In case facing issues related to SQL server auto not start, A better solution is to create a shortcut of RetailGraph that has administrator privileges. Right-click the RetailGraph icon ...

      • Create GST Output Service Invoice

        How to create GST Output service invoice in SwilERP  What is GST Output? Output GST is the GST that is applied to sales of goods or services provided. Output tax paid, the GST is paid either by availing of input tax credit or cash.  If a user sells ...

      • Timely Fashion Error in start SQL services

        Timely Fashion Error in start SQL services Many times we have faced error message as “Timely Fashion” in case start SQL services. We can solved same by follow below steps Step 1 => Go to C:\Program Files\Microsoft SQL ...