Cognos Connection Create SQL Server Database Connection скачать в хорошем качестве

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)