Changes for page Connectionstring anpassen

Last modified by Sabrina V. on 2026/10/08 11:47

Manage
- Copy
Actions
- Export
- Print Preview
Viewers
- Source
- Children
- Content

From version 1.1

edited by jklein
on 2024/08/13 08:28

Change comment: Imported from XAR

To version 2.1

edited by Sabrina V.
on 2026/10/08 11:47

Change comment: There is no comment for this version

Raw
Rendered

Summary

Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

@@ -1,1 +1,1 @@
--XWiki.jklein
++XWiki.SV

Content

@@ -6,11 +6,11 @@
  = General information about the connection string =
--The ACMP server uses the connection string to connect to the SQL Server. It is created and filled by the ACMP setup during installation. After installation, the connection string can also be adjusted manually.
++The acmp server uses the connection string to connect to the SQL Server. It is created and filled by the acmp setup during installation. After installation, the connection string can also be adjusted manually.
  The connection string contains various attributes, such as the provider or the data sources used, but also security information of the respective user, such as the user name or the password.
--The connection string is generated by ACMP and stored in the installation directory. It is a persistent file that can be accessed by the ACMP Server at any time. The file always has the same attributes. Some values and properties can be changed by a free entry, for others only the two values //True// and //False// are available. The connection string is implicitly filled with the data you enter during installation (e.g. database used, user name, password, etc.). To do this, the information you enter in the installation wizard is transparently transferred to the file and stored there. The connection string can also be used to establish an encrypted connection between the SQL Server and the ACMP Server.
++The connection string is generated by acmp and stored in the installation directory. It is a persistent file that can be accessed by the acmp Server at any time. The file always has the same attributes. Some values and properties can be changed by a free entry, for others only the two values //True// and //False// are available. The connection string is implicitly filled with the data you enter during installation (e.g. database used, user name, password, etc.). To do this, the information you enter in the installation wizard is transparently transferred to the file and stored there. The connection string can also be used to establish an encrypted connection between the SQL Server and the acmp Server.
  {{figure}}
  (% style="text-align:center" %)
@@ -25,16 +25,16 @@
  * - Migration of another SQL Server (e.g. from MS SQL Server 2012 to 2019).
  * - Relocation of the SQL Server to another host
--* - Change of user credentials (the ACMP database login is changed)
++* - Change of user credentials (the acmp database login is changed)
  * - Migration of a database
  * Data transfer to be encrypted afterwards
  == **Invoking the //db.~~co// and //db.con// files** ==
--The files to customise the connection string are located in the server directory of the ACMP Server (e.g. C:\Program Files (x86)\Aagon\ACMP Server). The files you need to customise the connection string are the //db.~~co// and //db.con// files.
--The aim is to change the //db.con// file because this is used by the ACMP Server to connect to the SQL Server. This file is normally encrypted if the ACMP Server has been successfully started at least once. To be able to modify and customise the data in a meaningful way, you need the structure and the readable content of the connection string. This data can be found in the //db.~~co// file, as the plain text can be extracted from it.
++The files to customise the connection string are located in the server directory of the acmp Server (e.g. C:\Program Files (x86)\Aagon\ACMP Server). The files you need to customise the connection string are the //db.~~co// and //db.con// files.
++The aim is to change the //db.con// file because this is used by the acmp Server to connect to the SQL Server. This file is normally encrypted if the acmp Server has been successfully started at least once. To be able to modify and customise the data in a meaningful way, you need the structure and the readable content of the connection string. This data can be found in the //db.~~co// file, as the plain text can be extracted from it.
--Navigate to the server directory of the ACMP Server and open the file //db.~~co// with a text editor of your choice (e.g. Notepad++). A connection string with various attributes will open. In the following figure, for example, these are attributes such as the provider, the user ID or the SQL Server instance.
++Navigate to the server directory of the acmp Server and open the file //db.~~co// with a text editor of your choice (e.g. Notepad++). A connection string with various attributes will open. In the following figure, for example, these are attributes such as the provider, the user ID or the SQL Server instance.
  {{figure}}
  (% style="text-align:center" %)
