Menu
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?
406
Use SQL Server Management StudioRight-click the database to change, and then select Properties. In the Database Properties dialog box, select the Options page. From the Restrict Access option, select Single. If other users are connected to the database, an Open Connections message will appear.
Once you have SQL Express set up on your local computer, you can allow remote connections for members of your network.
Under Server Properties/Connections you can uncheck the
"Allow remote connections"
box.
186
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
