After Microsoft Sql Server 2012 Developer installation problem: MsiInstaller 1001/1004

Question

I installed MsSql from USB drive (wanted to save money on buying a dvd so i unpacked an image :-)). Installation went fine. Well in a meantime I messed a bit with drives, added a new partition, so my CD/DVD drive moved from D: letter to E: letter. After that my USB device become as F: and my system started to show such warnings (may be inacurate translation):

Product detection „{7842C220-6E9A-4D5A-AE70-0E138271F883}”, function „SDK_FNS” failed when requesting component „{30DC367C-77F2-4EB1-8661-7B2CC3714758}”.

Product detection „{7842C220-6E9A-4D5A-AE70-0E138271F883}”, function „SDK_FNS”, component „{30DC367C-77F2-4EB1-8661-7B2CC3714758}” failed.  „E:\” does not exist.

Product detection „{7842C220-6E9A-4D5A-AE70-0E138271F883}”, function „SDK_Full” failed when requesting component „{5459C63B-8203-43FD-9C96-9D643FD17EF0}”.

Product detection „{7842C220-6E9A-4D5A-AE70-0E138271F883}”, function „SDK_Full”, component „{5459C63B-8203-43FD-9C96-9D643FD17EF0}” failed.  „E:\” does not exist.

Any idea how to fix that path for MsInstaller?  Or how to find on that drive component with specified guid and install it manualy? 

I tried:

• Searching in system registry for E: and changing to F: but it didn't help.
• Switching manualy USB Drive to E: and moving DVD Drive to F: to let it install those components, but it didn't help.
• Installation repair.

Answer 1

Can you try to create new partitions so you have the exact number of partitions with drive letters when you start setup ? 

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 2

I can do that. I will remove mapping to the newly created partition, swap USB drive to E: and DVD drive to D: as it was when I installed MsSql. Actually I'm at work, will test it when I'm back.

But I don't want to keep this partition schema for lifetime.. so I need a solution which would remove this warning when I switch back to my desirable layout.

Answer 3

This solution will be searching thorugh registry for the guids i.e 7842C220-6E9A-4D5A-AE70-0E138271F883 and make sure that you replace the non existing drive letter by existing one.. but this is risky workaround before going this way I would try every possible solution first, even uninstalling and installing sql server from existing non removable drive letter, if you will go with the registry approach make sure to take backup first, also it will be great if you create OS restore point.

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 4

I alredy searched for 7842C220-6E9A-4D5A-AE70-0E138271F883 in registry and switched all non existing paths with current usb drive but it didn't help and nothing in warning string changed. So I assume that this path is not stored inside registry.

I even tried doing

Msiexec /f {7842C220-6E9A-4D5A-AE70-0E138271F883 } 

which did succesful repair.

But when I do

Msiexec /f {5459C63B-8203-43FD-9C96-9D643FD17EF0}

or 

Msiexec /i {5459C63B-8203-43FD-9C96-9D643FD17EF0}  

I get error with non existing component. So i think that solution would be to find what component (which .msi) is responsible for that guid and try to install it manualy.

Answer 5

Just to be clear, doing the registry fix _will not clear current warning_ but it will prevent them to be repeated after doing the fix.

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 6

Yes, I was writing about new logs..

Answer 7

So you still get warning for same Guids or different ones ?

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 8

About guids with wrong path to the "E:" drive. Nothing changed, not even drive letter in logs  (I changed every "E:" letter with current "F:" letter for USB drive, and logs are still showing wrong "E:" path). I tested it few days ago. So I think that path to install media is beeing stored somewhere else than registry.

Answer 9

I think you should changed the E with existing permanent drive, C for example. Also try to restart the service after this.

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 10

Great, but where to change. Changes in registry do nothing with that warning. 

I'm just curious, if I install it from dvd drive will I need to keep a dvd with Sql Server in drive for as long as I want to have it installed to prevent that warnings, lol?

Answer 11

No, this will not be the case, So can you try to uninstall and install from DVD or permanent drive ?

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 12

Ok I will try to run clean install from dvd. My main drive is SSD so don't have space for such expermients like keeping installation files ;-)

Answer 13

And the worse part of uninstalling it is that it doesn't have centralized uninstaller, so I need to remove each part of sql server manualy by add or remove features in controll panel. And it's a pain in a.. cause I have Vs2010 installed too, and some SQL parts are installed by it. 

Answer 14

Of course there is centralized uninstaller, can you try to run setup.exe /Action=Uninstall

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 15

Ok, I performed uninstall and installed it from dvd. Like for now I don't see any warnings as above, but let's wait few days.. then I'll mark it as anwsered.

Answer 16

OK, I marked anwser, other than you suggested. Correct anwser was a sugestion for isntalling it from dvd.. TIA! ;-)

Answer 17

Thanks :)

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.