diff options
| -rw-r--r-- | ansible/scripts/setup-mssql.ps1 | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/ansible/scripts/setup-mssql.ps1 b/ansible/scripts/setup-mssql.ps1 index f7bcf3b..c37ee42 100644 --- a/ansible/scripts/setup-mssql.ps1 +++ b/ansible/scripts/setup-mssql.ps1 @@ -78,6 +78,9 @@ try { SqlCmd -E -Q "ALTER LOGIN sa ENABLE" SqlCmd -E -Q "ALTER LOGIN sa WITH PASSWORD = '$SvcPassword', CHECK_POLICY=OFF" + + SqlCmd -E -Q "CREATE LOGIN [CONTOSO\svc_iis01] FROM WINDOWS;" + SqlCmd -E -Q "ALTER SERVER ROLE sysadmin ADD MEMBER [CONTOSO\svc_iis01];" Write-Host "[inf] Added $NetBiosName\$SvcUsername as MSSQL login and sysadmin" Write-Host "[inf] Enabled SA login" } catch { |