Clean MOSS install: Error 5586 SQL Exception 15123

Just seen a weird error building a clean MOSS VM, running the config wizard after install resulting in a config DB being created but errors being logged.

 

The error refers to the setup routine not being able to set properties within SQL...

 

After a few minutes googling I found the following post from an MVP:

 

http://hinsua.blogspot.com/2008/03/error-5586-sql-exception-15123.html

 

This includes a SQL script to run (which errored due to slightly incorrect syntax), the updating and working script is shown below:

 

exec
sp_configure
'show advanced options', 1;
GO
RECONFIGURE
WITH
OVERRIDE;
GO
sp_configure
'allow updates', 0;
GO
RECONFIGURE
WITH
OVERRIDE;
GO 

 

Thanks Hector!