Skip to Content
avatar image
Former Member

Problem Setting Up Connection to MS SQL Server 20052

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Feb 05, 2010 at 12:48 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2010 at 03:16 AM

    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:tcsecssl

    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:bimmrjmi

    common:library:bimmrcore;library:bimmrdb

    library:bimmrcwm_1.0_library

    sap.com/caf~core

    sap.com/cafruntimeear

    library:tcconnconnectorframework

    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:

    D:
    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

    D:
    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

    D:
    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

    D:
    usr
    sap
    TRD
    DVEBMGS00
    j2ee
    cluster
    server0
    apps
    sap.com
    cafbwadapterassembly
    connector
    connectors
    caf
    bwadapterassembly.rar
    sap.comcafbwadaptercaf.bw.adapter.jar

    Loading model: {parent,references,local}

    -


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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 29, 2010 at 06:42 AM

    Solved by using JDBC Driver 1.2 hotfix

    Add comment
    10|10000 characters needed characters exceeded