Windows server 2019 - role and feature problem

Start the
577bf0efb8088-FRST.png
Farbar Recovery Scan Tool again.

Warning: This script was written specifically for this system. Do not run this script on another system.
  • Download the attachment fixlist.txt and save it to your desktop.
  • Right-click on FRST.exe and select "Run as administrator".
  • Press the Fix button.
  • If for some reason the tool needs a restart, please make sure you let the system restart normally.
  • When finished, a log called Fixlog.txt will appear in the same directory the tool is run from.
  • Post the logfile Fixlog.txt as attachment in your next reply.
 

Attachments

Open an elevated command prompt an run the following command:
Code:
sc start MSSQL$MICROSOFT##WID
...wait a few seconds and run the following commands:
Code:
sc query MSSQL$MICROSOFT##WID
sc qc MSSQL$MICROSOFT##WID

Copy and paste the result from the command prompt in your next post.
 
here is it
 

Attachments

  • Screenshot 2024-10-14 170123.png
    Screenshot 2024-10-14 170123.png
    180.6 KB · Views: 1
As expected this service failed with error 1067 (0x42b) which means that the service terminated unexpectedly!

Is the Windows Internal Database feature installed correctly on this server?
Let's also check the services hive.

Export registry key as hive file.
  • Open the Start menu of Windows and type CMD.
  • When you see Command Prompt on the list, select the option Run as administrator.
  • Copy and paste the following command into the command prompt and press enter.
Code:
reg save "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services" "%userprofile%\Desktop\Services.hiv"
  • Once done, a file will appear on your desktop, called Services.hiv.
  • ZIP this file and attach it to your next reply.
 
Okay, please do the following:

Download
6530fbb0f4101-56f31e53c97da-SFCFix.PNG
SFCFix and save it to your desktop.

Warning: This fix was written specifically for this system. Do not run this fix on another system.
  • Save any work you have open, and close all programs.
  • Download the attachment SFCFixScript.txt and save it to your desktop.
  • Drag the SFCFixScript.txt file over the SFCFix.exe executable and release it.
650ef5dbdfd06-62151e1bebac4-SFCFix-Txt-Eng.gif

  • SFCFix will launch, let it complete.
  • Once done, a file will appear on your desktop, called SFCFix.txt.
  • Post the logfile (SFCFix.txt) as attachment in your next reply.
 

Attachments

Please do the following again but copy paste the result in your next post instead of an screenshot!

Open an elevated command prompt an run the following command:
Code:
sc start MSSQL$MICROSOFT##WID
...wait a few seconds and run the following commands:
Code:
sc query MSSQL$MICROSOFT##WID
sc qc MSSQL$MICROSOFT##WID

Copy and paste the result from the command prompt in your next post.
 
sorry for delay i had in site dute and for not posting as copy pest :
_____________________________________________________

Microsoft Windows [Version 10.0.17763.6414]
(c) 2018 Microsoft Corporation. All rights reserved.

C:\Users\Administrator>sc start MSSQL$MICROSOFT##WID

SERVICE_NAME: MSSQL$MICROSOFT##WID
TYPE : 10 WIN32_OWN_PROCESS
STATE : 2 START_PENDING
(NOT_STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x7d0
PID : 7548
FLAGS :

C:\Users\Administrator>sc query MSSQL$MICROSOFT##WID
SERVICE_NAME: MSSQL$MICROSOFT##WID
TYPE : 10 WIN32_OWN_PROCESS
STATE : 1 STOPPED
WIN32_EXIT_CODE : 1066 (0x42a)
SERVICE_EXIT_CODE : 3417 (0xd59)
CHECKPOINT : 0x0
WAIT_HINT : 0x0

C:\Users\Administrator>sc qc MSSQL$MICROSOFT##WID
[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: MSSQL$MICROSOFT##WID
TYPE : 10 WIN32_OWN_PROCESS
START_TYPE : 3 DEMAND_START
ERROR_CONTROL : 1 NORMAL
BINARY_PATH_NAME : C:\Windows\WID\Binn\sqlservr.exe -SMSWIN8.SQLWID -sMICROSOFT##WID
LOAD_ORDER_GROUP :
TAG : 0
DISPLAY_NAME : Windows Internal Database
DEPENDENCIES : WIDWriter
SERVICE_START_NAME : NT SERVICE\MSSQL$MICROSOFT##WID

C:\Users\Administrator>
 
Hi,

Please try to uninstall and reinstall the Windows Installer Database feature to see if it will resolve the service issue.
 
sorry for the delay reply i had important work to do so let me tell you what i have done in the last few days.

i saw my TrueNAS had 1 Degraded and 1 failure Hard so i had to replace them i though its was the problem since the beging becuse am using Raid-Z2 and the feauters files might be in the failure hard so i have started everything as Fresh start.

i have installed the new WS2019 in my new VM and updated it and i gave it a new try to install the featuers but sadly i could not success.

the only thing i can do is to install the Remote Access without any features.
 

Attachments

  • Screenshot 2024-11-02 172139.webp
    Screenshot 2024-11-02 172139.webp
    40.2 KB · Views: 1
Hmm, that's odd! Which error code did you see on the new installation of Server 2019 when tried to install the features?
 
ok brother i found my issue and am trying to solve it what i have done i have checked the required features to install the Direct Access-VPN
i the RSAT was missing and i installed it and all the required Features but i have been stuck on the one you told me before
(Microsoft-Windows-internal-Database)
this is my issue and i tried to download it by :
DISM /Online /Enable-Feature /FeatureName:Windows-Internal-Database /All /LimitAccess /Source:E:\sources\sxs
i got error i searched in the SXS folders to check if the file of that Feature there and i ccant find it now am tried to find if someone is sharing this file to copy paste it inside the folder (microsoft-windows-netfx3-ondemand-package~31bf3856ad364e35~amd64~~.cab)

or if u can offer me anyother solution thats will be greate keep in mind the ISO file has been downloaded from the Official site of microsoft.
 

Attachments

  • Screenshot 2024-11-02 194904.webp
    Screenshot 2024-11-02 194904.webp
    49 KB · Views: 1
Open the Server Manager > Add roles and Features > GOTO > features and try to install the Windows Installer Database first and take a screenshot of the result.
 
same error
 

Attachments

  • Screenshot 2024-11-02 200753.webp
    Screenshot 2024-11-02 200753.webp
    46.4 KB · Views: 2
i have installed the new WS2019 in my new VM and updated it
Is this really a fresh install on your TrueNAS system? I don't run that software so I cannot test some things.
However, are you able to setup the same server in Hyper-V to see if you have the same issues, just to rule out this is an issue with TrueNAS / VM specs etc....
 

Has Sysnative Forums helped you? Please consider donating to help us support the site!

Back
Top