[Webinar] Streamline your web hosting managementRegister Today


"Cannot Connect to Configuration Database" SharePoint 2010

Posted on 2011-07-05
Medium Priority
Last Modified: 2012-08-13
I have been trying to successfully install SharePoint 2010 on a Windows Server 2008 R2 (HOUSE-2K10MOSS01) and SQL 2008 R2 on a separate Windows Server 2008 R2 (WAMR-2K08SQL01). I've tried multiple times installing SharePoint 2010 multiple times but I keep running into the same problem. Here's the order of operations:

1) I configured SQL on the first server, configured the firewall for the appropriate 1443 port on both servers and installed SharePoint 2010 on the MOSSServer. Initially, I was getting errors with the SharePoint configuration wizard when I tried to configure portion where the SQL Server \ database and user account to configure the SQL database. Initially, I was using just the computer name (WAMR-2K08SQL01), but it never completed successfully. I found I could get it to move forward and identified correctly  if I used the fully qualified domain and dns name (WAMR-2K08SQL01.domain."com".

2) Once it would complete and I got a successful completion message I'd run the command line "iisreset" then click "Finish" where the Central Administration then tries to open. Even though everything ran aand completes successfully the Central administration page never connects and instead simply says "Cannot connect to configuration database".

3) After trying this several times I decided to have a DNS entry created to help the identification of the SQL server . The new DNS entry identifies the machine by it's fully qualified DNS name (WAMR-MOSSSQL.Domain..."com")

4) I have then tried to re-install using the SharePoint configuration wizard. I've tried other names, but again it will only connect if I use the fully qualified DNS name. So when I start the configuration wizard,  I get an error, though it completed successfully previously. I get an error message and a log file (I've attached below). The error is "Failed to detect if this server is joined to a server farm...." If I click OK, and press "Next" again, it does NOT give me the error message and instead finds the SQL server configuration and again will complete successfully.

5) I then restart IIS, click finish and again I get the "Cannot connect to the configuration database".

6) I then have checked Event Viewer to see if I can get any more information. I found the following error: "Cannot connect to SQL Server "WAMR-2K08SQL01\HOUSEMOSSSQL" not found. Additional error information from SQL Server is included below. Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

I've tried different commands to change the timeout period but I'm not sure if I have the correct command since it never completes successfully. After over a week of trying different options, and everything I can think of I'm now looking for help to get this completed so I can finaly get passed these errors and begin configuring SharePoint Central Administration and begin installing my SharePoint application for my office.

Any help would be very much appreciated. Thanks.

SharePoint Wizard 1 SharePoint Wizard 2 SharePoint Wizard 3 SharePoint Wizard 4 SharePoint Wizard 5 SharePoint Wizard 6 SharePoint Wizard 7 SharePoint Wizard 8 SharePoint Wizard 9 SharePoint Wizard 10
Question by:theoclark
  • 2
  • 2

Expert Comment

ID: 36135025
try this to test and confirm connectivity.

Open notepad. Save the file with the name "testConnection.udl"
The ".uld" part is important as we are going to test it using this connection file.

Double click on that file and it should open "Data Link Properties" window

 Data Link Properties Window
On the next tab - "Connection", enter your SQL instance name and then try to fetch database from the drop down on the same screen.

If it fails, then there is a problem with either
SQL service

If the data link window returned the database names, then the account with you are running the PSConfig wizard does not have "DBCreator" and "SecurityAdmin" rights in SQL.

Expert Comment

ID: 36135029
Small typo in the above command.
File extension is ".UDL" and not ".ULD".

Also, in the data link properties window, make sure you select connector for SQL Server as shown in the screenshot.

Author Comment

ID: 36140277
Amolghanwat thanks for you help. When I do what you instructed me, here is what happens.

First I created the .UDL file as you instructed, saved it to my documents folder. I open the file, selected the Microsoft OLE DB Provider for SQL Server. I then when to connection, and I simply clicked the drow down menu where I can select the SQL Server name and database. One note, the Server and Database name are not fully qualified with the domain extension on it.

I then type in the username of the SharePoint Administrator, that I also used in setting up SQL and added as a SQL Administrator during that setup. After entering that  information, and I know I have it correct because I'm logged into the computer with the MOSS Admin Account using the same account and password. When I go to select the database name I get the following 2 errors.

 Login Failed Cannot Retrieve

If I simply click the "Use Windows NT Integrated security." which if I understand it correctly is using the account of the locally logged in computer which is the same MOSSAdmin account, I'm able to select the database from the drop down list.

 NT Retrieve
Next  if I test the link using Windows NT, it connects successfully.

NT Success
I imagine I need to look at my permissions but before I do that, am I correct in that using NT it's essentially connecting as my local user, in this case the MOSS Admin. How could that be or am I wrong in my thinking. Let me know your thoughts and what I should do next. Thanks.


Accepted Solution

rick_rs earned 2000 total points
ID: 36261850
Firstly, go into your Database Server and opne the configuration Manager of the SQL Server Installed, I believe you are using a named instanc eof SQL Server and not the default one. Create and Alias name for the SQL Server and grant the MOSS Admin Account DB Creator and DB Owner permissions to SQL Server.
Then, go to your Application server and ping the new ALias name (you just created) using command Prompt  type : PING <Alias Name>.
If it returns back a response very good Proceed to step 2.
If not, uninstall SQL server from the DB server and re-install it but this time use the default Instance name and again create an Alias name and ping it from the App Server.Then go to Step 3
Step 2: Using stsadm in the app server,change the name of the SQL server SharePoint is pointing to usig this command stsadm.exe -o setconfigdb -databaseserver ServerName -farmuser MyUserName – farmpassword MyPassword. Then run the Farm Cinfiguration Wizard.
-Step 3:If you are ok till here, then you are ready to perform the next step.delete the central admin website and run the farm configuration wizard.

Author Comment

ID: 36563506
Their information was helpful for me to find out what really the problem.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question