1. Home
  2. Portal
  3. RE: Upgrade Liferay portal from 6.2 to 7.1

RE: Upgrade Liferay portal from 6.2 to 7.1

Anu Narayanan, modified 7 Years ago.
Upgrade Liferay portal from 6.2 to 7.1
Junior Member Posts: 50 Join Date: 4/24/15 Recent Posts

 I am planning to upgrade my Liferay portal application version 7.1 from version 6.2.  Since there is no support for the MS SQL server in the new CE version 7.1 , I added  Antonio's plugin for database support. I did the following steps :- 

1. Downloaded and added the liferay-portal-sqlserverdb-support-1.0.1.jar to the 

Liferay_Home\tomcat-9.0.6\webapps\ROOT\WEB-INF\lib folder and

2. included the sqljdbc4.jar in the Liferay_Home\tomcat-9.0.6\lib\ext folder.

Now I am getting the error 

"com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed."" 

Do I have to do anything on the database side?

The database I am trying to connect is MS SQL Server 2008. 

 

Thanks,

Anu

thumbnail
Alberto Chaparro, modified 7 Years ago.
RE: Upgrade Liferay portal from 6.2 to 7.1
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Anu,

 

I think it is a problem with the drive, take a look at:

https://developer.ibm.com/answers/questions/189976/why-i-am-unable-to-connect-to-sql-server-using-ssl.html

 

 

Regards.

Anu Narayanan, modified 7 Years ago.
RE: Upgrade Liferay portal from 6.2 to 7.1
Junior Member Posts: 50 Join Date: 4/24/15 Recent Posts
Alberto Chaparro:

Hi Anu,

 

I think it is a problem with the drive, take a look at:

https://developer.ibm.com/answers/questions/189976/why-i-am-unable-to-connect-to-sql-server-using-ssl.html

 

 

Regards.

 

Hi Alberto, I did come across this post earlier. I am currently using the sql jdbc driver 4. Still getting the error. 

Any help is appreciated.