Step 5: You can also verify the connectivity by creating an alias on the client following the below steps. Place the IP Address and desired port number in TelNet To check the IP Address, execute the below command from dos prompt Step 2: Restart the SQL Server Service using the below commands or do this from with SQL Server Configuration Manager. > Under IP All section TCP Port, you can add multiple ports using comma separators as shown below
> Right Click on TCP/IP protocol select properties > Click on protocols for MSSQLServer (For named instance click on the Protocols for Instance Name) > Click on SQL Server Network Configuration Below is an easy solution without changing the configuration for the other applications. In my case a third party application needs to connect to SQL Server using the default port 1433, but I already have port 48030 configured. If there is a need to have SQL Server listen on multiple ports this can be done using SQL Server Configuration Manager.
SQL SERVER CLIENT PORTS HOW TO
In this tip we walk through how to configure a SQL instance to listen on multiple TCP/IP ports.
As per a new business requirement we need to host a new application database on the same SQL instance, but the application is unable to connect to the SQL instance because it us hard corded to use the default port 1433. A number of database applications are hosted on the same default SQL instance and these applications are connecting to SQL Server through port 48030. Recently I came across a situation where an existing production SQL Server default instance was configured to use static TCP/IP port 48030 and the default 1433 port was disabled. By: Jugal Shah | Updated: | Comments (2) | Related: More > SQL Server Configurations
0 kommentar(er)
