MII 14.0 database connection error to MSSQL Server 2012

[Former Member]

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

[former_member204240 · Accepted solution]

Try giving full IP address and check.

Server URL: jdbc:sqlserver://172.25.1.6:1433;databaseName=test

Are you able to connect from MS SQL Server Management Studio?

Can you perform any validation query?

[Former Member · Accepted solution]

Dear Rao ,

Thanks for the update

I tried the options already you specified

Are you able to connect from MS SQL Server Management Studio? - Yes

Can you perform any validation query? - Yes

any other suggestions please

[former_member204240 · Accepted solution]

Can you try below steps

1. Open SQL Server Configuration Manager, and then expand SQL Server 2012 Network Configuration.
2. Click Protocols for InstanceName, and then make sure TCP/IP is enabled in the right panel and double-click TCP/IP.
3. On the Protocol tab, notice the value of the Listen All item.
4. Click the IP Addresses tab:
5. If the value of Listen All is yes, the TCP/IP port number for this instance of SQL Server 2012 is the value of the TCP Dynamic Ports item under IPAll.
6. If the value of Listen All is no, the TCP/IP port number for this instance of SQL Server 2012 is the value of the TCP Dynamic Ports item for a specific IP address.
7. Make sure the TCP Port is 1433.
8. Click OK.

Also check telnet 172.25.1.6 1433 works fine.

[Former Member · Accepted solution]

Many Thanks Padma Rao

your approach solved my problem

Regards,

Eswar

[Former Member]

Hi Eswar,

As per your error log, database is refused to connect. my suggestion

1. Cross check the user credentials, which should be same as MSSQL DB login credentials in Data services (i.e. User name & passwrd Parameters)

2. And as per screenshot,

In the server URL you have mentioned localhost. better try with server IP address with port. And check from MSSQL side, Client protocols all are enabled.

Regards,

Praveen Reddy