Completely disable remote access to SQL Server

user_787856 0
Viewed 21489

I'm on the panic-mode. Today, when navigating to my website, I saw the website was down because of SQL Server timeouts (after an attack with million of login attempts.) ASP.Net pages can't be processed, because SQL Server requests just don't work.

Is there an on/off button for remote access in SQL Server 2008? I saw a lot of vague threads about adding firewall rules. I will never need to remotely access SQL Server, so I don't need to filter access, I just need to limit it to 127.0.0.1. Is this feasible?

remote-access sql-server-2008
4 Answers

Not to resurrect an old question but I recently came across this need myself. The remote connections button is server to server communications generally for executing stored procedures and such as mentioned in the previous post. In lieu of Firewall rules disabling TCP/IP and Named Pipes should prevent external connections if you are running SQL on a laptop for development purposes or a stand alone server and do not want SQL listening to any external ports.

user_99103560
Related