Skip to Content
Last modified by Sabrina V. on 2026/10/08 11:45
From version 3.1
edited by Sabrina V.
on 2026/10/08 11:45
Change comment: There is no comment for this version
To version 2.1
edited by Sabrina V.
on 2025/11/24 15:00
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Connecting acmp Server to SQL Server
1 +Connecting ACMP Server to SQL Server
Content
... ... @@ -4,9 +4,9 @@
4 4  160
5 5  {{/aagon.priorisierung}}
6 6  
7 -= **Establishing an encrypted connection between acmp Server and SQL Server** =
7 += **Establishing an encrypted connection between ACMP Server and SQL Server** =
8 8  
9 -It is possible to establish an encrypted connection between the acmp Server and the SQL Server. There are two ways to use transport encryption:
9 +It is possible to establish an encrypted connection between the ACMP Server and the SQL Server. There are two ways to use transport encryption:
10 10  
11 11  * Use Transport Layer Security to encrypt the data.
12 12  * Set up an IPSec tunnel in which the communication data is routed.
... ... @@ -57,7 +57,7 @@
57 57  
58 58  **Enabling Read Permissions**
59 59  
60 -If you want to establish an encrypted connection between the acmp Server and the SQL Server, you need to enable read rights for the SQL Server service account.
60 +If you want to establish an encrypted connection between the ACMP Server and the SQL Server, you need to enable read rights for the SQL Server service account.
61 61  To do this, first open the Cert Manager for the local computer (e.g. open mmc.exe and add the snap-in) and then select the //Personal// > //Certificates// //directory//. Locate the certificate for which you want to enable read rights and right-click on it. In the menu that opens, select //All Tasks// > //Manage Private Keys...//.
62 62  
63 63  {{figure}}
... ... @@ -141,9 +141,9 @@
141 141  {{/figureCaption}}
142 142  {{/figure}}
143 143  
144 -== A**djusting the acmp server connection string** ==
144 +== A**djusting the ACMP server connection string** ==
145 145  
146 -You can also customise the connection settings in SQL Server Management Studio using the acmp server connection string:
146 +You can also customise the connection settings in SQL Server Management Studio using the ACMP server connection string:
147 147  \\{{code language="CSV"}}Provider=SQLNCLI11.1;Password=MeinGeheimesPW;Persist Security Info=True;User ID=ACMPDBUser;Initial Catalog=ACMP;
148 148  Data Source=ServerNamenEingeben.aagon.local\SQLEXPRESS;Use Encryption for Data=True;MARS Connection=False;DataTypeCompatibility=80;Trust Server Certificate=False{{/code}}
149 149  
... ... @@ -161,7 +161,7 @@
161 161  
162 162  == IPSec ==
163 163  
164 -Alternatively, if you want to use an IPSec tunnel to establish an encrypted connection between the acmp Server and the SQL Server, read the procedure [[here>>https://stackoverflow.com/questions/36817627/ssl-certificate-missing-from-dropdown-in-sql-server-configuration-manager/36823345#36823345]].
164 +Alternatively, if you want to use an IPSec tunnel to establish an encrypted connection between the ACMP Server and the SQL Server, read the procedure [[here>>https://stackoverflow.com/questions/36817627/ssl-certificate-missing-from-dropdown-in-sql-server-configuration-manager/36823345#36823345]].
165 165  
166 166  === Next recommended actions ===
167 167  
© Aagon GmbH 2026
Besuchen Sie unsere aagon-Community