Connection
This section allows you to make a connection with the SQL server.
- Server: Indicate the server to which you would like to connect. It is recommended to use the ServerName/Instance - format (e.g. MainSqlServer\CSI).
- Login: Enter the username to be used for connecting.
- Password: Fill in the username's password.
After completing these settings, click the Connect button. When successfully connected, the status indicator (at the right of the 'Server'-field) will turn green.
Advanced: This functionality allows you to read/modify the Application database user which is stored in the CSI Accelerator's Application configuration file.
The upper area indicates the directory where the Application configuration file is stored.
Clicking the Read button will extract the Application database user from this file (which will then be displayed at the lower area).
You can modify Login and password in the lower area. Click the Save button to write this information to the Application configuration file.
How to change the password of CSI dbAdmin, or a custom database user.
- Open CSI Accelerator and select SQL Xchange from the File menu. (No connection is needed).
- Once in SQL Xchange, connect to the server.
- Go to the Extra menu.
- Click Delete SQL user.
- Confirm you want to remove CSI dbAdmin from the server. (or your custom user).
- Xchange confirm the user is deleted.
- Return to the Connection pane.
- Click the Advanced button.
- The Change CSI database login form appears, change the password and Apply.
- Return to the Extra pane and clickCreate SQL user.
- Xchange asks confirmation to restore the database user on all CSI databases.
- The password has changed.
How to use a different database user:
- Open SQL Xchange and create a connection to the server.
- Go to Advanced and select the configuration file of CSI Accelerator (CSI Accelerator.exe.config).
- Change the default user from CSI dbAdmin to your custom user and password.
- Save the changes to the configuration file.
- Place this file on every pc in the application folder.
Tip: You can replace this file in the setup (\data folder) and already include the modified file when installing.
Note: If you already have database of CSI Accelerator running on your SQL server you need to "Restore database user" for every database.