I am not an expert on the installation of SharePoint, but I have been trying to configure the MOSS installation on one of our DEV servers.
The first problem was found when trying to set up an SSP. The SSP was created OK but there was an issue with finding the SQL Report Viewer assemblies which are required to view the SSP admin pages.
My environments team have kindly looked into this and decided to completely re-install MOSS on that box.
I have tried to re-run the config wizard to hook this server up to the existing config database and to re-create the central admin site. However I now get a security exception when the config wizard is run.
These are the relevant lines from the config wizards log file:
05/05/2010 09:43:45 8 INF Creating connection string for admin content db SharePoint_AdminContent_1c2efc32-a7c8-4e97-93d6-447c3ea5cd29 server XXXXXXXX\lob
05/05/2010 09:43:45 8 INF Using NTLM for sql connection string
05/05/2010 09:43:45 8 INF Openning configdb so that I can join it at server XXXXXXXX\lob database XXX_SharePoint_Config in farm mode
05/05/2010 09:43:45 8 INF Now joining to farm at server XXXXXXXX\lob database XXX_SharePoint_Config
05/05/2010 09:43:47 8 ERR Task configdb has failed with an unknown exception
05/05/2010 09:43:47 8 ERR Exception: System.Security.SecurityException: Access denied.
The account that I am using as the central admin db access account has access to the config database (I have admin access so can check this) but I cannot ascertain if it has access to the existing admin content database.
Is this a known problem? Am I following a red herring with the db access? Is it worth blowing the whole configuration away and starting again?