Completely disable remote access to SQL Server

sql-server-2008 remote-access
Léon Pelletier picture Léon Pelletier · Aug 16, 2012 · Viewed 19.1k times · Source

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?

Answer

davek picture davek · Aug 16, 2012

Under Server Properties/Connections you can uncheck the

"Allow remote connections"

box.

Related questions

Sql Server 2008 remote access problem

I have problem with connecting to Sql Server from my local machine. Seems like I did everything I could, but still I'm unable to connect to it. This is what I did: 1) Right click on Sql Server in Sql Management …

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More