Enabling Windows Server 2008 Firewall to block SQL Server Access

[Jeff Carrington]

I just inherited a Windows Server Standard 2008 sp2 (64 bit) machine. I
installed SQL Server 2008 Standard. Now I want to block outside access to
the database. I enabled the firewall and deleted all rules related to port
1433 and the sqlserver.exe file. However I am still able to connect to the
database from a remote machine. Does anyone know what else I need to do to
block the access?

I really appreciate any and all help on this....
--
Jeff Carrington
Mgr. IT Operations
NPD Group

[Erland Sommarskog]

Jeff Carrington (JeffCar...@discussions.microsoft.com) writes:
> I just inherited a Windows Server Standard 2008 sp2 (64 bit) machine. I
> installed SQL Server 2008 Standard. Now I want to block outside access
> to the database. I enabled the firewall and deleted all rules related
> to port 1433 and the sqlserver.exe file. However I am still able to
> connect to the database from a remote machine. Does anyone know what
> else I need to do to block the access?

If you only want to permit access to SQL Server from that very machine,
the simplest is to open SQL Configuration Manager, go to the server
protocols node, and disable all but Shared Memory and restart the server.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx