IBM Support

SQLDriverConnect (08001) error connecting to, or creating an ReqPro project

Troubleshooting


Problem

This technote identifies how to resolve the SQLDriverConnect (08001) error which might occur when attempting to log in, or create an IBM® Rational® RequisitePro® (ReqPro) project.

Symptom

The full error message is as follows:

Unable to login to the database using the following connection information: DRIVER={SQL Server}; UID=ResolveAdmin; DATABASE=ReqPro; PWD=********;SERVER=BSILVERM. Verify that the information used matches the way the database was set up. The error message was:
SQLDriverConnect: RETCODE=-1, State=08001, Native Error=17 [Microsoft] [ODBC SQL Server Driver][Multi-Protocol]SQL Server does not exist or access denied. [Microsoft][ODBC SQL Server Driver][Multi-Protocol] ConnectionOpen (Connect()).

Cause

The error is caused by having the MultiProtocol network library selected in the client configuration dialog box for the DSN.

Resolving The Problem

To resolve this issue, you will need to select the TCP/IP network library in the Client Configuration dialog.

  1. Launch ReqPro and select the project you are trying to log in to
  2. Select Properties
  3. Select Configure
  4. Enter the server name in the Server alias
  5. On the next screen, select Client Configuration and make sure the settings for Network Library match the screenshot below.

  6. Once you have verified that TCP/IP is selected, continue the project configuration by referencing Chapter 3 in the ReqPro installation guide (c:\program files\rational\requisitepro\doc\books\rp_install.pdf).
[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.00;2003.06.01;2003.06.10;2003.06.12;2003.06.13;2003.06.14;2003.06.15;2003.06.16;7.0;7.0.0.1;7.0.0.2;7.0.1;7.0.1.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

More support for:
Rational RequisitePro

Software version:
2003.06.00, 2003.06.01, 2003.06.10, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.15, 2003.06.16, 7.0, 7.0.0.1, 7.0.0.2, 7.0.1, 7.0.1.1

Operating system(s):
Windows

Document number:
95171

Modified date:
16 June 2018

UID

swg21294168

Manage My Notification Subscriptions

Page Feedback