.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

Unable to connect to the SQL content database from sharepoint web front server.

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :SharePoint


SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

when ever these errors occur in eventvwr sharepoint will not work.

Please suggest on this issue.

waiting for MS replies..






View Complete Post

More Related Resource Links

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

Unable To Connect Database Error:Sharepoint 2007 Internet Site.

Hi Techies,  we are running 4farm Sharepoint internet site. now a days we are getting the below error very regularly. Event Viewer :The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SPPREPROD02VMDK\SPPREDPROD.  Check the database connection information and make sure that the database server is running.. Sharepoint Logs:#50071 :#50071: Unable to connect to the database SharePoint_Config on pfc-penndb-tst. Check the database connection information and make sure that the database server is running.. Please Advice . Regards, raju.  Nag: http://nagaraju-sharepoint.blogspot.com. Posting is provided with no warranties.

PowerPivot Report is unable to connect database after uploading onto SharePoint 2010


Hi All,

I have developed one PowerPivot Report in excel 2010 and uploaded into SharePoint 2010. The report has slicers and filters which are working pretty well in excel 2010.

I'm able to open the report through sharepoint browser and  if click on any slicer getting the following error.

An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh:

Also i'm unable to see the filter on the report.

I have got some info on google regarding 'Claims to windows token service' should up and run. But, i'm still getting the same after enabling 'Claims to windows token service' as well.

Please help me in this regard.

Thanks & Regards,


unable to save data in SQL Server database through Sharepoint 2007


Hi All,

I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.

Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.

Can some one have idea on this. Please help me to get it done

Thanks in Advance.

Unable to connect to SQL Server Database


Hi All,

I actually tried all of posted, at least over here, regarding installing Service Level Dashboard V2 on a WSS 3.0 stand-alone server, which I would use with SCOM 2007 R2, and all didn't work; I tried stopping the "Server 2005 Embedded Edition (MICROSOFT##SSEE)" and set it manual, didn't work.

Like others, I installed all pre-reqs before WSS 3.0, fine, no issues until running the ServiceLevelDashboard_x86.msi. I checked permission pertaining to the account used to run and connect to the Operations Manager Data Warehouse Server, local admin. The weird thing is I used the same steps that had been used to set these up on a testingserver, which was running fine. Now that we need to set these up on a production server. But those steps wouldn't work any more?!

Any helps, hints, lessons are really appreciated

Here I go again. Unable to connect to SQL Server database.


I just recently decided to uninstall SQL Server 2008 Express Edition in favor of installing SQL Server 2008 R2 Express Edition. Now I can't access the "security.aspx" page via the ASP.NET Configuration icon. Clicking it yields the following error. "Unable to connect to SQL Server database."  My guess is that the account that Visual Web Developer Express 2008 edition is launching to "attempt" to create the default ASPNETDB.MDF file in the App_Data folder does not have sufficient permissions to execute the command through the local SQL Server instance.


This is one of the most frustrating issues I have ever had to deal with.  I have no idea what is going on behind the scenes when I click on that "ASP.NET Configuration" icon because of the incredibly abstract error messages that Microsoft likes to dole out. It would be nice of Microsoft to tell me the exact name of the account that SQL Server is refusing. That would be kind of them. Maybe in a future version? Anyone who can explain the relationships to me between

1)Visual Web Developer Express Edition 2008

2)IIS Manager 7.0 and

3)SQL Server Express Edition

My questions:

What is the name of the user account that Visual Web Developer uses to try and create the ASPNETDB.MDF file in the App_Data folder of

Cannot connect to database master at SQL server at 'mumachinename\SharePoint

I do not have any experience in SharePoint. That is why, question maigt be not very smart. Try to install SharePoint server 2010 at Window 2008 server. All prerequisites have been installed. There is no SQL Server installed on this machine. When config wizard started, I got Error Cannot connect to database master at SQL server at 'mumachinename\SharePoint.The database might not exist, or the current user does not have permission to connect to it. Do I need to install SQL Server first on this machine?

Unable to connect to SQL Server 2008 R2 Database without being admin of the machine


I am receiving the following error when I try to connect to my new SQL Server 2008 R2 machine:


Msg 18452, Level 14, State 1, Server <server name>, Line 1 Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

I'm running the following command to test the connection:

sqlcmd -S<Server Name> -E -Q"Select @@servername"

On the server I'm getting the following from the SQL Server logs


03/31/2011 20:31:58,Logon,Unknown,Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT:]

03/31/2011 20:31:58,Logon,Unknown,Error: 18452<c/> Severity: 14<c/> State: 1.

03/31/2011 20:31:58,Logon,Unknown,SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT:]

03/31/2011 20:31:58,Logon,Unknown,Error: 17806<c/> Severity: 20<c/> State: 2.

What is odd is if I put the domain user in as Admin of the machine then it connects just fine.  I have tried just about everything I can find and I just cannot get it to work. Anyone have any clues???


unable to connect to database



I am using visual studio 2005 and sql server 2005.

I am developing a small quiz application and i have stored the connection string in app.config file which is given below.:

<?xml version="1.0" encoding="utf-8" ?>
        <add name="quizdb"
            connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Quiz Application.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
            providerName="System.Data.SqlClient" />
i have retrieved connection string property through configurationmanager class 

and when i m connecting to database  it gives me a runtime error:


Sql Exception was unhandled

System.Data.SqlClient.SqlException was unhandled
  Message="An attempt to attach an auto-named database for file F:\\Quiz\\Quiz\\bin\\Debug\\Quiz Application.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located

How to get access to content database after server hardware failure


Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.

Regards, thanks for help.

Victor Naranjo MCSE + Security MCSA + Security MCSE + Messaging MCSA + Messaging ITIL Certified Comptia Security+

need help about "Unable to connect to remote server." using HttpWebRequest


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Customizing the Content Query Web Part in SharePoint Server 2007

Walk through how to customize the Content Query Web Part in SharePoint Server 2007 to query content across multiple sites in a site collection and display the results in any way that XSL can support. Learn how to get similar results when customizing the CQWP does not meet your needs.

Best Practices for Content Types in SharePoint Server 2007 and Windows SharePoint Services 3.0

Learn best practices to develop, deploy, and manage custom content types, as well as scenarios for making updates to existing content types in lists.

Unable to Connect to server

I have install sql server 2008 on window 7. But connection to server is failed. These are the options. Sever Type Server Name. Authentication. Login. Pasword. anybody have answer my question????

Cannot connect Visio 2007 to SQL Server CE 3.5 database?

I am trying to reverse engineer a database (running under SQL Server CE 3.5 SP1) with Visio 2007 Professional.  I may be being blind, but I can find not way for Visio to do this.  Am I missing something or just piddling into the wind? Fully patched Vista. Thanks, Ed Bessant  

Unable to connect to the ASP.NET Development Server

 I have VS 2008 with SP1 installed on Win XP. I have .NET 3.5 with SP1 installed When I ran and opened an existing project for the first time, I got the below error WebDev.WebServer.exe has encountered a problem and needs to close. After this error, I continusly get  "Unable to connect to the ASP.NET Development Server." whenever I run the website. I checked the internet and ASP.NET forum and tried all the following Making port numbers auto assign Making it to a specific port number using the Custom web server Tried creating new web site and checking Replaced WebDev.WebServer.EXE after downloading it from a website My anti virus have not blocked any websites as such I tried resetting VS settings by running devenv /resetsettings Can any one help me, what else might be the problem? Thanks in advance
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