What ports are permitted for named instances? SQL Server Logs (under Management > SQL Server Logs) has two entries from Source = spid16s with the same messages: Message = Server is listening on ['any' 1433]
By default named instances are bounded with dynamic ports and SQL Browser service is the one redirects the client connections to named instances. For ...
Once you start configuring the TCP/IP settings for a SQL Server instance, there are multiple things you have to be aware of.
SQL Server Browser Service
The SQL Server Browser Service is responsible for redirecting SQL Server Connection Requests to the corresponding instance.
Is the SQL Server Browser Service running on the server?
You should be able ...
Make sure the below requirements are met.
Do a ping from laptop 1 to laptop 2 and vice versa. Make sure it's able to ping
Check the ports are open, so no firewall blocking is there. Use TELNET command for this.
if it fails on that we have to check SQL server network configuration settings.
We connected with Tibco support to resolve this issue.
Change jar from mysql-connector-java-8.0.11.jar to mysql-connector-java-5.1.48.jar. Place the jar file "mysql-connector-java-5.1.48.jar" in location
"\conf\adapters\system\mysql_5_5". Then restart the TDV server.
Create a new MySql 5.5 datasource with same credentials. Open the advanced ...