I am trying to connect to a Microsoft SQL 2008 or another server which is not on port 1433. How do I indicate a different port number when connecting to the server using SQL Management Studio?
In SQL Server Configuration Manager. Go to Sql Native Client Configuration, Select Client Protocols, Right Click on TCP/IP and set your default port there.
to connect to sql, enter the server address and then enter the port number after the comma SQLSERVER\InstanceName,portnumber - SQL\InstSQL, 1025
sql server processes and find port
netstat -a -b