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
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
4 answers
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