January 12, 2011 at 8:57 am
ooooooooo So if my webserver on ip xxx needs access, I should on my sql server only allow ip xxx. If it is on one machine I would still only allow xxx since people connecting would be using ip xxx??? correct???
Right now my setup is my nonprofit, 3 computers 1 server. My server houses the sites and sql server. I have not restricted any use so I guess my sql server is fully exposed to the internet right now.
January 12, 2011 at 1:34 pm
Chances are if you have your SQL Server allowing remote connections, it is exposed.
In the firewall, you want to allow connections to 1433 TCP on your SQL Server, ONLY from the webserver IP. That will lock things down.
If you need help, you might post something on a site like this: http://forums.devshed.com/networking-help-109/ or engage a local consultant for a short time.
January 12, 2011 at 1:38 pm
Thank you very much for all your help, I am going to lock my server down first then I will attempt to tackle my service issue, but this may just fix that as well.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply