Categories
JDBC connection to SQL Server

Summary
JDBC connection to SQL Server
Content
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)