JDBC connection to SQL Server — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

JDBC connection to SQL Server

Question
21
Views
0
Comments
3310714
3310714 Rank 6 - Analytics Lead
in Oracle Analytics Cloud and 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)