Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MII 14.0 database connection error to MSSQL Server 2012

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

DataServer.JPG (39105 B)
JDBC Driver.JPG (29502 B)
Former Member
Former Member replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question