Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SqlSetup: Agent service is hard coded to start automatically #464

Closed
johlju opened this issue Apr 1, 2017 · 1 comment · Fixed by #1529
Closed

SqlSetup: Agent service is hard coded to start automatically #464

johlju opened this issue Apr 1, 2017 · 1 comment · Fixed by #1529
Labels
breaking change When used on an issue, the issue has been determined to be a breaking change. enhancement The issue is an enhancement request.

Comments

@johlju
Copy link
Member

johlju commented Apr 1, 2017

Details of the scenario you try and problem that is occurring:
When installing a stand alone SQL Server then agent service is always set to be started automatically.

$setupArguments += @{ AgtSvcStartupType = 'Automatic' }

This should be set thru a variable instead.

The DSC configuration that is using the resource (as detailed as possible):
n/a

Version of the Operating System, SQL Server and PowerShell the DSC Target Node is running:
n/a

Version of the DSC module you're using, or 'dev' if you're using current dev branch:
Dev

@johlju johlju added enhancement The issue is an enhancement request. help wanted The issue is up for grabs for anyone in the community. labels Apr 1, 2017
@johlju johlju changed the title xSQLServerSetup: Agent service is hard coded to start automatically SqlSetup: Agent service is hard coded to start automatically Dec 22, 2017
@johlju johlju added the breaking change When used on an issue, the issue has been determined to be a breaking change. label May 6, 2020
@johlju
Copy link
Member Author

johlju commented May 6, 2020

This should be resolved.

if ($PSBoundParameters.ContainsKey('AgtSvcStartupType'))
{
$setupArguments.AgtSvcStartupType = $AgtSvcStartupType
}
else
{
$setupArguments += @{
AgtSvcStartupType = 'Automatic'
}
}

@johlju johlju added in progress The issue is being actively worked on by someone. and removed help wanted The issue is up for grabs for anyone in the community. labels May 6, 2020
johlju added a commit that referenced this issue May 7, 2020
…tomatic (#1529)

- SqlSetup
  - BREAKING CHANGE: Now if the parameter `AgtSvcStartupType` is not specified
    in the configuration the resource will no longer by default add an
    argument to `setup.exe` with a value of `Automatic` for the argument
    `AGTSVCSTARTUPTYPE`. If the parameter `AgtSvcStartupType` is not specified
    in the configuration there will be no setup argument added at all
    (issue #464).
@johlju johlju removed the in progress The issue is being actively worked on by someone. label Jul 10, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
breaking change When used on an issue, the issue has been determined to be a breaking change. enhancement The issue is an enhancement request.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant