From 6b73a149e440592e988d97e41353aedb64cc86cb Mon Sep 17 00:00:00 2001
From: heqnx <root@heqnx.com>
Date: Wed, 16 Jul 2025 20:36:21 +0300
Subject: fixed running sql through websql to mssql02

---
 ansible/scripts/setup-mssql.ps1 | 3 +++
 1 file changed, 3 insertions(+)

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 {
-- 
cgit v1.2.3