locked
OCS 2007 (Non-R2) Archive Installation RRS feed

  • Question

  • OCS 2007 Standard Front-End
    SQL Server running SQL 2005 SP2
    OCS 2007 Archive server (no databases locally)

    All servers running 2003 R2 x86.

    When I try to activate the archive server and point to the SQL server for the database, I get the following error:

    Connecting to SQL Server on SQL1
    Error attempting to validate the SQL server: reconfigure statement failed. This SQL instance has pending configuration changes that need to be resolved before installation can continue.
    [Microsoft][ODBC SQL Server Driver][SQL Server]Ad hoc update to system catalogs is not supported.
    I found this article:
    http://msdn.microsoft.com/en-us/library/aa269875(VS.60).aspx
    Didn't work.  I found this article:
    http://support.microsoft.com/kb/937304
    It referenced the previous article and it still doesn't work.  I can't get past this. 

    I have the SQL-DMO components installed on both the SQL server and the archive server.  MSMQ is installed on all three servers.  Don't know why it is failing.  Please advise. 

    Thanks.

    Gus
    Gus
    Monday, July 6, 2009 6:29 PM

Answers

  • Paolo helped me in another newsgroup to figure it out.  Regardless of what googling around says, you need to type the following in SQL:

    sp_configure 'allow updates', '0'


    Gus
    • Marked as answer by Gus D Tuesday, July 7, 2009 3:01 PM
    Tuesday, July 7, 2009 3:01 PM