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 |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2010-01-15 : 17:55:20
|
| First, let me state, I know very little about firewalls. We have windows 2008 servers with sql 2008 installed on them. The servers have firewalls on them. In order to connect to the databases from other servers or workstations, I added inbound rules for the sql instance. This works alright, except when the server is rebooted, the rules have to be disabled and re-enabled for remote servers to be able to connect, even though they come up as 'enabled'. Is there anything that can be done where we won't have to do the 'disable and enable'? And maybe adding the rules wasn't the appropriate action to take in the first place. Again, I know little about firewalls. Any input is appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-17 : 10:29:36
|
| Same with us |
 |
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2010-01-19 : 08:41:40
|
| Thanks Tara and russell. I'll see if we can do that. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-19 : 10:13:58
|
| We configure our SQL boxes on a non-standard port - so that people / virus scanning ports don't (easily) find the servers.That takes care of a visiting consultant plugging his virus-infested notebook into the LAN etc. |
|
|
|
|
|
|
firewall question