How
to connect to a different port with SQL Server Management Studio
Microsoft SQL Server Management Studio will connect by
default to port 1433 and there is nowhere
in the connect dialog box below to specify a different port from the default. So,
if you want to connect using different port then specify the Server name or IP , a comma and then the
port number.
Connect
using a different port using a comma:
The connection dialog in the SQL Server Management
Studio is shown below.
Normally, you would just type the server name into the
field but, to specify a different port number use a comma after the server name
then enter the port number.
The above example shows the “Rain-sql” as the server
name and “port” where the port would be.
If you want to connect to a server
named Shine-sql on port 4321 then set the Server name to
Example: Shine-sql,4321
If you know the IP of the server then in place of the
server name you can use the IP.
Example: 192.168.1.22,6789
For
named instances, you usually connect by specifying the
server name and instance name (in place of port number).
Example: Shine-sql, instance name
If you specify the port the named instance is using
then there is no need to specify the instance name because each instance on a
server uses a different port.
No comments:
Post a Comment