none
problem trying to feed content from an SQL Server 2008 Database RRS feed

  • Question

  • I’m running into this issue trying to feed content from an SQL Server 2008 Database using the jdbc connector.

     

    I’m using the connect.bat script included in the connector’s package with this connection string:

     

    jdbc:sqlserver://localhost\FASTDB:52198;database=Northwind

     

    this is the log:

     

    18:30:25,930 ERROR [JDBCConnector] Excpetion thrown in adapter class: com.fastsearch.esp.connectors.jdbc.JDBCAdapter, Could not connect to database: The driver could not establish a secure connection to SQL Server with encrypted Secure Sockets Layer (SSL). Error: "RSA premaster secret error".

     

    The sql’s instace name is FASTDB, and I’ve enabled the TCP/IP protocol for this instance.

     

    any idea?

    Thursday, November 11, 2010 11:24 PM

All replies

  • Hi,

    Please check the version of JDBC Connector used.

    if version is JDBC_Connector5.2 or lower - does not have a driver for  SQL Server 2008 Database. You will have to download the driver then try.

    thanks

    Wednesday, January 5, 2011 8:04 AM