.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Getting This Error When Trying to Use Surface Area Configuration Tool

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
My environment is SQL 2005 Enterprise x86 SP2 running on Windows 2003 Server x64 SP2

This environment will be a new production environment if I can get this problem solved, so any help will be appreciated.

This is the error:


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

Program Location:

   at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ExecProcess(Object request)
   at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ProcessRequest(Request req)
   at Microsoft.SqlServer.Management.Smo.Wmi.WmiSmoObject.EnumChildren(String childTypeName, WmiCollectionBase coll)
   at Microsoft.SqlServer.Management.Smo.Wmi.ServiceCollection.InitializeChildCollection()
   at Microsoft.SqlServer.Management.Smo.Wmi.ServiceCollection.get_Count()
   at Microsoft.SqlSac.MainPanel.For

View Complete Post

More Related Resource Links

Error with ASP.NET Configuration Tool


I'm trying to make an MVC 2 site, and I've run into a bit of a snag.  I want to add user roles to my system via the configuration tool, but every time I click the Security tab I get the following error:

"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Could not load type 'HandiGamer.MvcApplication'."

When I click on the 'Choose Data Store' button, it tells me I'm already using AspNetSqlProvider.

I have a .mdf file for the rest of the site's db, but didn't make any tables for membership as I thought all of that would be handled by the configuration tool.

Am I missing a step?

About SQL surface area configuration manager

Hi everybody, i have a problem in installing microsoft sql server 2005 , and i countered a problem login , i tried to solve this problem , but i found that the SQL surface area configuration manager not listed in the menu of the configuration tools. i tried to install/uninstall the sql server many times... but it doesn't solving the problem. please anybody can help me???.

sql server surface area error


Hi all

I am trying to configure the surface area of sql server 2005 for the remote connections but when i am trying to do so I encountered the following error

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:

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


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


I tried by installing SP2 package but nothing worked out. The SQL Server is installed on my machine i.e on localhost.

Please help m

Cannot connect to SQL2005 Surface Area Configuration



When I try to open the SQL2005 Surface Area Configuration I always get the following error:

"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)"

This is a big problem since I can no longer change SQL-server communication settings.



Surface Area Configuration for Features Connection Issues


I have a full SQL Server 2005 installation (default instance "MSSQLServer") plus an instance named "Microsoft##SSEE" (I believe a Sharepoint admin database instance).  I need to configure the features on the default instance.  When I try to open up Surface Area Configuration for Features for the local host, I get the message below.  The message does not provide anything of value.  What is going on and how am I supposed to administer this server?  Am I missing something obvious.

Thanks in advance,

Greg Wilkerson


TITLE: Surface Area Configuration

Failed to connect to server localhost\MICROSOFT##SSEE. (Microsoft.SqlServer.ConnectionInfo)


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click:

Weird security configuration error message


Recently something has gone wrong with our website so that whenever you try to access an aspx file, it shows the following error:


Server Error in '/RALSWeb' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Access is denied: 'RalsWeb'.

Source Error:

Line 256:                <add assembly="System.EnterpriseServices, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 257:                <add assembly="System.Web.Mobile, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 258:                <add assembly="*"/>
Line 259:            </assemblies>

Configuration Tool


I'm fairly new to ASP.NET and I'm trying to think of the best way to implement my first dynamic website. I've noticed the ASP.NET Configuration tool and it seems quite useful but I have a few questions:

1. Can this page be accessed when the website goes live or is it best to make your own?

2. Can this tool handle custom SQL databases or must everything be built into the default one?

3. Can this tool be setup for local use initially and then changed for the hosting server details later on?

The website I'm build will have user account features, with a news and articles section which the user will be able to interact with. So I need to create a database to handle this. However I don't know whether to completely ignore this tool and just make everything custom or try and incorporate that into the ASP.NET Configuration tool. Also, if everything is made custom can you still use the membership tool in visual studio? Thanks for any help :) 

Custom tool error: Failed to generate code for the service reference 'CompanyService'. Please che


A little background because I feel I have an out of the ordinary architecture in place and don't know if this is contributing to the problem. 

We have an existing ASP.net application that is undergoing expansion.  The new functionality is all written in Silverlight 4.  As part of that expansion I gutted all the old Linq to SQL and put Entity Framework 4 into place.  To do this I created a standard .net Class Library and added my edmx files there.  Naturally, the business entities created by this cannot be used in Silverlight.  So I created a Silverlight Class Library and added all the business entities to that Silverlight Class Library as linked files.  I changed the name space to be the same.

So I have the following assembly / namespaces

Company.Project.Dal.csproj / Company.Project.Entities (.net 4 class library)

Company.Project.Entities.csproj / Company.Project.Entities (SL4 class library)

With this architecture I was able to share my business entities with my SL enabled web services, my asp.net projects, my silverlight projects.  Really it's a beautiful thing.

Once this was done I added "message" classes to Company.Project.Dal and again shared them with the other entites using linked files.  These messages are things like MyObjectRequest; they are class

MOSS 2007 configuration error


Hi Experts,

I installed sharepoint 2007 successfully but while configure the sharepoint it gives following error:

The following services may have to be started or reset during configuration:

1. internet Information services

2.Sharepoint Adminstration services

3.Sharepoint Timer service

But already run ISS in my server. how can i solve this problem

Specific Error Handler for Area Controllers



I have an area named CMS on my MVC3 Preview 1 application.

Is it possible to have an error view inside the CMS area to display only errors that occurred on the controllers under the CMS area?

Basically I want the errors inside the area to be handled by a different controller than the errors on the "application root".



Error in Step 8 of Share point configuration wizard

HI Team,        I am getting an error in step 8 of Share point Configuration wizard, Its running for ever its running in the step 8 for ever later i need to kill the configuration wizard Please advise Thanks Kumar

