Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aminnagpure
Starting Member
3 Posts |
 Posted - 2014-10-09 : 10:00:20
|
recently i saw many login attacks on my sql server, it eat uped resources like anything
for the time being i have disabled, remote connection for my sql server
but i have other servers who connect to my sql server, and i want only them to be able to connect sql server, rest all denied
how can i do that
in sql server 2008 web edition r2
<a href='http://www.websol.co.in'>IT Jobs</a> |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-09 : 11:23:22
|
You can handle this at the firewall level so that the connections never make it to the database server. Contact your network admin for this.
Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
how do i allow only specific ip address to connect