From 6ec2eb61a02f9e55ef5b8d22a5ca61ca53ca05e7 Mon Sep 17 00:00:00 2001 From: heqnx Date: Fri, 11 Jul 2025 21:55:20 +0300 Subject: added initial setup for domain controller --- ansible/scripts/setup-mssql-link.ps1 | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 ansible/scripts/setup-mssql-link.ps1 (limited to 'ansible/scripts/setup-mssql-link.ps1') diff --git a/ansible/scripts/setup-mssql-link.ps1 b/ansible/scripts/setup-mssql-link.ps1 new file mode 100644 index 0000000..8f51058 --- /dev/null +++ b/ansible/scripts/setup-mssql-link.ps1 @@ -0,0 +1,18 @@ +param +( + [string]$LinkServer = "mssql01" +) +$scriptName = $MyInvocation.MyCommand.Name +$logFile = "C:\Logs\${scriptName}_log.txt" +Start-Transcript -Path $logFile -Append + +try { + SqlCmd -E -Q "EXEC master.dbo.sp_addlinkedserver @server = N'$LinkServer', @srvproduct=N'', @provider=N'SQLOLEDB', @datasrc=N'$LinkServer'" + 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 "[INFO] Linked $LinkServer to mssql02" +} catch { + Write-Host "[ERR] Failed to link $LinkServer to mssql02" +} +Stop-Transcript \ No newline at end of file -- cgit v1.2.3