Problem Setting Up Connection to MS SQL Server 20052

[Former Member]

Hi Experts,

I need a BI JDBC System in portal to connect to MS SQL Server 2005.

The connection properties i had entered is:

Connection URL: jdbc:sqlserver://<server host name>:1433;database=TOMAS_DW

Driver Name: com.microsoft.sqlserver.jdbc.SQLServerDriver

But i still get a failed in test connection test which says:

Class Not Found: com.microsoft.sqlserver.jdbc.SQLServerDriver

com.sap.ip.bi.sdk.exception.BIResourceException: Class DriverName is not found

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

i had followed instructions to import the MS SQL Server driver sqljdbc1.2 (sqljdbc.jar) into Visual Administrator.

Please help and thank you in advance.

Sarah

Edited by: kityein lai on Feb 4, 2010 10:51 AM

[Former Member]

Solved by using JDBC Driver 1.2 hotfix

[Former Member]

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Found in negative cache

-

---

Loader Info-----

ClassLoader name: [connector:default|http://forums.sdn.sap.com/]

Parent loader name: [Frame ClassLoader|http://forums.sdn.sap.com/]

References:

common:service:http;service:servlet_jsp

service:ejb

common:service:iiop;service:naming;service:p4;service:ts

service:jmsconnector

library:jsse

library:servlet

common:library:IAIKSecurity;library:activation;library:mail;library:tc_secssl

library:ejb20

library:j2eeca

library:jms

library:opensql

common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:webservices_lib;service:adminadapter;service:basicadmin;service:com.sap.security.core.ume.service;service:configuration;service:connector;service:dbpool;service:deploy;service:jmx;service:jmx_notification;service:keystore;service:security;service:userstore

interface:resourcecontext_api

interface:webservices

interface:cross

interface:ejbserialization

library:com.sap.ip.bi.sdk

library:bi_mmrjmi

common:library:bi_mmrcore;library:bi_mmrdb

library:bi_mmrcwm_1.0_library

sap.com/caf~core

sap.com/caf_runtimeear

library:tc_connconnectorframework

library:sapxmltoolkit

sap.com/com.sap.ip.bi.sdk.dac.connector.xmla.x

library:com.sap.mw.jco

library:com.sap.aii.proxy.framework

library:com.sap.aii.util.misc

library:com.sap.ip.bi.sdk.dac.connector.odbodll

library:JDBC_DRIVER

library:MSSQL_JDBC

Resources:

😧
usr
sap
TRD
DVEBMGS00
j2ee
cluster
server0
apps
sap.com
com.sap.ip.bi.sdk.dac.connector.xmla
connector
connectors
bi_sdk_xmla.rar
bi_sdk_xmla.jar

😧
usr
sap
TRD
DVEBMGS00
j2ee
cluster
server0
apps
sap.com
com.sap.ip.bi.sdk.dac.connector.sapq
connector
connectors
bi_sdk_sapq.rar
bi_sdk_sapq.jar

😧
usr
sap
TRD
DVEBMGS00
j2ee
cluster
server0
apps
sap.com
com.sap.ip.bi.sdk.dac.connector.jdbc
connector
connectors
bi_sdk_jdbc.rar
bi_sdk_jdbc.jar

😧
usr
sap
TRD
DVEBMGS00
j2ee
cluster
server0
apps
sap.com
caf_bwadapter_{assembly
connector
connectors
caf}bw_adapterassembly.rar
sap.com_cafbw_adaptercaf.bw.adapter.jar

Loading model: {parent,references,local}

-

---

at com.sap.engine.frame.core.load.ReferencedLoader.loadClass(ReferencedLoader.java:360)

[Former Member]

Here i provide the screen shots where i import the driver.

<a href="http://www.freeimagehosting.net/uploads/51cb0eb970.jpg">http://www.freeimagehosting.net/uploads/51cb0eb970.jpg</a>

<a href="http://www.freeimagehosting.net/uploads/90e2b044d5.jpg">http://www.freeimagehosting.net/uploads/90e2b044d5.jpg</a>

[url]http://www.freeimagehosting.net/uploads/5b9212ef2d.jpg[/url]

I wonder where did i make mistakes. Thanks.