September 22, 2008 at 8:33 am
Well I'm screwed 🙂
I installed Hotfix_KB954606 on my dev server. It worked just fine. I waited a few days and checked again, all good.
I go to install it on my production SQL 2005 server, and it starts having issues.
The install took a good period of time 20 minutes or so AND Reporting Services went offline.
So I rebooted and reporting services is back online again, which is good, but now my error log is a mess.
I was greated with all these treats:
Installation Failure: Windows failed to install the following update with error 0x80070643: Security Update for SQL Server 2005 Service Pack 2 (KB954606).
DCOM got error "The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. " attempting to start the service MsDtsServer with arguments "" in order to run the server:
{ABF05265-635E-44B0-A28F-AEA45247ACA0}
and I get this error every few minutes:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
...HELP!!! 🙂
Also my IIS server hit an SSPI conext issue when I logged onto one of the ASP.NET web apps. It was just the default page, not one that pulls data from SQL Server, but it still had that SSPI context error.
After I restarted the IIS server it works fine now, but it still does NOT make me happy that it had an issue in the first place.
September 22, 2008 at 8:37 am
Not trying to pass the buck on this one but the errors seem pretty unique and due to the fact that you are on a production system I would escalate immediately to MS. I'm sure they call would be well worthwhile and they will be able to take that information back to the development team to avoid future issues.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 22, 2008 at 8:52 am
I am HAPPY to do so 🙂
Everything appears to be working fine, but errors ARE errors...
(Also the .NET errors have stopped in the event log, but that still does NOT fill me with confidence)
How do I contact Microsoft (I've never done this before)?
Are you talking their tech support line or like filing a bug report?
September 22, 2008 at 9:22 am
I would recommend calling Tech Support rather than posting something on the site. The contact information and prices can be found at this page - http://support.microsoft.com/?LN=en-us&scid=gp%3Ben-us%3Bofferprophone&x=10&y=5
It would be really nice if you were able to post a synopsis of what your findings were once things get completed in case anyone has a similar issue. Thanks in advance. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 22, 2008 at 9:51 am
Well the sad fact of the matter is, I don't think I'll get the cost of the call approved by management (don't ask, don't try to convince me... you're preaching to the choir here).
Though I'll still run it up the flag pole so to speak.
Any other resources I can try?
Maybe technet or MSDN forums?
🙁
Also no further errors have appeared in the event log... which is a bit odd I think.
---
I did find this in the install log for the hotfix though which is interesting:
Product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB954606_sqlrun_sql.msp.log
Error Number : 29538
Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: d:\SQLServer\distmdl1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
---
Though SQL Server service account had full rights to that folder and I was logged in as the admin and had full admin rights to everything...
September 22, 2008 at 10:17 am
Yeah, that stinks. So with that being said, I wonder if that error is due to the file permissions on that data / log file being inherited from a previous location. I have seen this before when databases have been detached from one location / server and reattached on the server being patched (one of our SE's showed me this problem / resolution). For some reason it never inherits the folder permissions properly. To reapply you should be able to go to the folder where that file resides, right click, select properties, select the security tab, select the advanced button and on that screen ensure that permissions are appropriate. Once you are sure that the permissions are appropriate select the bottom check box "Replace permissions on all child objects...." and select Apply.
Unfortunately you will have to reapply the hotfix.
I will poke around through the errors that you posted some more to see if there is anything else that I can find.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 22, 2008 at 11:16 am
Thank you for the help, I do appreciate it.
I will also be sure to apply the permissions to all the objects inside the folder.
That is interesting that it would do that, but I can see how that would explain the issue.
September 22, 2008 at 11:24 am
If you're having issues after installing a patch typically the call to MS PSS is a free one. Obviously you'd want to run it up through management first in case they all fo a sudden start asking for a credit card number, but for the most part they're free.
Also, If you have an MSDN or Action Pack subscription you get a couple of "free" support calls included with the cost of your subscription each year.
-Luke.
September 22, 2008 at 11:26 am
Luke L (9/22/2008)
If you're having issues after installing a patch typically the call to MS PSS is a free one. Obviously you'd want to run it up through management first in case they all fo a sudden start asking for a credit card number, but for the most part they're free.Also, If you have an MSDN or Action Pack subscription you get a couple of "free" support calls included with the cost of your subscription each year.
-Luke.
That's good to know about it possibly being free for patch installation issues.
I requested an MSDN sub on multiple occasions but it was denied. Which is unfortunate for oh so many reasons.
The free calls would have been great, or the 48 hour response time on their forums...
September 22, 2008 at 11:42 am
Yeah I've used the free calls as justification for my MSDN subscriptions in quite a few companies I've worked for. If they won't buck up for a full Blown MSDN subscription, check into the Action Pack. https://partner.microsoft.com/global/40009735 You get a slightly more limited choice of software, but it's a goodish bit cheaper.
All you have to do is become a registered partner, which is free, and meet a few qualification guidelines. The Action Pack Plus package also comes with free support incidents (I think 2 per year but don't quote me). Depending on how your company is setup, your IT group may provide 3rd party solutions to your Accounting group for instance.
-Luke.
September 22, 2008 at 2:19 pm
are your distmdl files in the same location as your master database files? If they are not this can cause patches to fail.
there have been posts on this on this site previously.
if you dont have replication these files are not in use so you can just move to the correct location via explorer
HTH
---------------------------------------------------------------------
September 23, 2008 at 7:02 am
george sibbald (9/22/2008)
are your distmdl files in the same location as your master database files? If they are not this can cause patches to fail.there have been posts on this on this site previously.
if you dont have replication these files are not in use so you can just move to the correct location via explorer
HTH
I'm not going to lie to you, I don't even know what those are.
So I'm going to bet good money they are NOT since I moved my database files to a different array than what the OS is installed on.
Now I see distmdl.mdf and distmdl.ldf and they are both in the default install location.
So you are saying I can just move these files?
What do they do? (Going Googling right now myself...)
September 23, 2008 at 7:39 am
Maxer (9/23/2008)
george sibbald (9/22/2008)
are your distmdl files in the same location as your master database files? If they are not this can cause patches to fail.there have been posts on this on this site previously.
if you dont have replication these files are not in use so you can just move to the correct location via explorer
HTH
I'm not going to lie to you, I don't even know what those are.
So I'm going to bet good money they are NOT since I moved my database files to a different array than what the OS is installed on.
Now I see distmdl.mdf and distmdl.ldf and they are both in the default install location.
So you are saying I can just move these files?
What do they do? (Going Googling right now myself...)
yes you can just move them to the location you now have your other system database files. or copy them if you prefer.
the files act as a 'model' database for the distribution database if you set up relication. Until that point they are not actually in use by SQL, which is why you can move them just using explorer.
---------------------------------------------------------------------
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply