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