SAP BW-System and UD-Connect to MS-SQL server

[christoph_ostrop]

Hi,

we are on SAP-BW Netweaver 7.01 SPS 06.

i tried to configure an UD-Connect to a MS-SQL server.

i followed the HowTo-Guide: 

[HowTo-Guide UD-Connect|]

the test of RFC-Connection is o.k.

the URL to test the JDBC-Setting is failing:

(like http://<server>:<port>/TJdbc/servlet/TestJdbc)

? do i have to restart the SAP-System after configuring with VisualAdmin ?

? or maybe the HowTo-Guide is not up-to-date ?

i also could create an UD-Connect Datasource in RSA1,

the option "check" of this UD-Connect is also o.k. "source system xxxx is o.k."

the option "activate" starts a job (in SM37) RS_CACHE_INVALIDATE_MULTI, which is running and ends o.k.

but trying to create an datasource with the UD-Connect konfiguration brings up an error:

"UDCADAPTERROR::RSSDK|400|(com/microsoft/sqlserver/"

any idea ?

[former_member199630]

Hi Christoph,

Does your system an UNICODE system? Have you configured that?

Are you sure, the user has the correct authorization?, the view in the SQL has to be in uppercase.

Regards, Federico

[christoph_ostrop]

o.k. - now it works.

for all others, who will be faced with the same problem - here is the solution:

i had downloaded the "Microsoft SQL Server JDBC Driver 3.0" from Microsoft,

this was the first fault. because Vers. 3.0 must run on Java-5, (system requirements: Java Development Kit: 5.0 or later)

but our BW-System Netweaver 7.01 is running JAVA-1.4 ,

so, first you have to check the correct download of the used Microsoft MS-SQL driver,

we took now the "Microsoft SQL Server 2005 JDBC Driver 1.2" (system requirements: Java Development Kit: 1.4 or later)

although we want to connect to a MS-SQL server 2008.

you can find the java-error-messages in:

\usr\sap\<SID>\DVEBMGS<instance>\j2ee\cluster\server0\log\applications.n.log

#1.5 #001A64E934C3007300000004000004C50004A51EBA7BE011#1307451303125#/Applications/BI/UDI#

sap.com/com.sap.ip.bi.sdk.datasource.ds#com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean#<USER>

#20403##n/a##5c0f5157910511e08d6500000a144f92#SAPEngine_Application_Thread[impl:3]_0##0#0#Error#1#

com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean#Plain###

Exiting processFunction() with (com/microsoft/sqlserver/jdbc/SQLServerDriver) bad major version at offset=6#