@@ -46,7 +46,7 @@
  {{/figure}}
  {{aagon.infobox}}
--ACMP does not use the //db.~~co// file directly to read information. Rather, it is intended as a template in which you can enter your values and transfer them to the //db.con// file.
++acmp does not use the //db.~~co// file directly to read information. Rather, it is intended as a template in which you can enter your values and transfer them to the //db.con// file.
  {{/aagon.infobox}}
  When you then open the other file, the //db.con// file, you will see an encrypted content consisting of a long string of numbers and letters. Because of the encryption, you will no longer be able to see the position of the //password// attribute, for example.
@@ -61,7 +61,7 @@
  {{/figure}}
  {{aagon.infobox}}
--If the correct values are entered for the five attributes "Provider", "Password", "User ID", "Data Source" and "Initial Catalog", the encryption of the //db.con// file is automatic. After the ACMP Server has successfully connected to the SQL Server, the //db.con// file is encrypted so that the connection string is no longer in clear text in the file, but can only be decrypted by the ACMP Server.
++If the correct values are entered for the five attributes "Provider", "Password", "User ID", "Data Source" and "Initial Catalog", the encryption of the //db.con// file is automatic. After the acmp Server has successfully connected to the SQL Server, the //db.con// file is encrypted so that the connection string is no longer in clear text in the file, but can only be decrypted by the acmp Server.
  {{/aagon.infobox}}
  == C**ustomising attributes in the connection string** ==
@@ -70,7 +70,7 @@
  First, go back to the //db.~~co// file where the readable attributes are stored. Copy the contents of this file and switch back to the //db.con// file. Now find the attributes you want to change or add to the existing attributes.
  {{aagon.warnungsbox}}
--It is important that you enter the values correctly. Errors or typing mistakes can result in the ACMP Server not being able to connect to the SQL Server and therefore no login is possible.
++It is important that you enter the values correctly. Errors or typing mistakes can result in the acmp Server not being able to connect to the SQL Server and therefore no login is possible.
  {{/aagon.warnungsbox}}
   Nachfolgend einige Erklärungen zu den Werten:
@@ -78,16 +78,16 @@
  |(% style="width:221px" %)**Attributes**|(% style="width:1142px" %)**Description**
  |(% style="width:221px" %)Provider=SQLNCLI11.1|(% style="width:1142px" %)The provider used here is the Microsoft SQL Server Native Client, version 11.1. The access library used to access the SQL Server should not be changed.
  |(% style="width:221px" %)Password=(clear)|(% style="width:1142px" %)(((
--The password refers to the user ID/user for the SQL Server used within the connection string. If an incorrect password is entered, an error message is generated when the ACMP Server is started. In addition you will find an entry in StartUpError.txt (C:\Program Files (x86)\Aagon\ACMP Server) why ACMP could not be started successfully.
++The password refers to the user ID/user for the SQL Server used within the connection string. If an incorrect password is entered, an error message is generated when the acmp Server is started. In addition you will find an entry in StartUpError.txt (C:\Program Files (x86)\Aagon\ACMP Server) why acmp could not be started successfully.
  Enter the required password here.
  )))
  |(% style="width:221px" %)Persist Security Info=True|(% style="width:1142px" %)(((
--A value of True means that security information (e.g. user ID or password) can be retrieved. If the value is set to False, problems and error messages may occur when connecting to the ACMP Server.
++A value of True means that security information (e.g. user ID or password) can be retrieved. If the value is set to False, problems and error messages may occur when connecting to the acmp Server.
  Possible values that can be entered True or False
  )))
