dsccommunity / dsccommunity/SqlServerDsc
SqlRS: Cannot set database location
Open
Nobody has claimed this yet.
bug
help wanted
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
When I define RSSQLServer, a Reporting Services database should be created on the SQL Server I define, instead, Reporting Services continues to use the database on the Reporting Services server (the one installed by default). The resource doesn't detect a 'Set' is required. No errors or warnings are produced.
xSQLServerRSConfig SQLServerRSConfig
{
InstanceName = $Node.SQLInstanceName
RSSQLServer = 'MyMainDatabaseServer'
RSSQLInstanceName = $Node.SQLInstanceName
SQLAdminCredential = $Credential
}
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 with the xSQLServerRSConfig example and trace how RSSQLServer and RSSQLInstanceName are handled when the resource evaluates configuration. Reproduce the setup against a separate SQL Server, then verify that a changed database location is detected and applied without errors or warnings.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell
- Domain
- databases, devops
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100