6. července 2009 18:31OCS 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.
Didn't work. I found this article:
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.