Windows server 2019 - role and feature problem

[satan]

done btw i moved the fixlist and farbar to desktop then i did fix

 

[Maxstar]

Start the

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.

 

[satan]

done

 

[Maxstar]

Open an elevated command prompt an run the following command:

sc start MSSQL$MICROSOFT##WID

...wait a few seconds and run the following commands:

sc query MSSQL$MICROSOFT##WID
sc qc MSSQL$MICROSOFT##WID

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

 

[satan]

here is it

 

[Maxstar]

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.

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.

 

[satan]

yes all installaion was correct brother

 

[Maxstar]

Okay, please do the following:

Download

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.

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

 

[satan]

done

 

[Maxstar]

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:

sc start MSSQL$MICROSOFT##WID

...wait a few seconds and run the following commands:

sc query MSSQL$MICROSOFT##WID
sc qc MSSQL$MICROSOFT##WID

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

 

[satan]

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>

 

[Maxstar]

Hi,

Please try to uninstall and reinstall the Windows Installer Database feature to see if it will resolve the service issue.

 

[satan]

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.

 

[Maxstar]

Hmm, that's odd! Which error code did you see on the new installation of Server 2019 when tried to install the features?

 

[satan]

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.

 

[Maxstar]

Which .NET features are installed on this VM?

 

[satan]

4.7

 

[Maxstar]

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.

 

[satan]

same error

 

[Maxstar]

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