chocolatey / chocolatey/choco-quickstart-scripts

Change SQL Server Service from Automatic (Delayed Start) to Automatic during CCM Deployment

Open
#323 1 comment 0 reactions 1 assignee Claimed by @ryanrichter94 View on GitHub
Enhancement
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.