From bc8a03d6f0a00ee8fb8052052efb3d126c53e04c Mon Sep 17 00:00:00 2001 From: heqnx Date: Tue, 15 Jul 2025 22:59:23 +0300 Subject: reversed mssql link --- ansible/scripts/setup-mssql-link.ps1 | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'ansible/scripts/setup-mssql-link.ps1') 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 -- cgit v1.2.3