Changing the Across Database User

During the configuration of the Across Language Server, an SQL user with the database role db_owner is created automatically. This user is responsible for the authentication and authorization between the Across components and the Across databases. If you do not enter anything else, the user will get the name across and an auto-generated password.

If necessary, you can change this login information after the configuration. However, it is not sufficient to change the SQL user on the database server. For the Across components to continue to be able to communicate with the Across databases, the user's login information must be made known to the Across components.

Depending on whether you merely want to change the password or create an entirely new user, these steps differ slightly.

Changing the Password of the Database User across

0. Proceed as follows to change the password:
1. Stop all Across services.
2. Open a utility such as the MS SQL Server Management Studio and change the password of the user across.
3. Start the Across Setup Configuration tool on the Across Server (application server).
4. Click RECONFIGURE.
5. Follow the instructions of the tool until the Database Configuration page.
6. On the SQL Account for Across Services tab, enter the password you just set.
7. Click Next and finish the remaining steps of the tool.
8. If you use further application servers (crossTank, crossAPI, crossVPN Proxy Server, etc.):
   1. Start the Across Setup Configuration tool on the respective application server.
   2. Enter the new login information of the database user on the page Connection to the Across Server.
   3. Click Next and finish the remaining steps of the tool.
9. Check your Across environment for operability.

Creating a New Database User

0. Proceed as follows to create a new user:
1. Start the Across Setup Configuration tool on the Across Server (application server).
2. Click RECONFIGURE and confirm that all Across services are to be stopped.
3. Follow the instructions of the tool until the Database Configuration page.
4. On the SQL Account for Across Services tab, enter a new user name and a new password in order to create a new SQL user.
   Attention

   Subsequently, you need to manually remove the user across from the SQL instance. The tool will not remove this user.
5. Click Next and finish the remaining steps of the tool.
6. If you use further application servers (crossTank, crossAPI, crossVPN Proxy Server, etc.):
   1. Start the Across Setup Configuration tool on the respective application server.
   2. Enter the new login information of the database user on the page Connection to the Across Server.
   3. Click Next and finish the remaining steps of the tool.
7. Check your Across environment for operability.