chocolatey / chocolatey/choco-quickstart-scripts
Change SQL Server Service from Automatic (Delayed Start) to Automatic during CCM Deployment
- Dominant language
- PowerShell
- Stars
- 23
- Forks
- 15
- PR merge metrics
- No merged PRs in 30d
Description
### Checklist
- [x] I have verified this is the correct repository for opening this issue.
- [x] I have verified no other issues exist related to my request.
### Is Your Feature Request Related To A Problem? Please describe.
When the Quick Start Environment is deployed, SQL Server Express is installed on the machine to host the ChocolateyManagement database used with Chocolatey Central Management (CCM). The default setup for the SQL Server Service is Automatic (Delayed Start). This causes an issue with the CCM Website; when IIS attempts to bring up the website before the SQL Server Service has started, an issue with too many redirects prevents the CCM Website from working until IIS has been restarted.
### Describe The Solution. Why is it needed?
A one-line code adjustment can be added to the Start-C4bCcmSetup.ps1 that would set the SQL Server Service to Automatic instead of Automatic (Delayed Start). This allows the SQL Server Service to launch before IIS and prevent the issue mentioned above from occurring.
The one-line piece of code is `sc.exe config 'MSSQL$SQLEXPRESS' start=auto` and shouldn't cause any issues.
### User Story
As a CCM Web user, I want my CCM Website to be operational without having to rely on troubleshooting measures.
### Additional Context
_No response_
### Acceptance Criteria
- [ ] Add the one-line code piece to set the SQL Server Service to Automatic.
- [ ] Ensure deployment of Quick Start Guide continues as normal.
- [ ] Ensure automatic testing of Quick Start Guide is unaffected and that all tests pass.
### Related Issues
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.