|
|
|
Mr or Mrs. 500
 
Group: General Forum Members
Last Login: Wednesday, June 03, 2009 6:40 AM
Points: 505,
Visits: 405
|
|
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
------------------------------
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, June 23, 2009 9:17 AM
Points: 1,430,
Visits: 1,893
|
|
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
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, June 03, 2009 6:40 AM
Points: 505,
Visits: 405
|
|
Hi David,
This is a default instance NOT on a cluster Standard Edition with SP2 applied
thanks
Jeff
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, June 23, 2009 9:17 AM
Points: 1,430,
Visits: 1,893
|
|
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
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, June 03, 2009 6:40 AM
Points: 505,
Visits: 405
|
|
This is getting enjoyable....I am getting an error on that as well...see attached
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, June 23, 2009 9:17 AM
Points: 1,430,
Visits: 1,893
|
|
Googled the error. Does this work ?
http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx
Very fun.... :)
David
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, June 03, 2009 6:40 AM
Points: 505,
Visits: 405
|
|
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...
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, June 23, 2009 9:17 AM
Points: 1,430,
Visits: 1,893
|
|
Not sure why but my one dev server shows the file name sqlmgmproviderxpsp2up.mof.
David
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, June 03, 2009 6:40 AM
Points: 505,
Visits: 405
|
|
| Yes I have that but I do not have the sqlmgmprovider.mof file that is in the blog....
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, June 23, 2009 9:17 AM
Points: 1,430,
Visits: 1,893
|
|
Yeah, run it with the other. It can't get any more "not working" right? :)
David
|
|
|
|
