connection to Sql Server 2016

Hello everybody,

I am having some troubles in creating datasource connection for Sql Server 2016.

My configuration is described in the image here.

The continuous line shows the successful connection toward DB MySql and the related label 'localhost' is the value provided in the connection string:

jdbc:mysql://localhost:3306/mydb_mysql?useOldAliasMetadataBehavior=true

The dotted line shows the failed connection toward DB Sql server and the related label '192.168.1.10' is the value provided in the connection string.

By the way:
- in VM we have just a "Network adapter", of "Host-only" type
- the IP 192.168.1.10 is the result of running "ipconfig" command, inside Windows 10

I have followed of course all guidelines in: forum link
and also the suggestions in: community link

In particular, the snippet of parameters in the file:
<JBOSS_HOME>/standalone/deployments/appian-mssql-ds.xml

is the following:

<xa-datasource-property name="ServerName">192.168.1.10</xa-datasource-property>
<xa-datasource-property name="PortNumber">1433</xa-datasource-property>
<xa-datasource-property name="DatabaseName">mydb_sqlserver</xa-datasource-property>

Lastly I put parameters  in admin panel (/suite/admin) page as follows:

Name = jdbc/Appian_sqlserver
Type =  SQL Server
Username = myuser
Password = mypassword
Connection String = jdbc:sqlserver://192.168.1.10:1433;databaseName=mydb_sqlserver

but the result is the message error: "Could not connect to the specified host and port"

What am I missing or doing wrong?
Any suggestions or directions will be very appreciated.

Thank you in advance, best regards.
Paolo

  Discussion posts and replies are publicly visible