Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RRDI SQL Connection string for the data source connection

I am using sql 2008 on a separate server and trying to setup the data source connection. I am not using the default instance and keep getting the following error when I try to test the connection.

QE-DEF-0285 The logon failed.
QE-DEF-0322 The connection string is invalid.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0534 Invalid connection string.
UDA-SQL-0206 The OLEDB driver returned the following value: HRESULT= -2147221164".
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(716): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(714): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1545): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2071): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE



How is the database name supposed to be configured when not using the default instance? I have tried both servername\instance and servername,port with the same results. I verified that the signon user has full rights to both RIDW and RICM database's

0 votes



One answer

Permanent link
Hi Mate,

I noticed your thread when I was fixing a problem for my client. It turns out that the PORT NUMBER for the MS SQL SERVER is important in my case. I found the answer on this post:

http://www.cogknowhow.com/forum/index.php?topic=146.0

I hope this helps you.

Cheers, Simon

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,592

Question asked: Jan 25 '12, 10:39 a.m.

Question was seen: 11,339 times

Last updated: Jan 25 '12, 10:39 a.m.

Confirmation Cancel Confirm