Documentation
Back to website >

Glossary [A]

AuftragIn EDIFACT, the order corresponds to the message type ORDERS.
AuftragsbestätigungIn EDIFACT, the order confirmation corresponds to the message type ORDRSP.
Authentifizierung-Modus (MSSQL)

Authentication

The Microsoft® SQL Server offers a very comprehensive system for controlling authorizations. You can store which users can access which tables (addresses, invoices, etc.) or make changes to them. It is even possible to block individual columns (e.g. purchase prices) and much more.

For such a system to function reliably, however, the SQL server must be able to establish the identity of a user without any doubt. This process is called authentication. In real life, for example, you would have another person present your identity card to you and then compare the photograph. In the computer world it is common to "identify yourself" with a user name and a password. But who checks whether the password is correct and authenticates the user? SQL Server offers two different authentication modes. On the one hand, SQL authentication, where the SQL server checks the passwords itself, and on the other hand, Windows authentication, where the Windows user account is used.

Windows authentication

This authentication represents the highest security level and also uses the Windows NT user accounts for logging on to Microsoft® SQL Server. For this it is necessary to use Windows® 2008 R2 or Windows® 7 or higher.

The administrator of a domain is also automatically an administrator on an SQL server when logging on using Windows authentication. In this case, you do not need to enter a user name and password. All "normal" Windows user accounts must first be assigned via SQL Managemantstudio if they are to log on to the SQL server; after that, these users no longer need to enter passwords for the SQL logon either.

The advantage of Windows authentication is that you can use the same UDL file for database access for all users on the network, since the normal Windows user account is always forwarded to the SQL server. Another advantage is that the account can be transferred to the SQL server much more securely.

The disadvantage is that you can no longer access the SQL server over the Internet via the standard port 1433. Authentication requires additional ports that may need to be enabled in the firewall, which network administrators are reluctant to do. For this reason, external access is often performed via the terminal server or VPN.

SQL authentication

SQL authentication is not enabled by default when an SQL server is installed. However, if the Microsoft® SQL Server Express is installed via the EULANDA® installation, this mode is automatically forced. In this way it is possible to install SQL users, database users and EULANDA® roles via simple scripts when creating a client.

During SQL authentication, user name and password are transmitted unencrypted over the network. User name and password are also stored unencrypted in the UDL file that establishes the database connection. However, you can remove the password from the UDL file so that the password is requested every time EULANDA® is started.

Changing the authentication mode

You can only change the authentication mode using the SQL Management Studio.

AutoresponderA autoresponder automatically responds to a request. Autoresponders are available for a wide variety of communication systems. They allow the easy testing of a functioning communication. If you receive an answer, your own sending as well as your own reception will be successful.
A autoresponder for emails is for example "echo@univie.ac.at". If an e-mail is sent to this address, the autoresponder responds very promptly to your sender's address.
To that end, Deutsche Telekom provides an autoresponder for the X400 protocol. If you send a message to the X400th address "S=AUTOANSWER; O=DTAG; A=viaT; C=DE; ", you will receive a prompt reply to your sender address. This can be used, for example, to test the communication of Fileworks.
APIApplication Programming Interface (API) refers to all of the interfaces that allow users, software vendors, and third parties to access the functions of an application program to enhance the functionality of the original product. The EULANDA® ERP offers several levels of access:
Extensions on SQL Server level via the SQL-API. Extensions at program level on the user side via the iScript API and the Registry API.
AS2AS2 is a transmission protocol based on the http protocol. This is extended in such a way that a secure and encrypted connection is established via certificates. In addition, data can be transferred synchronously and asynchronously. The partner will receive a response as to whether the file has arrived without errors. In the EDIFACT area it is the most flexible protocol. It is only a little more expensive in the initial purchase, since a PC and the AS2 server software are needed. However, there are no running connection costs as with the X400 protocol.
ASCIIA text character representing the normal characters 0-9, A-Z etc. It uses exactly one byte per character, so that there are 256 different characters altogether. Since there are different special characters in Europe alone, one has kept a range of characters variable. It refers to certain character encodings. Only the first 128 characters, the lower half are identical for all character encodings.