Default name of SQLServer instance is MSSQLSERVER
and I have installed two SQLServers on one machine i.e.
Instances are like-
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.
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-
4. go to Microsoft SQL Server
8. Tcp -> IPAll
you can check the TcpDynamicPorts
sqljdbc4.jar is ok