Microsoft KB Archive/937304

= Error message when you use the Communications Server 2007 Enterprise Edition LcsCmd.exe command-line tool together with the /removepool switch to remove the pool: &quot;Error removing the pool&quot; =

Article ID: 937304

Article Last Modified on 8/15/2007

-

APPLIES TO


 * Microsoft Office Communications Server 2007 Enterprise Edition
 * Microsoft Office Communications Server 2007 Standard Edition

-



SYMPTOMS
When you use the Microsoft Office Communications Server 2007 Enterprise Edition LcsCmd.exe command-line tool together with the /removepool switch to remove the pool, the removal process is incomplete. Additionally, you receive the following error message:

Error removing the pool:

Script Command Line: cscript.exe //U &quot;Y:\dbsetup\PoolCfgDbSetup.wsf&quot; /dbexists /sqlserver:&quot;< >&quot; /sqlfilepath:&quot;Y:\dbsetup&quot;

Script Output: Microsoft (R) Windows Script Host Version 5.6 Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

Connecting to SQL Server on . 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.



CAUSE
If the server that is running Microsoft SQL Server is configured by using non-standard values, the PoolCfgDbSetup.wsf script will produce the error when the Global.SqlDmo.ExecuteImmediate (&quot;reconfigure&quot;, 0) command is issued.



RESOLUTION
To resolve this issue, follow these steps:  Log on to the instance of SQL Server as a member of the sysadmin fixed server role or the serveradmin fixed server role. Open SQL Server Management Studio or SQL Query Analyzer, and then create a new query. Make sure that you connect to the master database.  In the query window, run the following statements. RECONFIGURE WITH OVERRIDE GO The RECONFIGURE WITH OVERRIDE command may take several minutes to finish. The time depends on the state of the server that is running SQL Server.  Use the LcsCmd.exe command-line tool together with the /removepool switch to remove the pool.



MORE INFORMATION
The Microsoft Windows PoolCfgDbSetup.wsf scripting file uses the current version of the SQL Server database management objects to issue the Global.SqlDmo.ExecuteImmediate (&quot;reconfigure&quot;, 0) command. This will enable the script in the next commands to reconfigure the standard configuration values for the server that is running SQL Server. This resembles an SQL transact RECONFIGURE command. For more information, refer to the current version of SQL Server Books Online.

Additional query words: OCS 2007, SQL Server 2000, SQL Server 2005 Pool, LcsCmd, SRX070219600762

Keywords: kbexpertiseinter kbtshoot kberrmsg kbprb KB937304

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.