.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

About SQL surface area configuration manager

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
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???.

View Complete Post

More Related Resource Links

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.



Getting This Error When Trying to Use Surface Area Configuration Tool

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

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:

Cannot enable TCP/IP through the Configuration Manager

Hi, I am using SQL Server 2008 sp1 Developer Edition.  The database engine service is running and the SQL browser service is running. It is set to allow remote connections. When I open SQL Server Configuration Manager and expand the SQL Server Network Configuration mode and select Protocols for <server name>, it shows Shared Memory as Enabled and all others as Disabled. If I right click on TCP/IP and select Enable, I get a warning stating that the changes will be saved but will not take effect until after I restart the service. When I click OK on the warning popup to close it, it still shows TCP/IP as Disabled. After I restart the service I return to the Protocols screen and check the value of TCP/IP. It is still Disabled. I am still unable to connect to it remotely. Configuration Manager is not allowing me to enable TCP/IP. I need to do this. I looked for an alternate way to enable TCP/IP but have not been able to find one that works.  Any thoughts?

installed certifacate does not apear in dropdownlist in sql configuration manager

Although i have installed a certificate that meets all the requirement stated in http://support.microsoft.com/kb/316898 but it does not appear in certificate drop down list of certificate tab under the protocols for MSSQLSERVER properties window. the operating system is Windows XP sp3 ,SSL Diagnostics Version 1.1 is used to make the certificate the SQLserver service is running under localsystem  why is that?my second questions is i am using SQL mixed mode and i am afraid of sending clear password on the wire what measure i can do to avoid it? --yousef

SQL Server Configuration Manager Exception: 0x80010105

We're running SQL Server 2008 Standard edition version 10.0.2531.0 (SP1) 64-bit.  It is running on Windows Server 2008 R2. Whenever I connect to the SQL Server Configuration Manager, and look at the SQL Server Services, I get the message : The server threw an exception. [0x80010105]. Suggestions?Clint

SQL Server Configuration Manager: Connection to target machine could not be made in a timely fashion

I have a SQL Server 2005 box that was moved from a domain environment to a non-domain environment and was never dropped from its original domain before moving over.  Subsequently a new domain was created at the data center this SQL Server box now resides in.  The machine was dropped from its old domain and joined to the new one.   All the while the service accounts were set to the local admin account.  When I tried to start the Configuration Manager I got the message "Connection to target machine could not be made in a timely fashion.".  I read some blog entries and tried changing all the service accounts to Local System and the error message still came up.   All of the SQL Server services run fine.  It is just this management console that I cannot open.  I wasn't with this employer when this box was moved to the data center so I do not know if it worked prior and there isn't anyone here that could give me its history.   Any help would be appreciated.

SQL Server Configuration Manager - Protocol Name is blank

When I run SQL Server Configuration Manager (2008) and click on SQL Server Network Configuration and then Protocols for SQL, the right side of the screen shows the protocol icons and their status, but the names (TCP/IP, Shared Memory, Named Pipes, etc) are not there. Can someone tell me how to get the names to display again? They used to show up. A thought is that I installed XP SP3 and that made them go away, but I can't prove that.

Getting "Provider load failure" from SSRS Configuration Manager (SQL 2008 R2 Hot Fix CU3 did not fix

After upgrading our SQL 2008 cluster to R2, SSRS on one node works fine, but the second node will not allow connection via the Configuration Manager (getting "Provider load failure").  We've done re-installs, repairs and applied Hot Fix CU3, but the issue remains. NOTE: It's understood that SSRS is not a clustered resource.  We have it installed as separate instances on each of the two cluster nodes.

SQL Server Browser missing on SQL Configuration Manager

Hi guys! Strange Issue, after installing SQL Server 2008 R2 Std on a Windows 7 the SQL Server Browser is missing on SQL configuration manager, although the service appears on the services.msc console. Log on as an user authenticated with administrator priveleges. Firewall is off. Can you help me?      

SSRS 2008 configuration Manager - "Invalid Class"

Reporting Services Configuration Manager is throwing an error when I try to "Find" the server. The manager starts up and takes me to the "Reporting Services Configuration Connection" window. I click on the "Find" button (leaving the default comptuer name as-is; the local machine)  and get the error message "Invalid Class" with the title "Reporting Services Configuration Manager".

I've been searching around the interner and only found one forum post with a similar problem to my own. It was on this forum and the advice seemed to be pointing towards a problem with WMI, but it seemed that the user never found a solution. I've downloaded and ran the WMI diagnostics program and the log does contain quite a few warnings, but I don't know how to go about solving most of them. I did run regsvr32 on some dll files though :)

I won't post any logs yet, as I have no idea where the problem may be based. Please advise and I will post the required information.

Report Server Instance not shown in SQL 2008 R2 version for Configuration Manager



I am using Windows Server 2003. I have installed SQL Server 2005 and SQL 2008 R2 version in the machine. The sql server 2008 R2 version has the instance name as SQL2008R2

I am trying to configure "Reporting services Configuration Manager" for the SQL 2008 r2. I gave the machine name and hit the Find button, I am not able to get the Report server instance name.

But when I gave the server name, i am able to browse to the folders page in the Internet explorer. so the server is available . I gave like this in the IE, and I am able to see the page:

http://Server IP/Reports_SQL2008R2/Pages/Folder.aspx

In the eventvwr, I found the following errror "The Drive:\Program Files\Microsoft SQL Server\MSRS10_50.SQL2008R2\Reporting Services\ReportServer\RSReportServer.config file failed to load. This error may occur if the XML is not valid. "

How to get the Report server instance name in the configuration manager.

Thank you

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

WMI error has occurred when using report configuration manager


I Installed SQL Server 2005 Standard Edition with Reporting Services.

When i open report configuration manager and try to connect,  i found the following error:

Reporting Services Configuration Manager: kashif-pc\SQLKashif

"Unhandled exception has occured in your application. If you click continue, the pplication will ignore this error and attempt to continue. .....................

A WMI error has occurred and no additonal error information is available.

for details:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A)
   at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
   at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
   at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
   --- End of inner exception stack trace ---
   at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
   at ReportServicesConfigUI.WMIProvide

VS 2010: Configuration Manager: my ONLY choice is "Any PC"; no option for x86, x64


I'm on Windows 7, x64, with Visual Studio 2010.

I have an ASP.NET page with C#.  The C# makes a call to PowerShell, it fails, and every post I can find via Google says the solution is simple --- set your Target Build to x86.  Sounds awesome, except I can't.  My only choice is "Any PC", and even if I add a new configuration and call it "x86", I can't apply it to my Project.

SQL Express 2005 Configuration Manager - Cannot connect to WMI provider

Hi, when I go to the SQL Server Configuration Manager utility, the following error pops up :

Cannot connect to WMI provider.You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager.
Access is denied. [0x80070005]

This is on a Windows 2003 SP1 server, and the database is an upgraded MSDE 2000 database. The database itself appears to be working OK. My application can connect to it, I can connect to it via sqlcmd, etc. (all locally). I'm logged on as an Administrator, so permissions shouldn't be a problem.

I ran FileMon to see which file it's complaining about, and it seems the culprit is sqlmgmprovider.dll. It's trying to access this .dll as Network Service. Just to check, I added Network Service to the .dll permissions and got a slightly different message :

Cannot connect to WMI provider.You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager.
The application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. [0x800736b1]

I now also get two errors in the event log :

Secure or a Security Hole, hardening your Area


I've consoldated Levi's post on my blog entry Secure or a Security Hole, hardening your Area

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