Error while creating Data source connection for SQL server 2005 in Cognos admin

[Gnani]

Error while creating Data source connection for SQL server 2005 in Cognos admin

I installed cognos 10.1 on windows7 with SQL server 2005.
While creating a datasource in cognos administration for GOSALES, when i test dsn,it throws below error.

Error
---------------------------
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): BIBusTKException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): BIBusTKException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1066): BIBusTKException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1064): BIBusTKException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1947): BIBusTKException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
CMCGenericSoap.cpp(59): BIBusTKException: CCL_RETHROW: CMCGenericSoap::execute
../Session/CSTSOAPSession.cpp(506): BIBusTKException: CCL_RETHROW: CSTSOAPSession::submit()
BITKTheBus.cpp(118): BIBusTKException: CCL_RETHROW: BITKTheBus::getSession
BITKConnectionPool.cpp(123): BIBusTKException: CCL_RETHROW: BITKConnectionPool::getSocketConnection
BITKSocket.cpp(266): BIBusTKException: CCL_THROW: BITKSocket::open()


Can you help me how to solve this?

[Gnani]

I have done following things
----------------------------------------------------
Installed Apache server
Installed SQL server 2005 server and Tools
add GOSALES database in SQL server
Installed Cognos 10.1.0 Server, FM and Samples
Created content store as data type as SQL server, GOSALES as name and tested successfully
added cognos related files in Apache conf folder
Started cognos services successfully

When i add dsn in cognos admin, i choose Microsoft SQL server (SQL 2008 Native client) or Microsoft SQL server (OLEDB)

It throws below error
------------------
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(757): BIBusTKException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): BIBusTKException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1066): BIBusTKException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1064): BIBusTKException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1947): BIBusTKException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
CMCGenericSoap.cpp(59): BIBusTKException: CCL_RETHROW: CMCGenericSoap::execute
../Session/CSTSOAPSession.cpp(506): BIBusTKException: CCL_RETHROW: CSTSOAPSession::submit()
BITKTheBus.cpp(118): BIBusTKException: CCL_RETHROW: BITKTheBus::getSession
BITKConnectionPool.cpp(123): BIBusTKException: CCL_RETHROW: BITKConnectionPool::getSocketConnection
BITKSocket.cpp(266): BIBusTKException: CCL_THROW: BITKSocket::open()


Looking for solutions...

[CognosPaul]

If you installed SQL Server 2005, you should use the SQL Server 2005 Native Client connection.

Is this error coming from testing the datasource in the admin page, or from Framework?

Are you using a 64bit or 32bit server? Is this a single server environment?

[Gnani]

I am mistaken, I used Microsoft SQL server Native Client 2005 only
Error is coming while testing dsn in cognos admin page, not from FM
am using 64bit server and single environment

[CognosPaul]

Can you post the details of the connection? Can you log into the database with Management Studio from the same server?