summaryrefslogtreecommitdiff
path: root/ansible/roles
diff options
context:
space:
mode:
authorheqnx <root@heqnx.com>2025-07-16 23:01:07 +0300
committerheqnx <root@heqnx.com>2025-07-16 23:01:07 +0300
commitcba768331d3acb630d187c2259b83d98d26846c4 (patch)
treee45fc9e6987cd14ed90cf10ddd1ef2270d18cb55 /ansible/roles
parent8dc5629bf672e882372fb9f83520c351debbfb37 (diff)
downloadansible-active-directory-range-cba768331d3acb630d187c2259b83d98d26846c4.tar.gz
ansible-active-directory-range-cba768331d3acb630d187c2259b83d98d26846c4.zip
combining mssql02 with adcs01, fixed esc installer script
Diffstat (limited to 'ansible/roles')
-rw-r--r--ansible/roles/adcs01/tasks/init.yaml7
-rw-r--r--ansible/roles/adcs01/tasks/main.yaml10
-rw-r--r--ansible/roles/adcs01/tasks/setup_mssql.yaml8
-rw-r--r--ansible/roles/websql01/tasks/setup_mssql_link.yaml2
4 files changed, 25 insertions, 2 deletions
diff --git a/ansible/roles/adcs01/tasks/init.yaml b/ansible/roles/adcs01/tasks/init.yaml
index 418bb5d..e329b0c 100644
--- a/ansible/roles/adcs01/tasks/init.yaml
+++ b/ansible/roles/adcs01/tasks/init.yaml
@@ -10,9 +10,14 @@
- name: upload ADCSTemplate module
ansible.builtin.copy:
src: ../../../files/adcs/ADCSTemplate
- dest: C:\Program Files\WindowsPowerShell\Modules\ADCSTemplate
+ dest: C:\Program Files\WindowsPowerShell\Modules
- name: upload adcs templates
ansible.builtin.copy:
src: ../../../files/adcs/templates
dest: C:\setup
+
+- name: copy mssql installer
+ ansible.builtin.copy:
+ src: files/SQL2019-SSEI-Expr.exe
+ dest: C:\setup\SQL2019-SSEI-Expr.exe
diff --git a/ansible/roles/adcs01/tasks/main.yaml b/ansible/roles/adcs01/tasks/main.yaml
index e3f8923..4e44dc9 100644
--- a/ansible/roles/adcs01/tasks/main.yaml
+++ b/ansible/roles/adcs01/tasks/main.yaml
@@ -33,6 +33,16 @@
- name: reboot after adcs esc setup
import_tasks: reboot.yaml
+- name: execute setup-mssql.ps1
+ import_tasks: setup_mssql.yaml
+
+- name: reboot after mssql setup
+ import_tasks: reboot.yaml
+
+- name: pause 5 minutes for mssql setup to complete
+ pause:
+ minutes: 5
+
- name: execute install-software.ps1
import_tasks: install_software.yaml
diff --git a/ansible/roles/adcs01/tasks/setup_mssql.yaml b/ansible/roles/adcs01/tasks/setup_mssql.yaml
new file mode 100644
index 0000000..4ed0a86
--- /dev/null
+++ b/ansible/roles/adcs01/tasks/setup_mssql.yaml
@@ -0,0 +1,8 @@
+- name: execute setup-mssql.ps1
+ ansible.windows.win_powershell:
+ script: C:\scripts\setup-mssql.ps1
+ parameters:
+ DomainName: "{{ main_domain_name }}"
+ IISSvcUsername: svc_iis01
+ SQLSvcUsername: svc_mssql02
+ SvcPassword: "{{ default_win_svc_password }}"
diff --git a/ansible/roles/websql01/tasks/setup_mssql_link.yaml b/ansible/roles/websql01/tasks/setup_mssql_link.yaml
index 1227d62..4320889 100644
--- a/ansible/roles/websql01/tasks/setup_mssql_link.yaml
+++ b/ansible/roles/websql01/tasks/setup_mssql_link.yaml
@@ -2,4 +2,4 @@
ansible.windows.win_powershell:
script: C:\scripts\setup-mssql-link.ps1
parameters:
- LinkServer: mssql02
+ LinkServer: adcs01