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.
Nick_Waters 2700054SN12 Posts
Re: SQL Server 20122012-11-28T11:50:43ZThis is the accepted answer. This is the accepted answer.I 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
Re: SQL Server 20122013-03-01T22:59:08ZThis is the accepted answer. This is the accepted answer.I'm planning to use SQL Server 2012 as datasource (DW) for Reporter and Advisor...
Did you find a way to access your SQL Server database ? I'm surprised ODBC doesn't work.