STRLCPY/GOAD

■ ■ ■ ■ ■ ■

ad/sevenkingdoms.local/data/config.json

		skipped 78 lines
79	79		"NORTH\\arya.stark" : "dbo"
80	80		},
81	81		"linked_servers": {
82		-	"braavos.essos.local" : {
	82	+	"BRAAVOS" : {
	83	+	"data_src": "braavos.essos.local",
83	84		"users_mapping": [
84	85		{"local_login": "NORTH\\jon.snow","remote_login": "sa", "remote_password": "sa_P@ssw0rd!Ess0s"}
85	86		]
		skipped 41 lines
127	128		},
128	129		"executeasuser" : {},
129	130		"linked_servers": {
130		-	"castelblack.north.sevenkingdoms.local" : {
	131	+	"CASTELBLACK" : {
	132	+	"data_src": "castelblack.north.sevenkingdoms.local",
131	133		"users_mapping": [
132	134		{"local_login": "north\\jorah.mormont","remote_login": "sa", "remote_password": "Sup1_sa_P@ssw0rd!"}
133	135		]
		skipped 402 lines

■ ■ ■ ■ ■ ■

ansible/roles/mssql_link/tasks/main.yml

1	1		- name: Create SQL Linked server and enable RPC
2	2		win_shell: \|
3		-	SqlCmd -E -Q "EXEC master.dbo.sp_addlinkedserver @server = N'{{item.key}}', @srvproduct=N'', @provider=N'SQLOLEDB'"
	3	+	SqlCmd -E -Q "EXEC master.dbo.sp_addlinkedserver @server = N'{{item.key}}', @srvproduct=N'', @provider=N'SQLOLEDB', @datasrc=N'{{item.value.data_src}}'"
4	4		SqlCmd -E -Q "EXEC master.dbo.sp_serveroption @server=N'{{item.key}}', @optname=N'rpc', @optvalue=N'true'"
5	5		SqlCmd -E -Q "EXEC master.dbo.sp_serveroption @server=N'{{item.key}}', @optname=N'rpc out', @optvalue=N'true'"
6	6		become: yes
		skipped 33 lines