Cognos Connection Create SQL Server Database Connection
Cognos Connection Create SQL Server Database Connection
In this video, we are going to learn about how to create a SQL Server Database connection to use it in Cognos.
In our tutorial video we used SQL Server 2005 as a Database Server. Steps are same for other database
1. SQL Server 2005
2. SQL Server 2008
3. SQL Server 2008 r2
4. SQL Server 2012
5. SQL Server 2014
6. SQL Server 2016
7. SQL Server 2017
We know this video is too long for a simple database connection but covered 5 ways to connect SQL Server Database.
We also face an issue while trying to connect SQL Server Database using ODBC. Below is error details
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
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. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1153): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1151): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(2034): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2070): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE
Script Stack Trace
Action No=1 Action Name=TestDataSourceConnection
For resolving this issue we need to change IBM Cognos Services Log on the account.
Useful URL:
Our Website: https://vlemonn.com
Facebook: / vlemonn
Twitter: / vlemonn
Google Plus: https://plus.google.com/+MayankSanghv...
Youtube: / mayanksanghvi
Whats App: 8818882120 (Only for Registered and verified Users)
Watch video Cognos Connection Create SQL Server Database Connection online, duration hours minute second in high quality that is uploaded to the channel Mayank Sanghvi 18 January 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 5,298 times and liked it 16 visitors.
