SqlPermission: Undefined DSC resource 'SqlPermission'

SqlPermission: Undefined DSC resource 'SqlPermission'

[johlju]

I cannot reproduce this.

Note

PS 7.x won't work since it does not support DSC resources in the way that Windows PowerShell does. See the work being done for DSCv3.

On a clean Windows machine I installed VS Code + PowerShell extension. Using Windows PowerShell I installed SqlServerDsc to machine PSModulePath (C:\Program Files\WindowsPowerShell\Modules). In VS Code the PowerShell extension is also running under Windows PowerShell. I pasted in an example from the wiki page and in ran as expected. Also SqlPermission is visible in intellisense when editing the example.

Hi,

I am on vacation and will be able to reply again no later than October. But until then, maybe you can tell what I can provide for more information. Greetings

[johlju]

Since it was not possible to reproduce . Clear step-by-steps that shows how to reproduce the problem on a clean Windows 11 or Windows Server box (with just VS Code + VS Code PowerShell extension installed).

[github-actions]

This issue has been automatically marked as stale because it has not had activity from the community in the last 30 days. It will be closed if no further activity occurs within 40 days. If the issue is labelled with any of the work labels (e.g bug, enhancement, documentation, or tests) then the issue will not auto-close.

[github-actions]

This issue has been automatically closed because it is has not had activity from the community in the last 40 days. If this issue was wrongly closed, for a issue author please comment and re-open it, if you are not the issue author comment with a reason for it to be reopened and tag a maintainer in the comment.

[rismoney]

I think I am experiencing this issue

I ran the following command but got Get-CimClass: Not Found

$resource = Get-DscResource -Name sqlpermission 
Get-CimClass -ClassName $resource.ResourceType -Namespace root\Microsoft\Windows\DesiredStateConfiguration

I am attempting to use this under puppet, and it cannot find sqlpermission. $resource has a value, and I see it, but I think it is not properly registering. PS 5.1, Win2022

[johlju]

I think this is not related to the issue. If Puppet is suppose to work with class-based resources then please open a new issue. Suggest talking to the Puppet team as well as the resource works with LCM in Windows, so just be related to Puppet.

[rismoney]

thank you, puppet is supposed to work with class based resoures as they state: I think it is how they autowrap the dsc module, and then templatize the parameters. I reached out to them, and opened issues on their dsc repo, since I think it might not be related to this repo, albeit the changes madeover the last year, may have created an incompatiblity with what they were doing.

Class-based DSC Resources can be used like any other DSC Resource in this module, with one important note: Due to a bug in calling class-based DSC Resources by path instead of module name, each call to Invoke-DscResource needs to temporarily munge the system-level environment variable for PSModulePath; the variable is reset prior to the end of each invocation.