Skip to Content
0
Former Member
Dec 19, 2013 at 06:47 AM

MII 14.0 database connection error to MSSQL Server 2012

308 Views

Dear Experts ,

I am trying to create a database connection from MII 14.0 to SQL server 2012

JDBC drivers are uploaded fine , when creating a connection, following error occured in logs

Unable to get a connection from the pool

[EXCEPTION]

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 172.25.1.6, port 1433 has failed. Error: "Connection refused: connect. Verify the 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 connections to the port are not blocked by a firewall.".

I checked that firewall is off

Following are the settings done in MII

JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Server URL : dbc:sqlserver://localhost:1433;databaseName=test

Has anyone faced this king of issue earlier

Any help would be highly appreciated

Regards,

Eswar

Attachments

DataServer.JPG (39.1 kB)
JDBC Driver.JPG (29.5 kB)