Failure validating ssrs instance mssqlserver
All issues are not listed here, see here for all open issues.
This resource is used to create or delete a database.
In SQL Server, there are error few messages which can be caused due to multiple reasons.
One of the famous example is “Login Failed for User” error message.
This is the development branch to which contributions should be proposed by contributors as pull requests. You can also improve the resources and tests, or even create new resources, by sending in pull requests yourself.
This resource is used to create a database role when Ensure is set to 'Present' or remove a database role when Ensure is set to 'Absent'.
The resource also manages members in both built-in and user created database roles.
Based on my search on the internet, there is some kind of loopback, check taking place which causes trusted connections via the loopback adapter to fail.
Loopback check can be removed by adding a registry entry as follows: If above doesn’t solve the issue, we need to create SPNs for SQL Service account.