...
A tester
| Code Block |
|---|
Driver={ODBC Driver 18 for SQL Server};Server=RDS-BROKER2\SQLEXPRESS;Database=RDSHA;Trusted_Connection=Yes;
|
Non tester :
| Code Block |
|---|
Driver={ODBC Driver 18 for SQL Server};Server=RDS-BROKER2\SQLEXPRESS;Database=RDSHA;Trusted_Connection=Yes;TrustServerCertificate=Yes;Encrypt=yes;Connection Timeout=30;
|
...
| Code Block |
|---|
New-NetFirewallRule -DisplayName "SQL Server TCP 1433" -Direction Inbound -Protocol TCP -LocalPort 1433 -Action Allow -Profile Domain,Private
|
| Code Block |
DRIVER=SQL Server Native Client 11.0;SERVER=rds-broker2;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=RDSHA
|
DRIVER=SQL Server Native Client 11.0; SERVER=RDS-SQL; Trusted_Connection=Yes; APP=Remote Desktop Services Connection Broker; DATABASE=RDCB_DB