0

I try to implement a SQL automated installation of SQL Server. Currently I hang with SqlServerDsc/SqlPermission. I use a block in my json:

{
    "type": "SqlServerDsc/SqlPermission",
    "name": "GrantSystemPermissions",
    "properties": {
        "ServerName": "V-MSSQL177.xxx",
        "InstanceName": "MSSQLSERVER",
        "Name": "NT AUTHORITY\\SYSTEM",
        "Permission": [
            {
                "State": "Grant",
                "Permission": [
                  "AlterAnyAvailabilityGroup",
                  "ViewServerState",
                  "ConnectSql"
                ]
            },
            {
                "State": "GrantWithGrant",
                "Permission": []
            },
            {
                "State": "Deny",
                "Permission": []
            }             
        ]
    },
    "dependsOn": ["[resourceId('SqlServerDsc/SqlSetup', 'InstallSQLServer2022')]",
                  "[resourceId('SqlServerDsc/SqlLogin', 'AddSystemLogin')]"
          ]
}

In bad I get an error with no additional information, just

2025-11-05T10:30:52.671309Z ERROR Error: JSON: expected value at line 1 column 1

Does anyone have experience with DSCv3 and SqlServerDsc/SqlPermission? I use the 17.2.0 and also 17.3.0 preview but the problem occurred in both.

Maybe someone knows sample scripts or own working json files?

Improve this question
Related questions
7
Azure Resource Manager Template Language - resourceId(): Unable to evaluate template language function 'resource Id'
402
How can I replace every occurrence of a String in a file with PowerShell?
421
Powershell Invoke-WebRequest Fails with SSL/TLS Secure Channel
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.