![Exported image](Exported%20image%2020250808202410-0.png) ![Exported image](Exported%20image%2020250808202414-1.png) ![Exported image](Exported%20image%2020250808202414-2.png) ![Exported image](Exported%20image%2020250808202415-3.png) ![Exported image](Exported%20image%2020250808202416-4.png) ![Exported image](Exported%20image%2020250808202416-5.png) ![Exported image](Exported%20image%2020250808202417-6.png) ![Exported image](Exported%20image%2020250808202418-7.png) ![Exported image](Exported%20image%2020250808202421-8.png) ![Exported image](Exported%20image%2020250808202422-9.png)

**tasb30a-v0048.ad.cbp.dhs.gov \WSG1,64078 - NEW ADEX in EQUINIX**
 
**Setup IIS**  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-WebServerRole  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-WebServer  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-CommonHttpFeatures  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-HttpErrors  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-HttpRedirect  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-ApplicationDevelopment  
Enable-WindowsOptionalFeature -online -FeatureName NetFx4Extended-ASPNET45  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-NetFxExtensibility45  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-HealthAndDiagnostics  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-HttpLogging  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-LoggingLibraries  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-RequestMonitor  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-HttpTracing  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-Security  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-RequestFiltering  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-Performance  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-WebServerManagementTools  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-IIS6ManagementCompatibility  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-Metabase  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-ManagementConsole  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-BasicAuthentication  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-WindowsAuthentication  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-StaticContent  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-DefaultDocument  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-WebSockets  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-ApplicationInit  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-ISAPIExtensions  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-ISAPIFilter  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-HttpCompressionStatic  
Enable-WindowsOptionalFeature -Online -FeatureName IIS-ASPNET45

![Exported image](Exported%20image%2020250808202423-10.png)  
![Exported image](Exported%20image%2020250808202424-11.png)  

**Copy ADEX web files to d:\data\ADEX**  
**Create Data source**

- ==Edit the DSN and select== _Show Advanced Settings_ ==\>== _Connection String_==. Then enter== ==AuthenticationMethod=Type2== ==and save.==
- ==Leave the== ==username== ==and== ==password== ==fields blank== \> From \<[https://stackoverflow.com/questions/43612373/how-do-i-setup-a-coldfusion-datasource-properly-for-a-sql-server-database-throug](https://stackoverflow.com/questions/43612373/how-do-i-setup-a-coldfusion-datasource-properly-for-a-sql-server-database-throug)\>   
Data & Services \> Datasource

|   |   |   |   |   |   |   |
|---|---|---|---|---|---|---|
|Type|CF Data Source Name|Database|Server|Port|User Name|Password|
|**Microsoft SQL Server :**|ADEX_DSN|ADEX|tasb30a-v0048\wsg1||||
|**Microsoft SQL Server :**|ADEX_Web|ADEX|tnwg01a-p0657\wsg1||||
|**Microsoft SQL Server :**|DMZ_Provisioning|ADEX|TNWG01A-V1983.DMZ.CBP.DHS.GOV|64088|DMZ\SVC-ADEX-Provision||
|**Microsoft SQL Server :**|OperationsManager|OperationsManager|tnwg01a-p0664\wsg1||||
|**Microsoft SQL Server :**|OperationsManagerDW|OperationsManagerDW|tnwg01a-p0665\wsg1||||
|**Microsoft SQL Server :**|PowerShell|Master|tnwg01a-p0657\wsg1||||
|**Microsoft SQL Server :**|PS|Master|tnwg01a-p0657\wsg1||||
|**Microsoft SQL Server :**|SAT_Provisioning|Orchestrator|tnwg01a-v1322.sat.cbp.dhs.gov\wsg1||SVC-ADEX-Provisioning||
|**Microsoft SQL Server :**|SCCM-CAS|CM_WSG|TNWG01A-V0980\WSG1||||
|**Microsoft SQL Server :**|SCCM-P01-SUSDB|SUSDB|tnwg01a-v0980\wsg1||||
|**Microsoft SQL Server :**|**DMGCONFIGMGR**|CM_SM2|TNWG01A-P0869\DMGCONFIGMGR||||
    ![Exported image](Exported%20image%2020250808202424-12.png)  

![[tasb30a-v0048serversettings.pdf]]

![[tasb30a-v0048serversettings 1.pdf]]

SQL Scheduled Jobs  
Process WSG SCOM Config Version 1/29/2021  
Owner: AD\SVC-ColdFusion-App  
D:\Data\ProcessSCOMconfig\ProcessCBP_Custom_Configuration-ODBC-V01-29-2021.exe

![Exported image](Exported%20image%2020250808202429-15.png)  
![Exported image](Exported%20image%2020250808202430-16.png)  

D:\Data\ProcessSCOMconfig\ProcessAlerts-ODBC_V01-29-2021.exe
 ![Exported image](Exported%20image%2020250808202431-17.png)  
![Exported image](Exported%20image%2020250808202431-18.png)  
![Exported image](Exported%20image%2020250808202432-19.png)  
![Exported image](Exported%20image%2020250808202433-20.png)     
![Exported image](Exported%20image%2020250808202433-21.png)  

![Exported image](Exported%20image%2020250808202426-14.png)
          
\> From \<[https://stackoverflow.com/questions/43612373/how-do-i-setup-a-coldfusion-datasource-properly-for-a-sql-server-database-throug](https://stackoverflow.com/questions/43612373/how-do-i-setup-a-coldfusion-datasource-properly-for-a-sql-server-database-throug)\>         
Run Web Server Configuration Tool ==(creates Virtual Directories in Yellow)==
 
|   |   |   |
|---|---|---|
|WSG|D:\Data\ADEX\Utilities|Pass-through|
|MyLogs|[\\tnwg01a-v3824\logs](file:///\\tnwg01a-v3824\logs)|ad\SVC-ADEXLogs|
|==cf_scripts==|==D:\ColdFusion2018\cfusion\wwwroot\cf_scripts==|==Pass-through==|
|==Jakarta==|==D:\ColdFusion2018\config\wsconfig\1==|==Pass-through==|

**Add Virtual Directories**  
    ![Exported image](Exported%20image%2020250808202425-13.png)

**Connection String: AuthenticationMethod=Type2**