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)
Смотрите видео Cognos Connection Create SQL Server Database Connection онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Mayank Sanghvi 18 Январь 2018, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,298 раз и оно понравилось 16 людям.