SQL Server 2008 64 Bit not connection in MII 14.0.2 (Netweaver 7.31)

[Former Member]

Hi,

We are trying to connect the SQL Server 2008 database (64 Bit) from MII (version 14.0.02) and the Netweaver version is 7.31.

SQL jdbc driver used : sqljdbc4.jar (uploaded in JDBC Drivers in MII).

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

Connection String : jdbc:sqlserver://xx.xx.xx.xx\Instancename:1433;DatabaseName=xxxxxxxxxxx

But we find it is giving the error.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Unable to get a Connection from the pool

[EXCEPTION]

com.microsoft.sqlserver.jdbc.SQLServerException: Failed to establish TCP / IP connection to the host 'xx .xx.xx.xx ', port 1433. Error: 'Connection refused: connect. Verify the connection properties, and make sure that a SQL Server instance is running on the host that accepts TCP / IP connections on the port. Also, check that the TCP connections to the port are not blocked by a firewall. '

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

In the SQL server, the port has been opened correctly... and further we are able to telnet from MII server to SQL server on that port... But when trying to configure the dataserver it is showing this error.

Please let me know how I can resolve this. I have tried with different driver (jtds, sqlserver4, sqlserver) but no success.

Thanks in advance.

R. Prasanna

[former_member228740]

Hi Prasanna,

Addition to Padma's connection string, check 3 things

1. The port configuration in SQL Server configuration - 1433 should be there in "TCP/IP all" field and TCP/IP connections are enabled

2. There are no firewall blocks, the source and destination ports needs to be opened in firewall

3. The user and password you are putting should have relevant privileges in the database you are connecting.

Regards

Anant

[former_member204240]

pass Connection String as below and check

jdbc:sqlserver://xx.xx.xx.xx:1433/DatabaseName(gv database name)