IBM Support

ODBC may not be configured properly, error connecting to a project on a SQL Server database

Troubleshooting


Problem

This technote identifies a workaround for IBM® Rational® RequisitePro® to workaround the error, The project named (\\) could not be opened, because ODBC may not be configured properly. This error that can occur when a user tries to open a Microsoft® SQL Server based project.

Symptom

The full error message:



    The project named <Project Name> (\\<Path of .rqs>) could not be opened, because ODBC may not be configured properly.

    ODBC Error:
    Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '<DOMAIN>\<USERNAME>'.
    -Unable to connect to datasource.

Cause

Since a Windows user name and domain was included in the error message this states that Windows Authentication is used. Only SQL Server Authentication is supported.

The cause of the problem is a Trusted Connection is used. A trusted connection uses Windows Authentication.

Resolving The Problem

Check the database properties to see if a trusted connection is being used:

  1. In the Open Project dialog window, select the project.
  2. Click the properties button.


  3. If Trusted_Connection appears in the database properties dialog box Windows Authentication is being used.
    Note: Windows authentication is not supported. A RequisitePro SQL Server Database must use SQL Server Authentication.
  4. To resolve the issue, have the DBA modify the database user so it uses SQL Server Authentication.

  5. Also review on following checking points:
  • The service status of Microsoft SQL Server for RequisitePro SQL Database. via Microsoft's SQL application called "SQL Server Service Manager"

    Start > Programs > Microsoft SQL Server > Service Manager
  • The firewall settings (port: 1433) on all network devices such as switches and hubs from IBM Rational RequisitePro to Microsoft SQL Database Server.
  • The firewall (port: 1433) status of Microsoft SQL Server machine. Port: 1433 is a default SQL Server port. It may vary if you are running on non-default port. When all suspicions of SQL connection are cleared, run IBM Rational RequisitePro again.

[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.0;7.0.0.1;7.0.0.2;7.0.0.3;7.0.0.4;7.0.0.5;7.0.0.6;7.0.0.7;7.0.0.8;7.0.1;7.0.1.1;7.0.1.2;7.0.1.3;7.0.1.4;7.0.1.5;7.0.1.6;7.0.1.7;7.1.0.1;7.1.0.2;7.1.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21240597

Page Feedback