"(CheckOFSIConnection)40002: 28000 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'User Name'" when logging in to FRx on a Windows 2000 Terminal Server

Entry Type: Informational

Product: Sage MAS 500 ERP

Application: FRx

Version Reported: 6.7.4031 

Subject:

"(CheckOFSIConnection)40002: 28000 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'User Name'" when logging in to FRx on a Windows 2000 Terminal Server

Possible Resolution:

There appears to be a conflict with the Data Source Name MAS 500 being used to authenticate to the Sage MAS 500 database from FRx. To resolve, create a  new DSN name that is not MAS 500 and retest. Perform the following:

1. Expand Company, Information, and System Specific Information. Select Define.
2. Click the System DSN tab. Select the DSN. Select Configure.
3. Verify that the correct server is selected. Click Next.
4. Select either Windows NT Authentication (and enter Login ID and Password) or SQL Server Authentication. Click Next.
5. Select the default MAS 500 Database. Click Next.
6. Click Finish.
7. Click Test Data Source. If configured correctly you see the message "TESTS COMPLETED SUCCESSFULLY".