2

We're in a holding pattern on this one right now, but I thought I'd poll folks for some added info in case this has happened to anyone else.

We have 2 SQL 2005 Enterprise servers on Win2K3 Std x64. We installed the MS08-040 patch last year and it ended up corrupting the master database on both servers. It looked from the logs like it was mistakenly replacing 64-bit server binaries with 32-bit binaries. MS PS said it was due to 32-bit client tools being installed on the server and told us to take the 32-bit tools out.

I completely removed the client tools from the servers and reran the patch with the same results. I've had to put them back because we need to use them in our apps.

Everything worked fine on our 32-bit installations and even on our 64-bit development server. Since I'm anticipating getting marching orders at some point to install SP3 (which includes this patch) I'm grasping at anything right now to see if we can get some more info on this. We've also implemented the workaround for MS09-004 (which replaces MS08-040) instead of installing it.

Has this happened to anyone else? If so, were you able to work through it?

Improve this question
2
  • Can you add any more detail as to what client tools can't be installed on the client workstation and must be on the server?
    – Jim B
    Jun 26, 2009 at 22:14
  • We have SSIS packages that run via SQL Agent jobs that interface with Excel. Because of the Excel bit we need to have the 32 bit tools.
    – squillman
    Jun 29, 2009 at 21:41

2 Answers 2

Reset to default
1

Yes, I have experienced this also on a deployment machine. After the patch of SP3 the SSIS stuff is completely broken amongst a few other things.

We are planning to re-install the entire server and migrate the databases over to a server that is PRE-installed with SP3.

We don't know what happened but I would expect that lots of people have had a similar issue.

Improve this answer
1
  • Yes, I think we're going this route also. We got a allowed variance from the powers that be to put the workaround for the patch in instead of running the actual patch. Actually, we'll probably just rebuild the server at some point with SQL 2008.
    – squillman
    Nov 1, 2009 at 19:06
0

did you install the 64 bit version of the patch? and it sounds like you have an x64 server install and x86 tools install.

Improve this answer
1
  • Yes, 64-bit patch. Some tools are 32-bit. We have multiple SSIS packages that interface with Excel, for example, and need the 32-bit client tools to do so.
    – squillman
    May 29, 2009 at 20:05

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .