| Author |
Topic |
|
Pace
Constraint Violating Yak Guru
264 Posts |
 Posted - 2004-09-15 : 07:15:47
|
Hey all, I currently use SQL Server locally on machine to set up all the db's and transfer data so we can go live with sql server some time next month... My dedicated server is in the post along with my full software instead of the evaluation... All I wanted to know was has anyone had any problems when installing sp3a on sql server? Also I have heard rumours that XPSP2 creates problems connecting to sql server (client wise) due to the firewall... I know everything in IT is unique but im sure im not the only one who needs this info so if anyone has any experiences that they are willing to share it would be much appreciated. Regards,PACE  |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-15 : 07:41:07
|
| We haven't had any trouble using sp3a at all. I would make sure you have the following patches:SQL Server SP3aMDAC 2.7 SP1 Refresh (If you are using MDAC 2.7)Latest Windows Service PackMS03-031 (I think that's the right number. It's the patch that brings SQL Server to .818)You need to test for a week, but these are what everyone should be at.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2004-09-15 : 08:51:09
|
Thats a great help. Thanks you mean old dba  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-15 : 14:06:14
|
| Service pack 3a has a DTS bug in it, but security patch 818 fixes it.The XPSP2 thing is only if the SQL Server is running on an XP and users need to connect to it. Typically, SQL Server is only installed on XP for a developer and no one else connects to it. So you are fine in this scenario. And also typically, SQL Server is not installed on XP for production, test, QA, performance, etc... environments so you shouldn't run into a problem either. The client machines can be XP.Tara |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2004-09-16 : 04:43:38
|
Ahh this is the thing it will be going on a WS2003 system... eek I could be in some trouble then here  |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-16 : 04:59:10
|
| we're w2k3 and sql2k, we haven't experienced any problems yet... |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2004-09-16 : 05:07:29
|
| Ahh jen you life saver... thanks hun, does that include sp2 ? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-16 : 05:17:09
|
sp2 for what? sql2k run on win2k3 needs sp3a, else it won't work... |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2004-09-16 : 05:18:47
|
| Sorry I mean do your clients have XP SP 2 installed on their machines... I have downloaded that patch and im looking for the others that Derrick has suggested. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-16 : 05:27:49
|
we do have clients with xp but not with sp2, i believe it's still beta, and anything beta, IMHO, must be approached with caution and not for production...editnot to scare you, but had some trouble with the patch on my laptop, had to reinstall  |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2004-09-16 : 05:30:35
|
| I totally agree with you Jen, I wanted to leave it at least 2 month before we go with it but unfortunately I dont have the luxury... Oh well I guess its going to be me taking the plunge and letting you all know how it goes edit: no that is scary |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-20 : 12:51:42
|
| The clients running XP SP2 should not have problems when connecting to the SQL Server unless the OS of the SQL Server is XP and has SP2 installed.Tara |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2004-09-21 : 06:12:57
|
| Ahhh tara thank you! its server software so I should be fine then |
|
|
|
|
Patching