Sharepoint 2010 COnfiguration Wizard Error Step 3 of 10

I am trying to install Sharepoint 2010 on a Windows 2008 R2 Hyper V Instance.  The database is SQL Server 2008 R2.  All them are RTM I am getting this error Failed to Create the configuration Database An exception of type Syste.InvalidCastException was thrown.  Additional exception information: Unable to cast object of type "Microsoft.IdentityModel.Configuration.MicrosoftIdentityModelSection' to type "Microsoft.IdentityModel.Configuration.MicrosoftIdentityModelSection' to diagnose the problem, review the logs at so after reviewing the logs this is what I find Resource retrieved id PostSetupConfigurationFailedEventLog is Configuration of SharePoint Products failed.   This is the error from the event logs Log Name:      Application Source:        SharePoint 2010 Products Configuration Wizard Date:          4/26/2010 11:30:09 PM Event ID:      104 Task Category: None Level:         Error Keywords:      Classic User:          N/A Computer:      jedicouncil.endor.local Description: Failed to create the configuration database. An exception of type System.InvalidCastException was thrown. 

when used with other Tags gives Error in Configuration

Hi,I am using appsettings to store some key-value pairs to be used in my application.I am also using log4net, a logging ToolHence for log4net to work i need to add below tag into the app.config file along with <appSettings>. <?   xml version="1.0" encoding="utf-8" ?><configuration><appSettings><add key="path" value="C:\\localhost.txt"/></appSettings><log4net><appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender"><file value="C:\temp\calleguas\DataUpdateLogger.log" /><appendToFile value="true" /><rollingStyle value="Size" /><maxSizeRollBackups value="10" /><maximumFileSize value="1000KB" /><staticLogFileName value="true" /><layout type="log4net.Layout.PatternLayout"><param name="ConversionPattern" value="%d{dd MMM yyyy HH:mm:ss} %-5p - %m%n" /></layout></appender><root><level value="Error" />Use Info value for any debugging purpose only<appender-ref ref="RollingFileAppender" /><appender-ref ref="ColoredConsoleAppender" /></root></log4net></configuration>When i remove the log4net tag then only the appSetting values can be retrie

Error in step 5 - Sharepoint 2010 Configuration Wizard

I can't proced througt the step 5 of the configuration wiz.I have installed in a VM.Please, i need some help.. The error: After installing the Sharepoint Search Server in the wizard. Gives the following exception. Failed to register SharePoint services. An exception of type System.ServiceProcess.TimeoutException was thrown. Additional exception information: Time out has expired and the operation has not been completed. System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed. at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout) at Microsoft.SharePoint.Win32.SPAdvApi32.StartService(String strServiceName) at Microsoft.SharePoint.Administration.SPWindowsServiceInstance.Start() at Microsoft.SharePoint.Administration.SPWindowsServiceInstance.Provision(Boolean start) at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Provision() at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInstanceInConfigDB(Boolean provisionTheServiceInstanceToo, String serviceInstanceRegistryKeyName, Object sharepointServiceObject) at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInstances(Boolean provisionTheServiceInstancesToo, String serviceRegistryKeyName, Object sharepointServiceObject) at Microsoft.SharePoint.PostSetupConfiguration

SMS reporting server configuration error: The MemoryLimit Element is not a configuration file elemen

Attempting to configure reporting services for SCCM 2007 SP2 R2. Installed SQL Standard 2008 reporting services. Attempting to configure reporting services, but service will not start w/ error: System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.    at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)    at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start) Digging into Reporting Services logs reveals: rshost!rshost!1900!09/08/2010-14:50:25:: i INFO: CLR runtime is initialized. rshost!rshost!1900!09/08/2010-14:50:25:: i INFO: Derived memory configuration based on physical memory as 16775112 KB appdomainmanager!DefaultDomain!1b54!09/08/2010-14:50:25:: i INFO: Entered managed ServiceMain in DefaultDomain. configmanager!DefaultDomain!5ac!09/08/2010-14:50:26:: e ERROR: Error loading configuration file: The configuration file contains an element that is not valid. The MemoryLimit element is not a configuration file element. library!DefaultDomain!5ac!09/08/2010-14:50:26:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: , Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.&nb

ASP.net Web Site Administration Tool. An error was encountered. Please return to the previous page a

I have just installed Visual Studio 2010 trial. Previously I have been using Visual Studio Web Developer 2010 Express. Now every time I try to invoke the ASP.net Cofiguration tool either via the icon or through the Project File Menu item, I get the error message "An error was encountered. Please return to the previous page and try again." I am trying to develop a bog standard Silverlight Business Application. There are no other diagnostics. Is there anywhere I can look for more clues or anything else to do to alleviate the problem? or is this something peculiar to the trial version I am using?   I also think it might have something to do with the fact that I have created this Silverlight Business App on a directory on my D: drive and not the normal, default c: drive path and maybe the web sit admin tool is looking somewhere else. Could this have something to do with it? If so what is my remedy?   Help please.....

Ajax tool kit version error

Hi, I have downloaded AjaxToolkit version 3.5 from this asp.net site and unzipped it and attached to my tools. I tried to add Calendar control to my application while running application I am getting this bellow error. It says Ajax version 4 to use, I dont understand how to solve this. I am using VS 2008 with Framworks 3.5  but I dont know why it is asking to run Ajax 4.0 scripts. Any Idea how to solve this?   "Microsoft JScript runtime error: AjaxControlToolkit requires ASP.NET Ajax 4.0 scripts. Ensure the correct version of the scripts are referenced. If you are using an ASP.NET ScriptManager, switch to the ToolkitScriptManager in AjaxControlToolkit.dll. "   thanks  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend