Altering settings on Surface Area Configuration generates this error: Alter failed. (Microsoft.SqlServer.Smo)

• sql-lover

  SSCoach

  Points: 18530

  More actions

  February 10, 2010 at 2:01 pm

  #138089

  Hi,

  Brand new sql2005 64bit installation on windows server 2003 64bit edition, SP2. When I go the Surface Area configuration to change something, I get the following error:

  TITLE: Surface Area Configuration

  ------------------------------

  Alter failed. (Microsoft.SqlServer.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Configuration&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

  Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

  I am using SQL2005 Ent edition with SP3.

  Any ideas?

  Thanks,

• sql_lock

  SSCrazy Eights

  Points: 9375

  More actions

  February 11, 2010 at 12:01 pm

  #1117698

  Try and install the Management Object from MS (XMO)

  http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en