--|(% style="width:221px" %)User ID=ACMPDBUser|(% style="width:1142px" %)The User ID information refers to the SQL login with which the ACMP logs on to the SQL Server. A successful login is a prerequisite for starting the ACMP Server.
++|(% style="width:221px" %)User ID=ACMPDBUser|(% style="width:1142px" %)The User ID information refers to the SQL login with which the acmp logs on to the SQL Server. A successful login is a prerequisite for starting the acmp Server.
  |(% style="width:221px" %)Initial Catalog=ACMP|(% style="width:1142px" %)The entered User ID (SQL Login) should have DB Owner rights of the database. This is the database name.
  |(% style="width:221px" %)(((
  Data Source=ServerNameEnter.aagon.local\SQLEXPRESS
@@ -127,13 +127,13 @@
  Possible values that can be entered: True or False
  )))
--For the changes to be applied, you must save and close the file. If you are still running ACMP Console, exit the application.
++For the changes to be applied, you must save and close the file. If you are still running acmp Console, exit the application.
  {{aagon.infobox}}
--If you correct or change values in the //db.con// file, it is a good idea to close the ACMP Console, otherwise you may lose data. Unsaved content may be lost. If you do not close the application during your work, you will get a message that the current session has expired and needs to be restarted.
++If you correct or change values in the //db.con// file, it is a good idea to close the acmp Console, otherwise you may lose data. Unsaved content may be lost. If you do not close the application during your work, you will get a message that the current session has expired and needs to be restarted.
  {{/aagon.infobox}}
--Now open the ACMP Server via the service administration "Services" and close the server with the same name. Wait a moment until the service is closed on the local computer and then restart it. The adjusted conditions will be loaded and a newly encrypted db.con file will be displayed.
++Now open the acmp Server via the service administration "Services" and close the server with the same name. Wait a moment until the service is closed on the local computer and then restart it. The adjusted conditions will be loaded and a newly encrypted db.con file will be displayed.
  {{aagon.infobox}}
   You can use the //StartUpError.txt// file to check that the server has been successfully restarted.
@@ -144,20 +144,20 @@
  [[image:Diensteverwaltung ACMP Server beenden.png]]
  {{figureCaption}}
--Exit Service Management ACMP Server
++Exit Service Management acmp Server
  {{/figureCaption}}
  {{/figure}}
--The updated //db.con// file will have a different sequence of numbers and letters after the ACMP server has been restarted, due to the re-entry of your data.
++The updated //db.con// file will have a different sequence of numbers and letters after the acmp server has been restarted, due to the re-entry of your data.
  = Encrypt connection string =
--The connection string is automatically encrypted if you have entered the values of the attributes "Provider", "Password", "User ID", "Data Source" and "Initial Catalog" correctly. You must enter these five attributes correctly to establish a connection between the ACMP Server and SQL Server. If you enter an incorrect value in the //db.con// file, the file can be saved but no connection can be established. Therefore, always check your entries to ensure a successful connection between the two servers.
++The connection string is automatically encrypted if you have entered the values of the attributes "Provider", "Password", "User ID", "Data Source" and "Initial Catalog" correctly. You must enter these five attributes correctly to establish a connection between the acmp Server and SQL Server. If you enter an incorrect value in the //db.con// file, the file can be saved but no connection can be established. Therefore, always check your entries to ensure a successful connection between the two servers.
  Encryption of the connection string is used to prevent other users from reading the authentication credentials.
--= **Establishing an encrypted connection between ACMP Server and SQL Server** =
++= **Establishing an encrypted connection between acmp Server and SQL Server** =
--The user credentials passed can also be encrypted in the connection string. To do this, when editing the attributes, set the //Use encryption for data// value to //True// to encrypt the transmission. This will encrypt the data so that it can only be read by the ACMP Server. In addition to the attribute mentioned here, you will need to customise the other values. Update and save the //db.con //file so that it can be read by the ACMP Server when it is restarted.
++The user credentials passed can also be encrypted in the connection string. To do this, when editing the attributes, set the //Use encryption for data// value to //True// to encrypt the transmission. This will encrypt the data so that it can only be read by the acmp Server. In addition to the attribute mentioned here, you will need to customise the other values. Update and save the //db.con //file so that it can be read by the acmp Server when it is restarted.
  See also: [[Enabling encryption>>https://docs.microsoft.com/de-de/dotnet/framework/data/adonet/connection-string-syntax#sqlclient-connection-strings]]