Olaf Kock:
Anu Narayanan:
Olaf, I tried to find how to backup and restore but could
not find proper documentation. I have a windows
environment and SQL Server database.
Hm. Where did you look? ;)
You might want to start here.
Regarding the upgrade: If you're intending to continue to use
SQL Server in 7.0 CE, you'll need Antonio's plugin
for database support (or DXP 7.0), otherwise you should convert
your database to one of the 7.0 CE supported ones while you're
in 6.2, then upgrade.
Thanks Olaf. I was able to migrate my application from one
environment to the other successfully. I want to now upgrade to the
version 7.1. Since we are intending to continue with the community
edition for now I tried to add the plugin for the database support for
the SQL server as suggested by you. I 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
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?
I am trying to connect to SQL server 2008.
Let me know if I have to open a different discussion thread since
this question is on the upgrade.
thanks,
Anu
