0 Replies Latest reply on May 30, 2018 3:28 AM by 3310714

    JDBC connection to SQL Server

    3310714

      Hi,

       

      I'm using XML Publisher 12.2.1.2 and trying to establish a JDBC connection to SQL Server 2012.  But, I keep on getting errors and couldn't figure out how to do it.  See below for error message.  The account works fine because I could connect using ODBC and SQL Server Management Studio.

       

       

      [2018-05-29T17:20:39.942-10:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 148] [userId: <anonymous>] [ecid: 281157a0-60da-4707-af85-4bfbe51552aa-00001ebc,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] jdbc:weblogic:sqlserver://servername:1433;DatabaseName=dbname

      [2018-05-29T17:20:39.943-10:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 148] [userId: <anonymous>] [ecid: 281157a0-60da-4707-af85-4bfbe51552aa-00001ebc,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] domain\account

      [2018-05-29T17:20:39.943-10:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 148] [userId: <anonymous>] [ecid: 281157a0-60da-4707-af85-4bfbe51552aa-00001ebc,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] weblogic.jdbc.sqlserver.SQLServerDriver

      [2018-05-29T17:20:39.944-10:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 148] [userId: <anonymous>] [ecid: 281157a0-60da-4707-af85-4bfbe51552aa-00001ebc,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] weblogic.jdbc.sqlserverbase.dden: [FMWGEN][SQLServer JDBC Driver][SQLServer]Login failed for user 'domain\account'.[[

      at weblogic.jdbc.sqlserverbase.ddcv.b(Unknown Source)

      at weblogic.jdbc.sqlserverbase.ddcv.a(Unknown Source)

      at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)

      at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)

      at weblogic.jdbc.sqlserver.tds.ddj.a(Unknown Source)

      at weblogic.jdbc.sqlserver.tds.ddr.c(Unknown Source)

      at weblogic.jdbc.sqlserver.tds.ddj.a(Unknown Source)

      at weblogic.jdbc.sqlserver.SQLServerImplConnection.f(Unknown Source)

      at weblogic.jdbc.sqlserverbase.BaseConnection.b(Unknown Source)

      at weblogic.jdbc.sqlserverbase.BaseConnection.k(Unknown Source)

      at weblogic.jdbc.sqlserverbase.ddak.run(Unknown Source)