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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Cannot connect to SQL2005 Surface Area Configuration

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :Sql Server
 

Hello

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.

Thanks

Thomas




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

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)

------------------------------
ADDITIONAL INFORMATION:

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 connect to the configuration database.

  

hi,

when i open my central administation i get this error:

Cannot connect to the configuration database

 

plz help?


cannot connect to the configuration database

  

Hi All,

Recently I have migrated my SharePoint BackEnd (Database) Server to new hard drive. The reason of migration was to deploy and configure real time database replication by Symantec Veritas. After migration activity I was getting following error message

" cannot connect to the configuration database ".

But when I execute following steps, this errors message gone and everything got fine

1. Enable Named Pipe from SQL Server Configuration Manager > Protocols for MSSQLSERVER

2. Restart  SQL Server (MSSQLSERVER) service (Note: This service was already running and status was set to automatic ) and

3. Start SharePoint Configuration Wizard  

Now I need to know why every time I have to restart this service? When I turned on my sharepoint server machines in the moring I have to restart this service ( SQL Server (MSSQLSERVER) otherwise same error message appears (cannot connect to the configuration database). After restarting this service everything gets normal.

Any help in this regard will be greatly appreciated.

 


Cannot connect to the configuration database

  
After Installing Sharepoint 2010 i get "Cannot Connect to the Config Database" error. Im guessing this is a account access issue but i cant find anything detailing about it or what access is required? Anyone seen this? Cheers, Todd

Cannot connect to the configuration database after updating SQL SP3

  
hi, We're using WSS 3.0 with SQLExpress 2005. Because Symantec Backup Exec 2010 also install on this server, so I have to update to SQL Service Pack 3. But after updated to sql service pack 3 and installed Backup Exec 2010, I cannot connect to sharepoint. When I access to Central Administration, an error appears: "Cannot connect to the configuration database" I followed this instruction: http://support.microsoft.com/kb/823287 but the problem still persists. Does anyone know how to solve this problem? Thanks

Cannot connect to a configuration database after renaming Windows 7 computer

  

I have just recently installed a standalone instance of SharePoint 2010 on Windows 7 64-bit.  Everything was working fine, however, as part of joining my computer to the domain, my computer was renamed.  Now that the computer has been renamed, I am no longer able to connect to my locally installed SharePoint instance.  I receive an error message stating "Cannot connect to the configuration database."

I found this article on renaming a server for SharePoint Foundation: http://technet.microsoft.com/en-us/library/cc288510.aspx.  However, it seems like the article is assuming that the rename operation occurred while SharePoint was still running.  However, I am running SharePoint Portal Server 2010 and now that I cannot connect to the configuration database, I cannot make any alterations to the SharePoint instance at all.

In addition, my instance of SQL Server as well as the standalone SharePoint instance was installed prior to the computer rename.  What are the steps that are required to address this situation?

Thanks.


503 Service Error and Cannot connect to configuration database.

  

We have a brand new installation of Windows Server 2008 R2, SQL Server 2008 R2, and SharePoint 2010, and configuration of SharePoint 2010 at end of installation.

So far after all of this was installed the only thing we've accomplished so far is this:

Accessing the website:  503 Service Unavailable.
Accessing admin site:  503 Service Unavailable and/or Cannot connect to configuation database.

I've installed teh recommended hotfixes.  I've rebooted.  I've reconfigured to ensure it was hitting the right database and everything else.  Googled and searched here, ALL to no avail.

Suggestions?  I'm at my wits end and won't spend another second on what, but all appearances, is turning out to be a crappy product that our company spent thousands on.  I've had better luck (100% success) running just the services.

HELP!


Sharepoint 3.0 "Cannot connect to configuration database"

  
Hey guys, I am getting an error when i try and hit our sharepoint site. I get "cannot connect to configuration database" Can anyone please help me with this?
Thanks!
Adam

Dreaded "Cannot connect to the configuration database" error in WSS 3.0 after MS updates yesterday (

  

I know this has been a common issue in the past after updates, patches, SPs etc. Tried several of the online "cures" no luck. I've got a standalone instance of WSS 3.0. Anyone else with this issue after yesterday's updates? If so, any luck?

 

Update: ran WSS 3.0 configuration wizard, held my breath, and voila it worked!


Cannot connect to the configuration database - after IIS reset or machine reboot

  

After an IIS reset or rebooting the machine.  If I then open up a sharepoint website the message is Cannot connect to the configuration database. as detailed below

 

Server Error in '/' Application.


Cannot connect to the configuration database.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.SharePoint.WebPartPages.WebPartPageUserException: Cannot connect to the configuration database.

Source Error:

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

WSS 3.0 Error "Cannot Connect to the Configuration Database"

  

I tried re-running the configuration Wizard to no avail.  I can't even get to the Central Admin page.  When running the config wizard it tells me that it can't connect to the farm (it's a standalone install) and to disconnect from the farm to continue.  I disconnected from the farm and now it says that it can't get to the config database. 

Running psconfig -cmd upgrade -inplace b2b  and I get this error message:

No connection string to a WSS configuration database detected. 

I'm at a loss. 


Adding an SP 2010 server to an existing farm. "Failed to connect to the configuration database." dur

  

I have an existing sp 2010 enterprise server hosting websites and central administration.  I have a seperate sql 2008 r2 server holding the databases.  My goal is to setup another sp 2010 enterprise server to provide redundancy for the websites and central admin.  I believe I am able to accomplish this by adding another web front end to the farm.  On the second server, I install sp 2010, run the config wizard and connect to the config database located on the sql server, however, I am interrupted at step 3 when I am notified of the following:

Failed to connect to the configuration database.
An exception of type System.InvalidOperationException was thrown.  Additional exception information: There was an error encrypting or decrypting credentials. Either a credential update is currently being performed, or you must update the farm account credentials on this server before you can perform this task.
System.InvalidOperationException: There was an error encrypting or decrypting credentials. Either a credential update is currently being performed, or you must update the farm account credentials on this server before you can perform this task.
   at Microsoft.SharePoint.Administration.SPEncryptedString.CheckCredentialLock()
   at Microsoft.SharePoint.Administration.SPManagedAccount.Deploy(SPApplicat

Cannot connect to SQL2005 database

  

Hello

When I try to connect to an SQL2005 database I always get this 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)"

I found several articles about this - but the problem is still around.

Thanks

Thomas


cannot connect to configuration database

  

Hello,

  i installed sharepoint 2010 foundation on a vm but i later realized that the admin login to the VM had expired so i reset it.

 

On logging in , i got an error which had something to do with 'cannot connect to configuration database'.

could my admin password change have anything to do with it and how can i rectify it?


Categories: 
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