Share via
Jashobanta Chakraborty 1Reputation point
I am trying to Install SQL Server 2019 Developer Edition in my personal laptop for some training purposes. But during installation, I keep getting the 0x851a0019 Could Not Find Database Engine Startup Handle error.
I have tried changing the SQL Server Database Services' account name to NT Authority/System as mentioned in the below Microsoft Blog, followed all the steps, but I still keep getting the same error. What additional steps do I need to do to make sure it installs fine?
108559-summary-jashobanta-hewlett-20210623-194757.txt
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,104 questions
Sign in to follow
0{count} votes
Erland Sommarskog 113.2KReputation points • MVP
2021-06-23T21:45:00.45+00:00 For this error, you need to look into the SQL Server errorlog. This error indicates that SQL Server did not start successfully, when Setup wanted to run installation scripts.
You find the errorlog in C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\LOG\Errorlog
By the way, NT Authority\System is not a good choice for the service account.
Jashobanta Chakraborty 1Reputation point
2021-06-24T03:07:08.783+00:00 @Erland Sommarskog I checked the logs, but not getting any help on how to get it resolved. See the attached.
108839-errorlog.log
Seeya Xi-MSFT 16,471Reputation points
2021-06-25T07:05:37.667+00:00 Hi @Jashobanta Chakraborty ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it dosn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
See AlsoSQL Express 2019 Install Failure of Database Engine Component error code: 0x851A001A on Windows 11. - Microsoft Q&ATroubleshooting operating system disk sector size greater than 4 KB - SQL ServerProblembehandlung bei der Größe des Betriebssystemdatenträgersektors größer als 4 KB - SQL ServerJashobanta Chakraborty 1Reputation point
2021-06-26T11:40:32.277+00:00 I did not get to check that out with SQL Server. I had moved to MYSQL as the installation went fine for that. But I will check and get back within few days.
Seeya Xi-MSFT 16,471Reputation points
2021-06-28T06:16:36.907+00:00 Hope your problem can be solved.
Sign in to comment
3 answers
Sort by: Most helpful
Most helpful Newest Oldest
-
Erland Sommarskog 113.2KReputation points • MVP
2021-06-24T21:08:32.017+00:00 The problem is that the paths for the resource database and model are incorrect. They look like the paths from some build server in Redmond.
I note that you have select a non-default location for your installation. I can't say whether this is the reason, but you could try a new install with a default location.
Jashobanta Chakraborty 1Reputation point
2021-06-26T11:44:31.767+00:00 Yes, the paths which are there are actually not available in my machine. And yes, I have selected D-Drive as I have limited space in my C Driver which is the default drive. For now, I settled with MYSQL instead of SQL Server which ran smooth, but I will be installing it in few days. Will update whatsoever.
Gangaraj Saravanaperumal 1Reputation point
2022-01-28T04:55:44.907+00:00 I am still facing this issue can anyone help me out with this?
Erland Sommarskog 113.2KReputation points • MVP
2022-01-28T22:30:20.333+00:00 Are you the same person? Or are you someone else who piggybacks on old thread? I would suggest that in either case that you start a new thread, describing your problem from start to end and including relevant log files, since your problem may be different from the post in June.
Sign in to comment
-
Seeya Xi-MSFT 16,471Reputation points
2021-06-24T03:39:33.31+00:00 Hi @Jashobanta Chakraborty ,
You can also try to uninstall SQL Server and reinstall it.
And before reinstall, please follow the below steps to remove all components of previous installed SQL Server completely:- Remove all SQL Server components from 'Programs and Features'
- Backup the registry
- Delete the following keys in regedit:
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer - Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
- Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
- Reboot the machine
Then right click on Setup.exe and select run as administrator.
When you reach Server Configuration page where you select Service account please select Local System account(NT AUTHORITY\SYSTEM). After the installation is successful, you can choose another account to log in.
Best regards,
SeeyaIf the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
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.Gangaraj Saravanaperumal 1Reputation point
2022-01-28T04:56:42.567+00:00 I could not find the server configuration page while installing.
Seeya Xi-MSFT 16,471Reputation points
2022-01-28T06:22:28.587+00:00 Can you be more detailed, is there any other interface that appears, or is there any error message?
Gangaraj Saravanaperumal 1Reputation point
2022-01-28T07:36:46.457+00:00 No, I am facing the same error. As you mentioned above I could not find where to select a Local system account while installing SQL server.
Sign in to comment
-
Serkan Özden 0Reputation points
2024-08-02T12:40:53.4433333+00:00 Hi uninstall after,
try this https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size
Add Key on PowerShell,
New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString -Force -Value "* 4095"0 commentsNo comments
Sign in to comment
Sign in to answer
