When installing SCOM 2007 R2 Reporting Server on SQL 2008 R2 on a Windows Server 2008 R2 SP1 operating system, I have experienced a challenging error (value 3).
Somewhere in the middle of the installation, I received a error stating that the installation had failed and that I should look in the installation log file at the line before “value 3”.
When peeking in the log file, I was unable to find “value 3” anywhere.
So I started checking if I did the SQL Server installation correctly… which was correctly installed and configured.
Next up was the installation of SCOM itself… which was correctly installed and configured.
Then I started to rebuild the servers, just in case something went wrong and I had overlooked it… and the error was back again.
After some (more) searching over the the internet I got the impression that a “value 3” error is something of an <access denied> kind of error.
So I did the installation and configuration of the components and products correctly, but still the error remained.
2 weeks ago I’ve experienced an issue, also reporting “access denied” things, with SCVMM 2008 R2( Virtual Machine Manager cannot process the request because an error occurred while authenticating SRV-SCVMM-01.network.lan ).
Basically, the resolution to the SCVMM issue was not to have more than one dash “-” in the hostname.
That got me thinking… so I installed a SQL and SCOM server without a dash in the hostname… AND IT WORKED!
Resolution
When installing SCOM 2007 R2 Reporting Server, make sure the hostname does not contain more than one dash “-“ in it.