General Tab of the Weblink Form

Use the General tab to specify the database connection information, such as the server name, user name, and password. You can also disable the process server or the server-to-server synchronization server on a given database.

Contents

Field Description
Current Database Select the database that you want to configure. Use the menu to add or remove databases from this list.
  • New: Click this option to add a database to the list of databases available for configuration.
  • New > Copy Current: Select a database from the list and click Copy Current to copy all information except the name of the database into a new record. After you copy an existing database record, enter a new database name, edit other configuration information, and click Save.
  • Delete: Select a database and click this option to delete the database information from the Weblink utility.
SQL Server Enter the name of the database server, as entered in Microsoft SQL Server.
Database Name Enter the name of the DPS database to which you are connecting.
Description Enter the description for the preceding database, as it will appear on the DPS login screen.
Windows Authentication Specify a Windows User account to use to connect to your SQL Server database. This user account must have been created as a valid user account in SQL Server and must have the appropriate rights to the DPS database. This account also needs to be configured as the Identity of the IIS Application Pool.

If you select this check box, then the SQL Username and SQL Password fields are disabled. The Windows username and password will be used instead.

If you do not select this check box, then you must specify a database username and password to use.

SQL Username Enter the username of the Microsoft SQL Server administrative account who will manage this database. Deltek does not recommend using the sa account. The account that you specify should be configured in its SQL Server Login Properties to use English as the default language.
SQL Password Enter the corresponding password for this user account.
Enable FILESTREAM Select this option to enable the Transactional Document Management (TDM) feature in DPS. TDM provides support for uploading and attaching documents and files to various types of transactions, proposals, expense reports, and more.

When you select this option, the following occurs:

  • The default values display in the FILESTREAM SQL Server and FILESTREAM Database Name fields.
  • If you test the database connection, the necessary TDM tables are reviewed. If these tables are not configured correctly, the Weblink utility asks you if it should create the necessary tables. Click Yes in response to the prompt to create the tables. You can test again to confirm a successful connection.

Additional FILESTREAM configuration information is available in the Deltek DPS On-Premise Administrator Guide.

FILESTREAM SQL Server This field is enabled when the Enable Transactional Document Management option is selected.
  • If the FileStream SQL Server is located on the same SQL Server as the DPS database, the DPS name defaults into this field.
  • If the FileStream SQL Server is not located on the same server as the DPS database, enter the name of the FileStream SQL Server in this field.
FILESTREAM Database Name This field is enabled when the Enable FILESTREAM option is selected. This field displays the name of the FileStream database, which defaults to match the DPS database name with the word Files appended at the end.

You can modify the FileStream database name.

Disable Process Server Select this option if you do not want to use this database for scheduled jobs. If selected, this database is not polled for jobs.

If you change this option (select or clear it), you must restart your process servers for the change to take effect.

Disable Server to Server Synchronization Select this option if you do not want to use the current database for server to server synchronization.
Virtual Dir (optional) Enter a specific virtual directory for this database to appear as an available database only for the specified virtual directory. If you leave this field blank, the database will be accessible by all virtual directories on a given Web server.
SaaS / Hosted Instance Select this check box to enable Deltek, or other vendors who offer hosted instances of DPS, to hide or disable system-level functionality that is not appropriate in a "software as a service" environment.

When you select this check box, the following are no longer available:

  • Location of Reports on Application Server field on the Load Reports tab of the Report Server form in Utilities > Report Administration
  • Report Printers tab of the Report Server form in Utilities > Report Administration
  • Queue Manager form in Utilities > Process Server > Queue Manager
  • Backup Database utility in Utilities > Backup Database
  • Email Server, Port, Username, Password, and Application URL fields on the Communications tab in Settings > General > General Systems
  • Process Servers form in Settings > General > Process Servers in the desktop application
  • Report Printers option on the Functional Areas drop-down list on the Access Rights tab of the Roles form in Settings > Security > Roles
  • Windows Authentication, Domain, and Report Printer on the Users form in Settings > Security > Users
  • Option to select a printer in Default Printer on the Reporting tab of the User Options dialog box in My Preferences on the main toolbar in the DPS desktop application

When you select this check box, the Number of days to retain audit history field, in the Info Center Audit Trail section of the Audit Trail tab in Settings > General > General System, allows a value of only 30 or less.

If you need to restore this functionality, clear the check box.

Save Select this option to save your changes.
New Select this option to create a new database entry.
Delete Select this option to delete the current database entry.
Test Click this option to test the connection for the session state storage database. If the database specified in the Database Setup field does not contain the necessary tables to store the session state, the Weblink utility asks you if it should create the necessary tables when you test the connection. Click Yes in response to this prompt to create the tables and configure the specified database for session state storage.
Change Password Select this option to change your Weblink password.
Delete Old Databases This option is typically used for internal Deltek purposes. Click this button to remove all databases whose version is different from the database version used with DPS (for example, if you are running multiple databases at one site, perhaps in a test scenario). Weblink also removes all databases to which a connection cannot be made.

If there are any pending Weblink changes, a message displays asking if these changes should be saved before removing the old database. After the old and unreachable databases are removed, Weblink is refreshed with the new data.

Automatically check Windows Authentication check box in DPS login screen Select this check box to make the Windows Authentication check box selected by default.
Allow RDL files to be uploaded in Report Administration Select this option to enable the Custom Reports tab in Utilities > Report Administration in the desktop application. The Custom Reports tab is the DPS interface that facilitates the upload of custom RDL files. The Report Administration utility will also be hidden if this check box is not selected.