Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlfan2
26 Posts |
 Posted - 2007-10-30 : 18:23:10
|
| I'm trying to setup SQL Server 2005 Express to communicate through a non standard port. I can connect to SQLServer on a remote machine using port 1433 when it is set as such but when I change the server to another port and try and connect using SSMSE I can't get through. I'm specifying the ip address and a colon followed by port number to connect.For example: 123.123.123.123:1234Any ideas?----------------------------------Standing on the shoulders of giants |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-30 : 22:44:35
|
| Should be: 123.123.123.123,1234 |
 |
|
|
sqlfan2
26 Posts |
Posted - 2007-10-31 : 13:53:36
|
| That solved the problem - many thanks!----------------------------------Standing on the shoulders of giants |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-31 : 14:10:49
|
| Non-standard ports should be greater than 10000 for security reasons. You could also add an alias so that you don't need to type in the port each time.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sqlfan2
26 Posts |
Posted - 2007-10-31 : 16:19:40
|
| Why would making the port > 10,000 make it more secure?How would I turn 123.123.123.123,1234 into an alias?Thanks for your help.----------------------------------Standing on the shoulders of giants |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-31 : 16:26:37
|
Because all lower number port are considered "system ports" and those are scanned first by the evil mob.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
sqlfan2
26 Posts |
Posted - 2007-10-31 : 19:01:00
|
| Is port a 16 bit integer? If so, is the largest value for a port 2^16 (65536)?(apologies for going off topic - I realize that ports have little to do with SQL)----------------------------------Standing on the shoulders of giants |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-31 : 22:45:40
|
| >> How would I turn 123.123.123.123,1234 into an alias?Create alias in sql configuration manager on client machine, choose tcp/ip protocol and use ip address as server name. |
|
|
|
sqlfan2
26 Posts |
Posted - 2007-11-01 : 00:03:55
|
| Thanks guys - much appreciated!----------------------------------Standing on the shoulders of giants |
|
|
|
|
|
|
Non standard port