diff options
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 |