2 Replies Latest reply on Apr 4, 2017 7:40 AM by GIRISH JOSHI

    Connection of WildFly 10.1.0 to SQLServer2016?

    GIRISH JOSHI Newbie

      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",

        • 1. Re: Connection of WildFly 10.1.0 to SQLServer2016?
          GIRISH JOSHI Newbie

          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.

          • 2. Re: Connection of WildFly 10.1.0 to SQLServer2016?
            GIRISH JOSHI Newbie

            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.