SQL Server 2000 databases can be configured to use Windows Authentication for a trusted connection, rather than SQL Server Authentication. This configuration allows users to log into Windows or Proficy Portal, and the credentials will carry down to the SQL server.
Before starting, make sure that the SQL data source is configured to use the jTDS driver. For more information, see Adding an SQL Data Source.
In the Proficy Portal client application, click the Administration button on the main toolbar. The Administration application appears.
Click the Roles & Users button.
Select the role or user you want to configure the data source for.
Select the Data Sources tab.
From the list of data sources, select the SQL data source.
Select the Use the interactive user's credentials option.
Click the Apply button for your changes to take effect.