diff options
| author | heqnx <root@heqnx.com> | 2025-07-15 22:59:23 +0300 |
|---|---|---|
| committer | heqnx <root@heqnx.com> | 2025-07-15 22:59:23 +0300 |
| commit | bc8a03d6f0a00ee8fb8052052efb3d126c53e04c (patch) | |
| tree | 6277fb20f0e12264d5c614e154b4571c015e9986 /ansible/scripts/setup-mssql-link.ps1 | |
| parent | e0d72ff69004820c4dc5ce9f8366510e098d0b6b (diff) | |
| download | ansible-active-directory-range-bc8a03d6f0a00ee8fb8052052efb3d126c53e04c.tar.gz ansible-active-directory-range-bc8a03d6f0a00ee8fb8052052efb3d126c53e04c.zip | |
reversed mssql link
Diffstat (limited to 'ansible/scripts/setup-mssql-link.ps1')
| -rw-r--r-- | ansible/scripts/setup-mssql-link.ps1 | 6 |
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 |