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=trueThe 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 10I have followed of course all guidelines in: forum linkand also the suggestions in: community linkIn particular, the snippet of parameters in the file:<JBOSS_HOME>/standalone/deployments/appian-mssql-ds.xmlis 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_sqlserverType = SQL ServerUsername = myuserPassword = mypasswordConnection String = jdbc:sqlserver://192.168.1.10:1433;databaseName=mydb_sqlserverbut 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