May 14, 2004 at 12:51 am
What i should notice if update XP (which can be workstation who uses SQL server from other machine or be workgroup's server with MSDE).
With XP SP2 come "Major security updates" Those words scare me.
Unfortunately I miss "MSDN Webcast: SQL Server and Windows XP SP2
-Esa-
May 14, 2004 at 9:36 am
Not that I know of, but I plan on doing some sp2 testing on a VM over the next few weeks. Will let you know how it goes.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 21, 2004 at 12:13 am
Well... this is my test result:
Nothing changes if XP SP2 is Workstation and use database (and programs) from domain server or other work group computer (W2K etc)
but if XP SP2 is MSDE or SQL Serveri (personal edition) or file server then you must make small changes to Windows Firewall (SP2 install new Windows Firewall and TURN IT ON)
1.Disable Widows Firewall (turn off from Local Area Connection Properties -> Advanced) or
2.From Local Area Connection Properties -> Advanced -> Settings -> Exceptions Set File and Printer Sharing On (that open TCP ports 193, 445 ja UPD ports 137, 138. those ports enable Folder/File share and enable client to ask SQL instance from LAN)
-Esa-
May 21, 2004 at 7:42 am
That is possible that the firewall needs to be changed. SQL Server communicates on 1433 and 1434, so you might need them opened. Are you accessing the SQL server on the workstation FROM the LAN? Or are you accessing locally? I wouldn't think that it's blocked locally.
Is this XP Pro, SP2 BETA or XP Home?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 21, 2004 at 8:43 am
There might be some issues due to the XP firewall installed as a part of SP2, check out the following Q Articles...
http://support.microsoft.com/default.aspx?scid=kb;en-us;841251
http://support.microsoft.com/default.aspx?scid=kb;en-us;841252
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply