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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2004-08-16 : 06:17:26
|
| I know that this might be a little on the side but I read somewhere in here that XP SP2 had some issues with SQL server. I'm considering the upgrade but I would like to know if anyone's tried it and if they could come up with some recomandations. I'm the only developer in my company and I'm really not prepared to have any issues right now...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
pjn
Starting Member
27 Posts |
Posted - 2004-08-16 : 09:31:14
|
| I'd be interested to hear this as well. I'd also read somewhere that there are problems but I've yet to notice any side-effects both here and at work.I did start looking around on the net for an answer but got side-tracked!It might just be the fact that Windows Firewall won't let traffic through by default. All the tools seem to work fine for me. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-17 : 06:57:04
|
| I *think* the issue is that it will bar access to "personal SQL" running on XP workstations.That's a gross oversimplification!, but Pucker SQL Server is not going to be running on XP (is it?) so remains uneffected.Only today we found a client with a stack of PCs with MSDE installed [no SP3] collapsing under a Slammer attack. I have no idea if they need MSDE on each worksation, but.Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-17 : 07:14:35
|
| Kristen, we rolled out a corporate policy. NOBODY is allowed to have ANY version of SQL Server or any database software without approval from the DBA group. If they install it, they get a nice little note from us and it magically disappears. The company saw the sense in this very quickly after things like Slammer. You might want to consider it. :) It's made our lives so much easier here.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-17 : 07:46:54
|
| Hell no. Much better to charge the client for the consultancy to fix the problem. Unfortunately, from a budgetary standpoint, they will still learn the lesson over time. (Perhaps I should have said "a client found us<g>")Now if it was an internal issue ...Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-17 : 08:03:28
|
| Well, whenever you need me to consult for a weekend or so, let me know. :) I'm itching for an opportunity to visit the UK. Actually, I wouldn't want to work. Any contract would need that part included.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-17 : 08:14:35
|
| You'd fit right in. All the people I employ do no work. Me included. The UK is like that (well, except where elwoos works ...)Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-17 : 12:15:52
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38549Tara |
|
|
|
|
|
|
|
|
XP SP2 known issues?