Authentication

By default, the security settings of the SQL Server are configured to allow access to the server via an existing Windows user account. To enable the setup of the Across databases during the installation of the Across Server, the so-called mixed mode must be activated in the SQL authentication settings. Additionally, you need to activate the sa user. Both are possible with a user-defined installation of the Microsoft SQL Server (Express). If necessary, you can also activate the mixed mode and the sa user retroactively.

Adjusting the Authentication Mode Retroactively

1. If the SQL Server has already been installed without activating the mixed mode, proceed as follows to adjust the authentication settings:
2. Open the Microsoft SQL Server Management Studio.
3. Connect to the database engine and select the server and, if necessary, the instance.
   Tip

   When installing MS SQL Server Express, an instance called SQLEXPRESS is created by default.
4. Select your SQL Server in the tree view.
5. From the context menu of the server, select Properties.
6. Open the Security section and select the setting SQL Server and Windows Authentication mode under Server authentication.
7. Confirm and close the server properties with OK.

Activating the sa User

1. Proceed as follows:
2. Open the Microsoft SQL Server Management Studio.
3. Connect to the respective instance.
4. Select your SQL Server in the tree view.
5. Under Security > Logins, select the Properties entry from the context menu of the sa user.
6. Under General, check whether a password has been set. If not, set a password.
   Tip

   While configuring Across, you will need the data of the sa user.
7. Check whether the permission to establish a connection to the database engine has been granted in the Status area and set the option Login to Enabled.
8. Confirm and close the login properties with OK.
9. Across can now be installed and configured.