Ask Questions and Find Answers

Hello,

I am trying out Liferay DXP and having trouble connecting to my local SQL Server 2008 (SQLEXpress). I tried using both jtds and sqljdbc driver and the final error in both cases is 'Dialect Not found'.
The local SQL Server does have TCP/IP enabled and port 1433 open, and i have no problems connecting to it using Liferay 6.2.

I tried all possible variations of jdbc url, ie.: jdbc:sqlserver://localhost:1433;databaseName=Liferay7;instance=SQLEXPRESS;
and all give the same error.
Here is the stack trace:

00:42:18,297 ERROR [http-nio-8080-exec-8][DialectDetector:137] com.microsoft.sql
server.jdbc.SQLServerException: The TCP/IP connection to the host localhost, por
t 1433 has failed. Error: "Connection refused: no further information. Verify th
e connection properties. Make sure that an instance of SQL Server is running on
the host and accepting TCP/IP connections at the port. Make sure that TCP connec
tions to the port are not blocked by a firewall.".
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the ho
st localhost, port 1433 has failed. Error: "Connection refused: no further infor
mation. Verify the connection properties. Make sure that an instance of SQL Serv
er is running on the host and accepting TCP/IP connections at the port. Make sur
e that TCP connections to the port are not blocked by a firewall.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(S
QLServerException.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExcepti
onToSQLServerException(SQLServerException.java:242)

00:42:18,482 ERROR [http-nio-8080-exec-8][status_jsp:903] No dialect found


Does anyone know what is happening here?
thank you