SQL Server 2005 installation issue mscorlib.tlb

source:
http://support.microsoft.com/kb/918685

issue mscorlib.tlb could not be loaded;

Fix as per above (incase it is moved)

For SQL Server 2005

To work around this problem, you must manually specify the correct path of the Mscorlib.tlb file in the registry. To do this, follow these steps:

1. Click Start, click Run, type regedit, and then click OK.
2. Locate the following registry subkey:
   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell\TlbAutoRepair\mscorlib.tlb
   Notes
   • If you install SQL Server 2005 on 64-bit operating systems, locate the following registry subkey:
     HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\Tools\Shell\TlbAutoRepair\mscorlib.tlb
   • If you install SQL Server 2005 Express Edition with Advanced Services, locate the following registry subkey:
     HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb
3. In the right pane, double-click the registry entry TlbPath. The Edit String dialog box appears.
4. In the Value data box, replace %CLRVERSION% with the following value:
   v2.0.50727
   Note The value v2.0.50727 indicates the version of the .NET Framework that the original release version of SQL Server 2005 uses.
5. Click OK, and then exit Registry Editor.

Important If you install a SQL Server 2005 service pack or hotfix, the service pack or hotfix will change the value that you replace in step 4 back to %CLRVERSION%. If the problem that is described in this article still exists after you install the service pack or the hotfix, you must following these steps again to work around this problem.

Issue Printing to shared printer under asp.net crystal reports

Found by a colleague but really useful, .net application with crystal reports stopped printing with a new version of .net

http://support.microsoft.com/kb/184291/en-us