...
Installer le client sql sur chaque brokerhttps://www.microsoft.com/fr-fr/download/details.aspx?id=50402
Tip |
---|
Ayant SQL EXPRESS 22 , il faut le drive OBDC |
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;
|
doc officiel
Code Block |
---|
Driver={ODBC Driver 13 for SQL Server};Server=tcp:<YourHost>,<HostPort>;Database=<DatabaseName>;Uid=<UserID>;Pwd=<Password>;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30; |
Ajouter le serveur sur RDS BROEKR 2 (ajout de serveurs ) sur le 1
...