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

RRDI setup error with MS SQL 2008

Hello,

I tried to install RRDI on Windows 2008 R2 Datacenter with SQL Server 2008 SP1. Everything was OK until step "Configuring the data source connection for the data warehouse". I've configured connection as described in step 8 (http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=/com.ibm.rational.rcpr.help.doc/topics/t_cognos_signon.html).
Connection test has failed. Any ideas?

QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
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-0532 Data Source is not accessible: "local:1433".
UDA-SQL-0564 Login timeout expired (SQLSTATE=HYT00, SQLERRORCODE=0)
UDA-SQL-0564 A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (SQLSTATE=08001, SQLERRORCODE=53)
UDA-SQL-0564 Named Pipes Provider: Could not open a connection to SQL Server . (SQLSTATE=08001, SQLERRORCODE=53)
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

-thanks in advance

1 vote



4 answers

Permanent link
Hello,

I tried to install RRDI on Windows 2008 R2 Datacenter with SQL Server 2008 SP1. Everything was OK until step "Configuring the data source connection for the data warehouse". I've configured connection as described in step 8 (http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=/com.ibm.rational.rcpr.help.doc/topics/t_cognos_signon.html).
Connection test has failed. Any ideas?

QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
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-0532 Data Source is not accessible: "local:1433".
UDA-SQL-0564 Login timeout expired (SQLSTATE=HYT00, SQLERRORCODE=0)
UDA-SQL-0564 A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (SQLSTATE=08001, SQLERRORCODE=53)
UDA-SQL-0564 Named Pipes Provider: Could not open a connection to SQL Server . (SQLSTATE=08001, SQLERRORCODE=53)
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

-thanks in advance

Have you looked at the SQL Server logs, they may provide more information?

It appears that Cognos cannot communicate with SQL Server, so check that you can ping the database system, the database server name is spelled right, that SQL Server will accept remote connections, etc. I'm assuming that SQL Server is installed on a different machine. Is the Content Store database in this same SQL Server

0 votes


Permanent link
Hi Michael,

SQL Server is on the same server and I could connect to the database using the same credentials using SQL Server Management Studio.
I could see any actions in Log. It seems that there were no connection attempts.

-Timur

0 votes


Permanent link
It seems that problem related to SQL Server Browser service. It is stopped.

0 votes


Permanent link
I've connected to the server.
- Check that SQL Server Browser service is running
- Check that SQLCMD /L returns correct server name
- Create ODBC connection to SQL server
- Connect from Cognos Administration using "Microsoft SQL Server (ODBC)" connection type

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,501

Question asked: Aug 08 '11, 11:07 a.m.

Question was seen: 6,660 times

Last updated: Aug 08 '11, 11:07 a.m.

Confirmation Cancel Confirm