ansible.windows.win_dsc resource SqlPermission Not found

Hi slash83,

The easiest  solution to try to resolve the "Resource 'SqlPermission' not found" error is to install the latest version of the SQLServerDsc module. Here are the steps:

1. On the Windows VM where you are running Ansible, open a PowerShell console.
2. Run the following command to update the SQLServerDsc module:

Update-Module -Name SQLServerDsc

If the module is not installed, you can install it using the following command:

Install-Module SqlServerDsc -Force

1. Once the module is updated, verify that the SqlPermission resource is available by running the following command:

Get-DscResource -Name SqlPermission

If the command returns the SqlPermission resource, you should be able to configure SQL Server permissions using Ansible and DSC without any errors.

To verify that the SqlPermission resource is defined correctly in your DSC configuration script, check the following:

• Make sure that you are using the correct name of the resource (SqlPermission).
• Make sure that the resource name is case-sensitive.
• Make sure that all of the required properties are specified for the resource.