Symantec Management Platform (Notification Server)

 View Only
  • 1.  SQL error after apply SP3

    Posted Jan 27, 2009 12:26 PM
      |   view attached
    I just apply SP3 on my SQL 2005, then when I open the SQL Server Management console, it gave me the error, it say " The file c:\windows\microsoft.net\Framework\[] [] 4.[]\Mscorlib.tlb could not be loaded. An attempt to repair this condition failed because file could not be found. please reinstall this program.

    when I open the event viewer--> application, it show the Error
    .NET Runtime Optimization Service(clr_optimization_v2.0.50727_32)- Filed to compile: Microsoft. Reporting Service. QueryDesigners, Version = 9.0.242.0, Culture-neutral, PUblicKeyToken=89845dc8080cc91. Error code =0x80070002

    Can some one help me about this?

    Thanks.

    Lillian


  • 2.  RE: SQL error after apply SP3

    Posted Jan 27, 2009 02:07 PM
    .net 2.0 is required for SQL 2005, so it looks like something got corrupted with it. Try re-installing .net 2.0.


  • 3.  RE: SQL error after apply SP3

    Posted Jan 27, 2009 04:59 PM
    yeah as Jim Said repair or reinstall .Net 2.0.
    Are you still using .Net 1.1 on this server?
    http://www.devnewsgroups.net/g....tools/topic34748.aspx


  • 4.  RE: SQL error after apply SP3

    Posted Jan 28, 2009 04:47 AM
    Jim,

    I reinstall .NET2.0 but when I click my SQL Management console still have error show, please see the attachment

    I reboot the server after I install back .NET2.0

    " The file c:\windowss\Microsoft.NET\Framework\[][]4.[]\mscorlib.tlb could not be loaded. An Attempt to repair this condition faled because the file could not be found.

    Please reinstall this program.



    Thanks.

    Lillian


  • 5.  RE: SQL error after apply SP3

    Posted Jan 28, 2009 05:26 AM


  • 6.  RE: SQL error after apply SP3

    Posted Jan 28, 2009 09:39 AM
    Thanks, this fix my problem, all I did just following the instruction.
    here is what I did
    replace%CLRVERSION% to v2.0.50727 in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Miscrosoft sQL Server\90\Tools\Shell\TlbAutoRepair\Mscorlib.tlb

    when done I open the SQL management console without any error without reboot the server.
    then I change back to %CLRVERSION%.

    then I open the SQL Management consle, still work.

    I do not know when I reboot the server, this error will come back or not

    Thanks.

    Lillian