Connect to SQL using SSMS and non-default port?

Question

Post reply

Connect to SQL using SSMS and non-default port?

Steven Cuthbertson

Mr or Mrs. 500

Points: 578
More actions
July 16, 2007 at 3:31 am

#196975

Hi:
Can anyone help me? I have changed the default port on my SQL 2005 to 14333 to avoid hacking attempts, but cannot figure out how to connect to it now using SSMS & SQL Auth. Client has an application that needs to connect to it over the Internet using plain authentication. Port 14333 is open according to shields up on grc.com. Have tried using <IP Address>:port in SSMS over TCP/IP. Is this correct?
Cheers, Scuthber

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

In your case it should be SQL2005,14333

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 2

Servername,portnumber

should do for you.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Steven Cuthbertson Mr or Mrs. 500 Points: 578 More actions · Answer 3

Thanks! I'm at another customer now, but I'll try ASAP.

Steven Cuthbertson Mr or Mrs. 500 Points: 578 More actions · Answer 4

Update: Yep, works fine. Must have done something right for a change. Thanks

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 5

If you wish you dont want to use the servername,portnumber everytime you connect then you can create a alais and use the alais nmae to cll your sql server.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com