Topic
  • 2 replies
  • Latest Post - ‏2013-03-01T22:59:08Z by SystemAdmin
SystemAdmin
SystemAdmin
214 Posts

Pinned topic SQL Server 2012

‏2012-11-28T10:04:19Z |
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.
Updated on 2013-03-01T22:59:08Z at 2013-03-01T22:59:08Z by SystemAdmin
  • Nick_Waters
    Nick_Waters
    1 Post

    Re: SQL Server 2012

    ‏2012-11-28T11:50:43Z  
    I dont believe SQL Server 2012 is supported in Cognos Express 10.1 at the moment (see link)...
    http://www-01.ibm.com/support/docview.wss?uid=swg27024128

    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
    SystemAdmin
    214 Posts

    Re: SQL Server 2012

    ‏2013-03-01T22:59:08Z  
    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.