Friday, 06 August 2004

If you use SQL 2000 or MSDE on Windows XP, you'll want to do some research before you apply WinXP SP2.

Microsoft has provided a FAQ list that covers the bases pretty well. Excerpted from that page:

Q.  Why is Windows XP SP2 important to SQL Server customers?
A.  Windows XP SP2 will turn on the Windows Firewall by default. By turning on the Windows Firewall, computers are more resilient to attacks from worms similar to Blaster and Slammer.

Q.  How does Windows XP SP2 affect SQL Server?
A.  SQL Server will have access to the local subnet by means of file and print sharing, which will enable access to named pipes, also known as multi-protocol, that use Port 445. TCP/IP and UDP will be turned off by default. Applications that connect to a SQL Server database by means of a network will not be able to accept or make connections. This setting change helps protect the customer system by making it resilient to malicious worms that send port requests to a computer in an attempt to create a denial of service attack.

In addition, KB article 841249, "How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server," includes information about manual configuration of the SP2 firewall for use with SQL server, how to script configuration administratively, and troubleshooting tips and steps. Note that users of Windows Group Policy can also configure the firewall via that method using the new ADM files (which are included in the service pack).

I've been working with SP2 configuration via Windows domain Group Policy for a while now, with the beta versions. If you have the GPO option available to you, do yourself a huge favor and take advantage of it. Same goes for Office System settings - You can quickly, easily and effectively configure and maintain all your computers in one place.



Add/Read: Comments [0]
IT Security | Tech
Friday, 06 August 2004 21:00:55 (Pacific Standard Time, UTC-08:00)
#  Trackback

Referred by:
http://search.daum.net/ [Referral]
(www.google.com) [Referral]
Comments are closed.