This is a pretty random issue we came across at my job but apparently this can happy with Windows 7. Users were randomly losing connection to their network share. It would tell them that the location is unavailable. We realized that the Offline files service in Windows 7 was running and for some reason it was causing their drive to go offline.
There is a simple solution for this. First, turn off and disable the ‘Offline Files’ service if you don’t plan on using it. Also, add the following registry key:
Create Key Name: FormatDatabase
Note: You don’t need to disable the service but there is no reason it should be running for desktop computers.
Warning: All cache files are deleted and unsynchronized data is lost. (applies to laptops that sync)
I came across this error the other day. I’ve installed SQL 2008 through 2012 without any real issues. Recently, I was trying to run the installer again so that I can add some features. I kept getting this message. It would even come up when I would try to do a change from Add/Remote Programs. I figured out the fix and it was pretty simple.
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\Resources\1033
Make sure you overwrite the file.
I recently installed Windows 8. I used my company’s MAK Key which is a volume license key. Everything installed just fine but I did notice it never asked me for my product key. On a domain, Windows 8 Enterprise automatically determines which servers to activate against using DNS. This helps with managing your volume license easily. Now, if you decide to do a 1 off install it will never activate correctly because it is missing the product key. This is easily resolved.
- Hit the Windows+R hotkeys to open the Run box and run: slui.exe 3
This will bring up the following window:
Enter your product key and then click Activate. You should be good to go!