Post reply

Cannot enter Surface Area Configuration on a SQL instance

  • October 1, 2008 at 8:09 am

    #194276

    For one of my SQL server instance I cannot under any allowed user IDs open Surface Area Configuration.

    I get this error. If I click the link I get the 'were sorry no additional information on this error'

    TITLE: Surface Area Configuration

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

    Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC)

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

    ADDITIONAL INFORMATION:

    An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)

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

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

    Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

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

    The operation could not be completed. (WinMgmt)

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

    BUTTONS:

    OK

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

  • October 1, 2008 at 8:39 am

    #879514

    Is this a defualt (non named) instance on a cluster? If so, then it is a known bug. I don't have the link handy.

    Let me know if this is in fact the configuration. Thanks.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • October 1, 2008 at 8:44 am

    #879518

    Hi David,

    This is a default instance NOT on a cluster Standard Edition with SP2 applied

    thanks

    Jeff

  • October 1, 2008 at 9:14 am

    #879548

    Are you able to use Configuration Manager? If so, what are you trying to configure using Surface Area Configuration? You should be able to do all of that through standard configuration updates via T-SQL.

    Thanks for being patient.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • October 1, 2008 at 9:18 am

    #879551

    This is getting enjoyable....I am getting an error on that as well...see attached

  • October 1, 2008 at 9:21 am

    #879556

    Googled the error. Does this work ?

    http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx

    Very fun.... 🙂

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • October 1, 2008 at 9:27 am

    #879562

    You would think in a perfect world but after doing the command I still have the error..unsure what this blog means by the 'on servers' comment

    there is no sqlmgmprovider.mof on any of my SQL 2005 installations in that folder...

  • October 1, 2008 at 9:35 am

    #879567

    Not sure why but my one dev server shows the file name sqlmgmproviderxpsp2up.mof.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • October 1, 2008 at 9:37 am

    #879571

    Yes I have that but I do not have the sqlmgmprovider.mof file that is in the blog....

  • October 1, 2008 at 9:38 am

    #879573

    Yeah, run it with the other. It can't get any more "not working" right? 🙂

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • October 1, 2008 at 9:41 am

    #879575

    Curious, is there any other software installed on the system? In particular, I am wondering if the Windows Internal Database (aka SQL Server 2005 Embedded Edition) is installed on the server as well.

    😎

  • October 1, 2008 at 9:42 am

    #879578

    I did run the script for the sqlmgmproviderxpsp2up.mof and it ran but I still have the error...

    Thanks for the help if you have any other ideas send them my way..

  • October 1, 2008 at 9:43 am

    #879582

    Hi Lynn,

    Nope we only have one instance of SQL on this server. This is our ERP server and is dedicated only to our ERP software and SQL database installation

  • October 1, 2008 at 9:44 am

    #879585

    See Lynn's question. Very valid.

    Other than that it certainly seems like some reinstalling would be the next steps in order to get those working.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • October 1, 2008 at 9:49 am

    #879588

    By the way, did you get the "done" message at the end of the configuration run or did it fail?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply