相关文章推荐
踏实的橙子  ·  数据库基本概念-天翼云·  2 年前    · 
慈祥的核桃  ·  zlib库VS2015编译步骤 - ...·  2 年前    · 
被表白的楼房  ·  java - "Could not ...·  2 年前    · 
火爆的咖啡  ·  C++ - Vector 计算 ...·  2 年前    · 

To return expected results, you can:

  • Reduce the number of search terms. Each term you use focuses the search further.
  • Check your spelling. A single misspelled or incorrectly typed term can change your result.
  • Try substituting synonyms for your original terms. For example, instead of searching for "java classes", try "java training"
  • Did you search for an IBM acquired or sold product ? If so, follow the appropriate link below to find the content you need.
  • Problem

    When running a query in IBM Cognos Query which accesses a MS SQL Server database using ODBC, the following errors occur: Error: ENGINE MESSAGE: Database signon not found[ ] ENGINE MESSAGE: Database Error: (SalesAnalysis),:State:08001,Native:-93,Origin:DMS-E-INVLLOGIN, Invalid login information was detected by the underlying database.[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

    Resolving The Problem

    This will occur if you specify to use NT Authentication using network login ID when setting up the SQL Server ODBC Data Source.

    Steps to change the setting:

    1. Open the Control Panel.
    2. Double-click ODBC Data Sources.
    3. From the System DSN tab, select your SQL Server data source.
    4. Click Configure.
    5. In the second dialog box for the Microsoft SQL Server DSN Configuration, in the section 'How should SQL Server verify the authenticity of the login ID?', select 'With SQL Server authentication using a login ID and password entered by the user'.
    6. Continue with the configuration until complete. [{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Query","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF033","label":"Windows"}],"Version":"Cognos 8 BI Framework Manager 8.2;Cognos Query 6.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Framework Manager","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Query","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

    Historical Number

    96450