Connection of WildFly 10.1.0 to SQLServer2016?

[girishjoshi]

Connection of WildFly 10.1.0 to SQLServer2016?

Not able to connect to SQLServer 2016 (having different service name) through wildfly10.1.0

throwing -

"WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid",

[girishjoshi]

Default name of SQLServer instance is MSSQLSERVER

and I have installed two SQLServers on one machine i.e.

Instances are like-

1. MSSQLSERVER

2. SQLSERVER2016

Now using SQL Studio I am able to connect to server using URL like - <ip>\SQLSERVER2016

Not able to connect through console ?

where can I find the port number of new sql server instance?

does it required sqljdbc.jar file? I am using sqljdbc4.jar file.

[girishjoshi]

Issue Resolved- it is of sql server specific.

The default port for MSSQLSERVER is 1433

and when there is another instance of sql server is running on same machine (suppose sqlserver2016)

then the port is dynamically assigned to the new instance.

you can find the port number used by new instance of sqlserver using following steps-

1. start

2. run

3. regedit

4. go to Microsoft SQL Server

5. MSSQL$SQLSERVER2016

6. MSSQLServer

7. SuperSocketNetLib

8. Tcp -> IPAll

you can check the TcpDynamicPorts

sqljdbc4.jar is ok

Thanks.