CODEWITHSUNDEEP
sql-server-2005sql-server-2005-express
FrinkTheBrave
FrinkTheBrave

Reputation: 3958

Stop SQL Server listening on Remote Ports

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?

Upvotes: 0

Views: 1291

Answers (2)

Antony Scott
Antony Scott

Reputation: 21998

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

enter image description here

Upvotes: 2

Jon Egerton
Jon Egerton

Reputation: 41549

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.

Upvotes: 2

Related Questions