Is a SQL Server dynamically allocated port more "secure" than good old 1433?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spin - 05 Mar 2008 01:14 GMT

Gurus,

When you install a SQL Server 2005 Named Instance, it uses a dynamically
allocated port (as opposed to port 1433 in a default instance). Is this
more "secure"?

Signature

Spin

Reply to this Message

jason - 05 Mar 2008 01:28 GMT

Hi Spin,
Not really but if 1433 is open on the internet, bots will grind at the SA
password 24\7. It might take a little more trouble to find out the non
standard port but not much.

Signature

Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio

> Gurus,
>
> When you install a SQL Server 2005 Named Instance, it uses a dynamically
> allocated port (as opposed to port 1433 in a default instance). Is this
> more "secure"?

Reply to this Message

Linchi Shea - 06 Mar 2008 02:08 GMT

Maybe, but your security environment should be such that it shouldn't make a
difference. In other words, you shouldn't count on dynamic ports to give you
security.

Linchi

> Gurus,
>
> When you install a SQL Server 2005 Named Instance, it uses a dynamically
> allocated port (as opposed to port 1433 in a default instance). Is this
> more "secure"?

Reply to this Message