SQL Server - Turning the firewall on
Asked By tnt
18-Nov-09 03:58 PM
Hello,
I have a windows 2003 sp2 hosting sql 2005 Ent sp2. I like to turn on
firewall.
Do use the exception to allow certain ports or do I allow the program to be
accessed.
I have clients on other machines connecting to his database server. I think
name pipe is needed. Not sure.
tnt
SQL Server
(1)
Exception
(1)
Database
(1)
Firewall
(1)
Windows
(1)
Sp2
(1)
Erland Sommarskog replied to tnt
tnt (tnt@) writes:
I would use exceptions to open the port that SQL Server is listening on.
But I am not a security expert. Maybe it is better to ask in a security forum.
--
Erland Sommarskog, SQL Server MVP, esquel@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
MSDE on Windows 2003 R2 box, new DL385G6 - Install Fails during SQL Services SQL Server I have been finding that I am having trouble with the Crystal Reports Server XI installation failing when it is dealing with SQL. So, as a thought and in case there was something wrong with my SQL portion of the isntall. I thought ok, I will try installing the actual MSDE application direct from Microsoft. So, I downloaded the MSDE for SQL 2000 (which is msde2000a.exe), set my switches and off to the races. It quit seconds left to the installation and bombed with the same errors as the Crystal Reports Server install. The error is the same whether I try to install MSDE by itself or
SQL Server 2005 on Windows Server 2008 - sqlcmd can not connect SQL Server SQL Server 2005 SP2 (9.0.3068) installed on Windows Server 2008 Enterprise. When I installed SQL Server I specified a "named instance" with the name
SQL SERVER SQL SERVER to MS ACCESS. SQL Server Looking for recommendatsion. I need to convert a SQL Server database to a MS Access database. Are there any utilities that will copy everything, including
Cannot create linked server from SQL 2005 to SQL 2000 SQL Server I need to set up a linked server on SQL Server 2005 so that a SQL Server authentication account with limited privileges can access an SQL
Restart SQL server programmatically or with T-SQL SQL Server How can I restart the SQL Server Service using T-SQL or Programmatically using C#, is there a way? Thanks!!! SQL Server Discussions SQL Server (1