search

Orange-Cyberdefense / GOAD

game of active directory
GNU General Public License v3.0
5.45k stars 755 forks source link

NHA lab, failed to start MSSQL Server #259

Open eltchard opened 3 months ago

eltchard commented 3 months ago

An exception occurred during task execution. To see the full traceback, use -vvv. The error was: at , : line 1064 fatal: [srv02]: FAILED! => {"changed": false, "msg": "Unhandled exception while executing module: Failed to start service 'SQL Server (SQLEXPRESS) (MSSQL$SQLEXPRESS)'."} How would i fix this issue?

haraldaarz commented 2 months ago

This is also an issue using Vmware with Docker on SRV03.

haraldaarz commented 2 months ago

This is also an issue using Vmware with Docker on SRV03.

For anyone else with the same issue as me, the fix was simply to delete everything, and reinstall.

CalfCrusher commented 1 month ago

I also tried deleting and reinstalling, but the same problem persists. Goad, GoadLight, SSCM, NHA—nothing works. Everything is completely broken and bugged. I’m not sure what the point is of destroying something that previously worked; I really don’t know. Maybe someone could upload the older versions? Because this repo is a mess now.

chrisrc05 commented 1 week ago

I was able to resolve this error in my lab (GOAD-Light). srv02 was failing with sql service error. I attempted to start the SQL server (SQLEXPRESS) service manually, but the service would start then immediately stop.

Solution steps taken:

  1. uninstalled sql server from srv02 system.
  2. rebooted srv02 system.
  3. reinstalled sql server application. all default install settings.
  4. Confirmed the SQL server (SQLEXPRESS) was able to run successfully. re-ran the ansible script -t install. I no longer see the sql error in the ansible playbook output.