-
Add ODBC connectors at boot in user data with Powershell pulling in creds from RDS
Pseudo code:
Add-OdbcDsn -Name "WSDQ" -DriverName "SQL Server" -DsnType "System" -SetPropertyValue @("Server=MyServer", "Username=admin", "Password=SuperSecr3t", "Port=1443", "Trusted_Connection=Yes", "Database=database_name") Add-OdbcDsn -Name "HODQ" -DriverName "SQL Server" -DsnType "System" -SetPropertyValue @("Server=MyServer", "Username=admin", "Password=SuperSecr3t", "Port=1433", "Trusted_Connection=Yes", "Database=database_name") Add-OdbcDsn -Name "MDS" -DriverName "SQL Server" -DsnType "System" -SetPropertyValue @("Server=MyServer", "Username=admin", "Password=SuperSecr3t", "Port=1433", "Trusted_Connection=Yes", "Database=database_name")