I tried to connect to a database via ODBC or Microsoft SQL Server (ODBC) and get always the following ERR: org.xml.sax.SAXException: UDA-SQL-0031 Unable to access the "cxdbinfo" 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-0043 The underlying database detected an error during processing the SQL request. MicrosoftODBC SQL Server DriverSQL ServerCannot open database "xxxx" requested by the login. The login failed.
The database is SQL Server 2012.
This topic has been locked.
2 replies Latest Post - 2013-03-01T22:59:08Z by SystemAdmin
Pinned topic SQL Server 2012
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-01T22:59:08Z at 2013-03-01T22:59:08Z by SystemAdmin
Nick_Waters 2700054SN11 PostACCEPTED ANSWER
Re: SQL Server 20122012-11-28T11:50:43Z in response to SystemAdminI dont believe SQL Server 2012 is supported in Cognos Express 10.1 at the moment (see link)...
You might want to try installing the SQL Server client tools on your Cognos Express server and see if a direct connection works though.
SystemAdmin 110000D4XK214 Posts