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

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

Surface Area Configuration for Features Connection Issues

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

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:

View Complete Post

More Related Resource Links

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???.

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

WCF issues sending large data - "An existing connection was forcibly closed by the remote host"

Hi Guys I have posted the following on www.asp.net but thought it might be productive posting here too.I have been pulling my hair out trying to fix an issue with sending data over WCF, I have read pretty much every THREAD on this forum regarding or similar to this issue without any successful solution.  I have a simple data object which has a [DataMember] with a data type of byte[]. I use this to send binary data from my web app as follows: Asp.net MVC website --> WCF Client (Has my Service References) --> My Services (MyServices.svc) --> Business/Data Tier Everything is being executed from within VS 2008 Pro.   Now I have successfully sent data up to 2.2MB, however it fails if i try and send a file such as 2.3MB or larger i get the following exceptions: General Exception Exception rethrown at [0]:    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)   at SoftApp.WCFClient.MyServiceReference.IMyService.Document_Save(DtoDocument dtoDocument, Int32 usercode)   at SoftApp.WCFClient.MyServiceReference.MyServiceClient.Document_Save(DtoDocument dtoDocument, Int32 usercode) in c:\dev\softapp\softapp.wcfclient\service references\myservicereference\refe

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.

SSIS Connection Configuration

Hello,   I have a bunch of packages that use different connections. I would like to put all these connections in the a sql config file and use only the needed connections for that package when executing. Right now when I run a package that doesn't use all the connections in the config table I get errors for all the other connections.   I would like to keep all the connections in one table for easy management, is this possible and even if the package does not use all the connections.   THanks, J

SSIS Excel Connection Manager Data Type Conversion Issues with SS Agent Job

Hi All! I have an issue I've been trying to fix but can't seem to figure it out. I was hoping a kind person would point me in the right direction. :o) I have an SSIS package that uses an excel connection manager source, and I want to run this package through a job scheduled in the SQL server agent. The data types for the excel file fields are 2 (DT_WSTR) and 5 (DT_R8). When I run the package directly through the SSIS package (VS solution) all of the data fields are properly imported into the database table. But...when I run this package through the SQL server agent job, ONLY the string (DT_WSTR) fields in each row are being imported, all of the float fields are imported as NULL. I set the data types for these float fields as "float" in the SQL server import table (data type). Even though the excel source float fields are indicating a type of DT_R8 in the excel connection manager and I set the data types in the SQL server table to "float", I also used the data conversion component and set the type to "float" as a fail-safe. I guess I should add to that the data access mode in the excel connection manager is using a custom code to select only those columns that I needed and to trim rows that I didn't need. Here's my code that I have in the excel source editor: select f1, f2, f3, f5, f6, f7, f8 from [mdo$] where f2 <> 'Rep Name'

Client Connection Issues

We are seeing a 1,000's of sql connection issues with the same message below from different IP's.  Any ideas on how to solve?   <   Record id="4057" type="RING_BUFFER_CONNECTIVITY" time="221730345"> <   ConnectivityTraceRecord> <   RecordType>LoginTimers</RecordType> <   Spid>0</Spid> <   SniConnectionId>AAA9B8C6-03CB-455F-959E-FBA1B0184B69</SniConnectionId> <   SniConsumerError>17830</SniConsumerError> <   SniProvider>7</SniProvider> <   State>11</State> <   RemoteHost></RemoteHost> <   RemotePort>31280</RemotePort> <   LocalHost></LocalHost> <   LocalPort>1433</LocalPort> <   RecordTime>9/7/2010 9:34:23.93</RecordTime> <   TdsBuffersInformation> <   TdsInputBufferError>10054</TdsInputBufferError> <   TdsOutputBufferError>0</TdsOutputBufferError> <   TdsInputBufferBytes>0</TdsInputBufferBytes> </   TdsBuffersInformation> <   LoginTimers> <   TotalLoginTimeInMilliseconds>5</TotalLoginTimeInMilliseconds> <   LoginTaskEnq

ADFS2.0 configuration issues


The ADFS2.0 is installed on my Window server 2008 R2 box.  The ADFS 2.0 is intalled too. However, when I get to Add relying Party trust wizard, it shows error. it indicates

" An error occurred during an attempt to read the federation metadata. Verify that the specified URL or host name is a valid federation metadata endpoint

Verify your proxy server setting.  ............................"


Bill Sun

n-tier, configuration info, specifically connection strings



I have an ASP.NET project which is pretty n-tier, by namespace, but I need to separate into three projects:  Data Layer, Middle Tier and Front End.

I am doing this because... 

A) It seems the right thing to do, and

B) I am having all sorts of problems running unit tests for ASP.NET hosted assemblies.

Anyway, my question is, where do you keep your config info?

Right now, for example, my middle tier classes (which uses Linq to SQL) automatically pull their connection string information from the web.config when instantiating a new data context.

If my data layer is in another project can/should it be using the web.config for configuration info?

If so, how will a unit test, (typically in a separate assembly) provide soch configuration info?

Thank you for your time!


Package configuration file with multiple connection strings


I am using the configuration file to read the connection string in the SSIS packages. In one of my packages i have to use two different connection strings. If i specify the second connection string in the config file, then the current package works well but other packages fails during validation saying the second connection manager does not exist in the package. Is it not possible to have multiple connection string in a single config file?

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

Package Configuration causing problems with Oracle Connection


Hi All,


We need to import the data from Oracle 10g database to SQL Server 2005 database.

Solution Picked:

In order to accomplish the above, we used SQL Server Integration Services along with Business Intelligence Developer Studio.


Base Details:

There are around 17 packages, each retrieving data from Oracle and storing into SQL Server based on current date. Following are the steps used:

  1. Get current date from SQL Server [Execute SQL Task].
  2. Create Query based on date obtained from step (1) [Script Task].
  3. Based on query obtained from step (2). Inside a [Data Flow Task] following sub actions are performed:

    Actions performed in [Data Flow Task]

  1. Retrieve data from Oracle database using query through [OLE DB Source].
  2. Perform any data modifications to correct the data [Derived Column].
  3. Store data in SQL Server [OLE DB Destination].
  4. Rejections are saved in text file [Flat File Destination].

The configuration of the Admi\Connection\TCP protocol in the SQL Instance is not valid


Hi, I have two node active/active dev cluster with 10 instances installed (sql 2005 dev edition 64bit SP3).  Each node hosts 5 instances. Every time I either move the group or  take it offline I get the following in my even log: The configuration of the AdminConnection\TCP protocol in the SQL instance instancename is not valid.  I checked the TCP/IP properties and all instances are using dynamic ports and all of them are different.  When I restarted SQLBrowser services I got the same alert for 9 instances.  Any suggestions on what to look next. 


New Language features in .NET4.0

The site explains the new features and enhancement to VB.NET and C# in .NET framework 4.0. The new enhancements are described in detail with examples and code snippets. One can easily understand the new features from this site. This is a must visit site for every .NET professional.

C# 3.0 new Features - Part 1

This article give you a brief description on the new features of C# 3.0 and make our life easier.

C# 3.0 new Features - Part 2

This articles describes the importance of Lambda Expressions.
This will reduce number of steps of code writing.
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