Options
Add SQL Server running on a non-standard port
zsolt.vincze
Posts: 3
The standard port number for SQL Server is 1433.
I need to connect to one that is running on a different one.
When I'm adding a new server it treats the Microsoft style port number specification (SERVERNAME,PORTNUMBER) as a list and tries adding two different servers.
The standard port specification (SERVERNAME:PORTNUMBER) is not accepted at all.
The documents do not reveal any info about this topic.
Any suggestions on how the port number can be specified as part of the server specification?
I need to connect to one that is running on a different one.
When I'm adding a new server it treats the Microsoft style port number specification (SERVERNAME,PORTNUMBER) as a list and tries adding two different servers.
The standard port specification (SERVERNAME:PORTNUMBER) is not accepted at all.
The documents do not reveal any info about this topic.
Any suggestions on how the port number can be specified as part of the server specification?
Comments
When you start adding SQL Server then you can click on the 'Edit properties' link. There is a port number option there. If you are already added the SQL Server then you can select the SQL Server and then use 'Edit credentials' option to change this.
Hope this helps.
Regards,
Priya
Project Manager
Red Gate Software