Hotfix_KB954606- now my SQL Server's error log has .NET Runtime errors and I experienced SSPI context errors... HELP!

  • 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.

  • 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

  • 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?

  • 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

  • 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...

  • 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

  • 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.

  • 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.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • 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...

  • 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.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • 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

    ---------------------------------------------------------------------

  • 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...)

  • 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