dsccommunity / dsccommunity/SqlServerDsc
SqlServerDsc: Integration tests should run with the SqlAdmin user
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
There are integration tests that are using the installation account to configure the SQL Server instance objects (like databases, logins, etc.). Where applicable the 'SqlInstall' account should be changes to 'SqlAdmin' so that the 'SqlAdmin' account runs those resources in the integration tests.
See users that are created for the integration tests here:
https://github.com/PowerShell/SqlServerDsc/tree/dev/Tests/Integration#users
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start in Tests/Integration and review the users section linked in the issue to understand the SqlInstall and SqlAdmin accounts. Find integration tests that configure SQL Server instance objects with SqlInstall, change them where applicable to use SqlAdmin, and confirm the affected resources run under the intended account.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell
- Domain
- databases, testing-qa
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100