SMP 3.0 Gateway Error with MS SQL Conctivity

[Former Member]

Hello Jitendra , I am trying to connect to MS SQL with SMP 3.0 via gateway . But getting below error "Cannot create PoolableConnectionFactory (The TCP/IP connection to the host mssqlserver, port 1455 has failed. Error: "null. 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.".)" And also i have attached screen shot for more information. Can you please check it once ? Thanks & Regards,      Kunal Varaiya

[Jitendra_Kansal]

Hi Kunal,

seems while retrieving entityset CustomerObj details, you are facing this error.

1. Make sure you have checked 'Analyzer library contents and add dependencies' option while generating the OSGi jar file for MS SQL. By default, this option is not checked.
2. re-deploy OSGi enabled jar file
3. make sure you get OK status in .state folder
4. Entityset name (CustomerObj) should be same as Table name in MS SQL
5. All entity properties should have same name as table's column names
6. Make sure while opening the service document database is up and running.

I doubt your destination properties settings in gateway cockpit. Are you sure about port 1455? Why dont you share some screenshots what all step you have tried?

Are you following Marvin's document

Regrds,

JK