summaryrefslogtreecommitdiff
path: root/ansible/scripts
diff options
context:
space:
mode:
authorheqnx <root@heqnx.com>2025-07-15 22:59:23 +0300
committerheqnx <root@heqnx.com>2025-07-15 22:59:23 +0300
commitbc8a03d6f0a00ee8fb8052052efb3d126c53e04c (patch)
tree6277fb20f0e12264d5c614e154b4571c015e9986 /ansible/scripts
parente0d72ff69004820c4dc5ce9f8366510e098d0b6b (diff)
downloadansible-active-directory-range-bc8a03d6f0a00ee8fb8052052efb3d126c53e04c.tar.gz
ansible-active-directory-range-bc8a03d6f0a00ee8fb8052052efb3d126c53e04c.zip
reversed mssql link
Diffstat (limited to 'ansible/scripts')
-rw-r--r--ansible/scripts/setup-mssql-link.ps16
1 files changed, 3 insertions, 3 deletions
diff --git a/ansible/scripts/setup-mssql-link.ps1 b/ansible/scripts/setup-mssql-link.ps1
index 614bd67..46aab23 100644
--- a/ansible/scripts/setup-mssql-link.ps1
+++ b/ansible/scripts/setup-mssql-link.ps1
@@ -1,6 +1,6 @@
param
(
- [string]$LinkServer = "websql01"
+ [string]$LinkServer = "mssql02"
)
$scriptName = $MyInvocation.MyCommand.Name
$logFile = "C:\Logs\${scriptName}_log.txt"
@@ -11,8 +11,8 @@ try {
SqlCmd -E -Q "EXEC master.dbo.sp_serveroption @server=N'$LinkServer', @optname=N'rpc', @optvalue=N'true'"
SqlCmd -E -Q "EXEC master.dbo.sp_serveroption @server=N'$LinkServer', @optname=N'rpc out', @optvalue=N'true'"
SqlCmd -E -Q "EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'$LinkServer', @locallogin = NULL , @useself = N'True'"
- Write-Host "[inf] Linked $LinkServer to mssql02"
+ Write-Host "[inf] Linked $LinkServer to websql01"
} catch {
- Write-Host "[err] Failed to link $LinkServer to mssql02"
+ Write-Host "[err] Failed to link $LinkServer to websql01"
}
Stop-Transcript