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?

0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.