WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  WPS 6.2 connection problem to SQL SERVER 2008 R2

    Posted Fri January 31, 2014 01:49 PM

    I am unable to connect to SQL Server 2008R2 from WPS 6.2. When I try TEST Connection after configuring datasource from admin console, the connection is successful.


    While when connecting through WPS, I can see the below error:


    “The adapter could not establish a connection to the database for the following reason: The server version is not supported. The target server must be SQL Server 2000 or


    later.DSRA0010E: SQL State = 08S01, Error Code = 0.  Explanation=The adapter could not establish a connection to the database.”



  • 2.  WPS 6.2 connection problem to SQL SERVER 2008 R2

    Posted Fri January 31, 2014 02:25 PM
    Guys, I tried the latest version of JDBC driver jar file available at www.microsoft.com/en-in/download/details...

    extracted the sqljdbc.jar out of that. Started the Cluster. Even then the same error. 


    Can someone help.


    Thanks in advance.     


  • 3.  WPS 6.2 connection problem to SQL SERVER 2008 R2

    Posted Thu August 28, 2014 02:32 AM
    Hi,
    Can you able to resolve this issue. I am also facing this issue now. can you please help me on this to resolve.


Related Content