Topic
14 replies Latest Post - ‏2013-02-11T06:18:47Z by SystemAdmin
SystemAdmin
SystemAdmin
172 Posts
ACCEPTED ANSWER

Pinned topic Problem in adding MSSQL Datasource

‏2012-12-04T09:58:57Z |
Hi Team,

In TBSM, I want to add external mssql data source.

I clicked on data and adding attributes as required. However I am getting error as mentioned below.

Error Details:
CTGBA0024E The test connection was not opened. Reason: com.micromuse.common.datasource.SQLDataSourceException: Could not load JDBC driver for sa at jdbc:sqlserver://10.4.25.104:1433;databaseName=NOCI,sa at jdbc:sqlserver://10.4.25.104:1433;databaseName=NOCI #1756915896: com.microsoft.sqlserver.jdbc.SQLServerDriver

Could someone help me getting out of this.

Regards,
Avinash
Updated on 2013-02-11T06:18:47Z at 2013-02-11T06:18:47Z by SystemAdmin
  • gulfsoft
    gulfsoft
    10 Posts
    ACCEPTED ANSWER

    Re: Problem in adding MSSQL Datasource

    ‏2012-12-04T11:46:15Z  in response to SystemAdmin
    It looks like you have ",sa" at the end of your connection string, which isn't correct (AFAIK from a little research) . Remove that and try again.

    We can make Tivoli software work for you!
    www.gulfsoft.com
    • SystemAdmin
      SystemAdmin
      172 Posts
      ACCEPTED ANSWER

      Re: Problem in adding MSSQL Datasource

      ‏2012-12-04T12:04:23Z  in response to gulfsoft
      Hi,

      Thanks for quick response.
      However, NOCI is DB name and sa is instance name.

      This(,sa) shows up in error only.

      Regards,
      Avinash
  • dmcclure
    dmcclure
    54 Posts
    ACCEPTED ANSWER

    Re: Problem in adding MSSQL Datasource

    ‏2012-12-04T12:15:01Z  in response to SystemAdmin
    Assuming TBSM v6 - did you install the proper JDBC driver for MSSQL? 3rd party vendor drivers are not included out of the box.

    Doug
    • SystemAdmin
      SystemAdmin
      172 Posts
      ACCEPTED ANSWER

      Re: Problem in adding MSSQL Datasource

      ‏2012-12-04T12:49:48Z  in response to dmcclure
      Hi Doug,

      Could you please provide path or guide information for installation of drivers for 3rd party vendors tools.

      Regards,
      Avinash
      • dmcclure
        dmcclure
        54 Posts
        ACCEPTED ANSWER

        Re: Problem in adding MSSQL Datasource

        ‏2012-12-04T12:54:28Z  in response to SystemAdmin
        Here's a start:

        http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.tivoli.itbsm.doc_6.1/installguide/bsmi_installing_t_jdbc_drivers_adding.html

        Doug
        • SystemAdmin
          SystemAdmin
          172 Posts
          ACCEPTED ANSWER

          Re: Problem in adding MSSQL Datasource

          ‏2012-12-05T09:42:44Z  in response to dmcclure
          Hi,

          I have added the required jdbc driver files and tried to add the datasource, however I am getting following error.

          Just the error size got reduced.

          Error Details:
          CTGBA0024E The test connection was not opened. Reason: com.micromuse.common.datasource.SQLDataSourceException: JDBC Connection Pool could not connect to either data source
          Regards,
          Avinash
        • SystemAdmin
          SystemAdmin
          172 Posts
          ACCEPTED ANSWER

          Re: Problem in adding MSSQL Datasource

          ‏2012-12-19T06:33:15Z  in response to dmcclure
          Thanks Doug,

          Its working fine.
          Avinash
          • SystemAdmin
            SystemAdmin
            172 Posts
            ACCEPTED ANSWER

            Re: Problem in adding MSSQL Datasource

            ‏2013-02-08T04:14:16Z  in response to SystemAdmin
            Hi
            I am having the same issue. I downloaded the latest driver from MS with files
            -rw------- 1 bsm tbgroup 584207 Feb 18 2012 sqljdbc4.jar
            -rw------- 1 bsm tbgroup 563117 Feb 18 2012 sqljdbc.jar

            I tried each one but got the same error. Your last post said it was all working now - did you do anything else to fix this?
            thanks
            Steve
            • SystemAdmin
              SystemAdmin
              172 Posts
              ACCEPTED ANSWER

              Re: Problem in adding MSSQL Datasource

              ‏2013-02-08T08:03:23Z  in response to SystemAdmin
              Hello Steve/Parul,

              Hi Parul,

              1) Stop TBSM Dataserver

              2)
              Please add below mentioned files on two different paths on TBSM data server.

              Files:-
              a) mssqlserver.jar
              b) sqljdbc.jar
              c) sqljdbc4.jar
              d) sqljdbc4-2.0.jar

              Path:-
              a) /opt/IBM/tivoli/tipv2/profiles/TBSMProfile/installedApps/TBSMCell/TBSM.ear/impactwsn.war/WEB-INF/lib/
              b) /opt/IBM/tivoli/tbsm/dsalib

              Note:- Path might differ as per your environment.

              3) Start Data Server

              4) Try connecting now. If still fails, I can share document with which I was succesfuly added the SQL datasource.

              Regards,
              Avinash
              • Parul5G
                Parul5G
                5 Posts
                ACCEPTED ANSWER

                Re: Problem in adding MSSQL Datasource

                ‏2013-02-08T10:45:45Z  in response to SystemAdmin
                Hi Avinash,

                Thanks for the immediate solution. My first problem is resolved. However, i am now getting connection pool error

                Regards,
                Parul
                • SystemAdmin
                  SystemAdmin
                  172 Posts
                  ACCEPTED ANSWER

                  Re: Problem in adding MSSQL Datasource

                  ‏2013-02-08T10:50:04Z  in response to Parul5G
                  Could you please share the complete error

                  Regards,
                  Avinash
                  • Parul5G
                    Parul5G
                    5 Posts
                    ACCEPTED ANSWER

                    Re: Problem in adding MSSQL Datasource

                    ‏2013-02-08T12:50:49Z  in response to SystemAdmin
                    Error:
                    CTGBA0024E The test connection was not opened. Reason: com.micromuse.common.datasource.SQLDataSourceException: JDBC Connection Pool could not connect to either data source.
                    Thanks,
                    Parul
                    • SystemAdmin
                      SystemAdmin
                      172 Posts
                      ACCEPTED ANSWER

                      Re: Problem in adding MSSQL Datasource

                      ‏2013-02-11T06:18:47Z  in response to Parul5G
                      Hi Parul,

                      I would suggest you to telnet the port number for the server where DB is installed.

                      I suppose for SQL 1433 port should be opened.

                      Regards,
                      Avinash
  • Parul5G
    Parul5G
    5 Posts
    ACCEPTED ANSWER

    Re: Problem in adding MSSQL Datasource

    ‏2013-02-08T05:46:37Z  in response to SystemAdmin
    hi,

    I'm facing same issue while adding data source to MS-SQL database.

    Error:

    CTGBA0024E The test connection was not opened. Reason: com.micromuse.common.datasource.SQLDataSourceException: Could not load JDBC driver for sa at jdbc:sqlserver://10.220.8.66:1433;databaseName=SMDEV,sa at jdbc:sqlserver://10.220.8.66:1433;databaseName=SMDEV #209652863: com.microsoft.sqlserver.jdbc.SQLServerDriver

    Then i had done jdbc driver as mentioned in above post,still facing the same issue..

    Thanks in advance,
    Parul