RE: Is SQL Server supported in Liferay 7 .1 ce ?

thumbnail
Ramalingaiah. D, modified 5 Years ago. Expert Posts: 489 Join Date: 8/16/14 Recent Posts
Hi ,Database Type: SQLServer
JDBC URL: jdbc:sqlserver://192.168.1.50:1433;databaseName=lportal
JDBC Driver Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
User Name: UserName
Password: Password
 how to connect database
i am unable to connect database  SQLServer
suggest me
 i am using liferay version 7.1 ce ga1
Thank you Ram
thumbnail
David H Nebinger, modified 5 Years ago. Liferay Legend Posts: 14933 Join Date: 9/2/06 Recent Posts
Enterprise databases are not supported by CE out of the box.

Antonio Musarra shares in his blog how to build it yourself then: https://www.dontesta.it/en/2016/04/19/liferay-7-ce-how-to-add-support-for-sql-server-db/
thumbnail
Ramalingaiah. D, modified 5 Years ago. Expert Posts: 489 Join Date: 8/16/14 Recent Posts
Hello David ​​​​​​​,thank you 
thumbnail
Ramalingaiah. D, modified 5 Years ago. Expert Posts: 489 Join Date: 8/16/14 Recent Posts
01-Jan-2020 06:31:42.752 SEVERE [main] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class [com.liferay.portal.spring.context.PortalContextLoaderListener] java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.kernel.util.InfrastructureUtil' defined in class path resource [META-INF/infrastructure-spring.xml]: Cannot resolve reference to bean 'liferayTransactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayTransactionManager' defined in class path resource [META-INF/hibernate-spring.xml]: Cannot resolve reference to bean 'liferayHibernateSessionFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayHibernateSessionFactory' defined in class path resource [META-INF/hibernate-spring.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: com/liferay/portal/dao/db/BaseDB
thumbnail
Jack Bakker, modified 5 Years ago. Liferay Master Posts: 978 Join Date: 1/3/10 Recent Posts
For MSSQL on v7.1ce I successfully followed the steps here at https://github.com/amusarra/liferay-portal-database-all-in-one-support 
thumbnail
Ramalingaiah. D, modified 5 Years ago. Expert Posts: 489 Join Date: 8/16/14 Recent Posts
Dear Team,02-Jan-2020 09:10:53.356 SEVERE [main] org.apache.catalina.core.StandardContext.listenerStart Exception sending context initialized event to listener instance of class [com.liferay.portal.spring.context.PortalContextLoaderListener]
 java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.kernel.util.InfrastructureUtil' defined in class path resource [META-INF/infrastructure-spring.xml]: Cannot resolve reference to bean 'liferayTransactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayTransactionManager' defined in class path resource [META-INF/hibernate-spring.xml]: Cannot resolve reference to bean 'liferayHibernateSessionFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferayHibernateSessionFactory' defined in class path resource [META-INF/hibernate-spring.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: com/liferay/portal/dao/db/BaseDB
    at com.liferay.portal.spring.context.PortalContextLoaderListener.contextInitialized(PortalContextLoaderListener.java:262)
i am getting error ,i am just connecting ms sql database only, please help out me