NHA lab, failed to start MSSQL Server

[eltchard]

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]

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

[haraldaarz]

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]

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]

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.