I'm chopping away at completing my MSCE certification, and while working on the exercises in Administering Microsoft SQL Server 2102 Databases, I ran into a big problem, while doing Exercise 3 on page 49.
When attempting to do a command-line install of SQL Server 2012 on SQL 2008 R2 Server Core, the installation would fail with error -2147467261.
So here is the situation at hand: Server is virtualized, in a Hyper-V environment. Server is installed as an evaluation version of Microsoft Server 2008 R2 Enterprise, installed as Server Core. I've got the .iso for SQL Server 2012 Enterprise Edition mounted up on Drive D:
On the server, from the command line, I tried running the following script: from D:\
(Side note: the /SYSADMINACCOUNTS="CONTOSO\kim_akers" bit is used in the training environment exercises; it isn't mandatory.)
And this would run for a few minutes, display some SQL Server GUI bits, then die. The acutal error shown would be listed as SQL Error -2147467261. I tried a variety of suggested fixes online until I found one that worked. Now the part that worked wasn't what was described in the post, but rather, in one of the user comments. The fix works like this:
From the command prompt on the server, run Regedit.exe. This will launch Regedit. Add in the following key:
With this registry key in place, run the command-line SQL Server installation again. I did this, and finally, the installation ran successfully. Apparently that registry key is required by SQL Server 2012 Enterprise, but is not installed as part of Server Core.
Let the studies continue!