Stop SQL Server listening on Remote Ports

Question

How do I 'lock down' my SQL Server 2005 installation to not listen on remote ports?

My SQL Server 2005 database instances are only used locally on the machine, so I want to prevent it listening on remote ports for security purposes, but do not want to do it via a firewall.

Any ideas?

score 2 · Answer 1 · answered Aug 04 '11 at 11:03

2

In SQL Client Configuration manager, see the section on SQL Native Client Configuration.

In the Client Protocols, disable all but "Shared Memory".

You may also have firewall ports open for port 1433 (if you had the TCP/IP client protocol). These could be disabled too.

answered Aug 04 '11 at 11:03

Jon Egerton

40,401
11
97
129

Effectively this is reverting to the initial config that you get in SQL express. – Jon Egerton Aug 04 '11 at 11:04
Cheers, I haven't forgotten this question, I just haven't had the time to test your suggestion! – FrinkTheBrave Sep 04 '11 at 18:48

score 2 · Answer 2 · answered Aug 04 '11 at 11:07

2

You can also turn off remote connections in SQL Server Management Studio

enter image description here

answered Aug 04 '11 at 11:07

Antony Scott

21,690
12
62
94

1

Cheers, I haven't forgotten this question, I just haven't had the time to test your suggestion! – FrinkTheBrave Sep 04 '11 at 18:48

Stop SQL Server listening on Remote Ports

2 Answers2