Wednesday 31 December 2014

"ClassFactory cannot supply requested class" error with windows 7 and IE10.


When you click on a .html file in Windows Explorer on Windows 7, and get this error:

"ClassFactory cannot supply requested class"



Another software installation may be currupting or registering old version of ieproxy.dll. You could try Re-registering this ieproxy.dll again to see whether problem goes away.

To re-register follow the below steps.

1. Login to System as Administrator.
2. Go to command prompt.
3. Navigate to C:\Program Files\Internet Explorer for 32 bit.
4. Type regsvr32 ieproxy.dll and press Enter. It will register the ieproxy.dll with this confirmation:




5. Type regsvr32 actxprxy.dll. (Some times this dll also may get affected by some other application...Note: if this dll file is not in your IE folder it could be in C:\Windows\System32).
Again you get this confirmation:

6.  Restart the system.



If the problem persists, consider resetting Internet Explorer to its default configuration:
How to reset Internet Explorer settings
http://support.microsoft.com/kb/923737/en-us

Sunday 28 December 2014

Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. (SqlMgmt)

Trying to attach a database .MDF file via a newly installed SSMS (SQL Server Management Studio) and you get this dialog?

"Could not load file or assembly
'Microsoft.SqlServer.Sqm ..."


This FIX worked for  me:

Copy the file Microsoft.SqlServer.Sqm.dll located on
C:\Program Files\Microsoft SQL Server\100\Shared to folder
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE

Found here: Just a Reminder

Saturday 27 December 2014

"Warning 26003. MS Server 2008 R2 Setup Support Files cannot be uninstalled because the following products are installed: SQL Server 2008 R2 Common Files SQL Server 2008 R2 Database Engine Shared”




For many weeks I was stuck in SQL Server hell, and almost, nearly, resigned to having to wipe my hard drive clean, in order to get SQL Server to un-install and re-install successfully !!!






SQL Server un-install wizard kept on getting stuck halfway through the un-install process...asking for, but refusing to accept, the sqlsupport.msi file, even when pointing to a valid install location!


Until I found the answer to my woe (amazingly it works... Like a magic charm!)


Solution:
Save a file as "sql.reg" on your desktop with the following text (use copy-paste) shown in italics:


Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap]
"BootstrapDir"="C:\\Program Files\\Microsoft SQL Server\\100\\Setup Bootstrap\\"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap\Setup]
"PatchLevel"="10.50.1600.00"



After saving the file to desktop, double click the file and accept the dialog to merge this to your registry.

Then copy the following files from your installation folder to the location :

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2

Note: If you don't see these folders just create them with the exact name

What is to be copied:

folder: x64/x86/ia64 (depending on 64bit, 32bit or itanium architecture),

folder: resources

file: setup.exe

Now run setup.exe from your installation folder again. Your fresh installation should begin.

Hopefully this helps you too.

See : Only the good stuff