The Database Connection String Editor

NOTE: Not applicable to DocLink Cloud.

 

DocLink creates a SQL user account that is utilized in the connection string to connect to the DocLink database.

To facilitate changing this connection string, the DocLink Application Components and Remote Server installations include an executable called DB Password Administrator (a.k.a. - DBPwdTool.exe). This file is placed in the %Program Files (x86)%\Altec\DocLink4x directory and is advertised through a desktop shortcut.

The editor will allow you to:

1. Change the password for the default SQL login.
2. Change the login to utilize a different SQL account (which will require changing permissions on tables, views and stored procedures).
3. Change the connection string to utilize Integrated Security (also known as Trusted Security).

If you connect to multiple databases from the same DocLink application server, the connection string must be compatible with each database. This can be accomplished by ensuring that the same UserID and Password is utilized in each of the databases.

 

Using the Editor

1. Install the DocLink database.
2. Install the DocLink Application Components.
3. If you want to change the password for the default SQL login, open the SQL Server Enterprise Manager and change the password for the doclink20 user.
   1. Open the Security folder and select Logins.
   2. Right-click on the doclink20 user and select Properties.
   3. Enter the new Password.
4. Right-click and run the DBPwdTool.exe, as Administrator, on the DocLink application server. The default location is %Program Files (x86)%\Altec\DocLink4x.
5. Make the necessary changes to the connection string.  If you are simply changing the password for the default SQL login, change the password in the connection string to match the password created for the doclink20 user.
6. Click Test.... You should get a message in the status bar that the DocLink database was found.
7. Click OK to exit the editor and update the database setting.
8. Restart all DocLink services.