Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

SharePoint Failed to connect to the database server

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

SharePoint Failed to connect to the database server

Postby chicagotech » Wed Mar 05, 2008 11:41 pm

After installed Office SharePoint 2007 on SBS 2003, I receive the following message when running SharePoint Products and Technologies Configuration Wizard:

Failed to connect to the database server or the database name does not exist. Ensure the database exists, is a SQL server, and that you have the appropriate permission to access the database server.

Then I found the SQLagent didn’t start, I started it manually. However, I still receive the same error. Any suggestions?

I have tried the KB901203 and removed the quotation marks. Attached is the log.
By checking the Config wizard log, I found the following erroneous entry:

02/13/2008 21:31:22 1 ERR An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings
SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Based on my experience, this error message usually occurs if the backend SQL Server doesn't allow remote connection. If the backend SQL Server is located on a different server from the MOSS 2007 server, I
suggest you refer to the following KB article to eliminate the problem.

How to configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/kb/914277/en-us

If SQL Server and MOSS 2007 server are on the same server, please let me know the installation mode you selected when you install MOSS 2007 server. Is it a standalone installation or a Server Farm installation
mode?
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6704
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Postby chicagotech » Wed Mar 05, 2008 11:42 pm

I thought when I performed a Basic installation, SQL Server 2005 Express
Edition should be installed automatically. How do you check to make sure SQL
Server 2005 Express Edition is running?

I suggest we perform the following steps to check the status of the backend SQL Server Express instance: OfficeServers.

In the command link, input "SQLCMD -E -S .\officeservers" (without quotation marks). Can you see the >1 prompt? If not, we need to check the following points:

1. In the Services management console, ensure the SQL Server (OFFSERVERs) service is started.

2. Check if the Shared Memory protocol is enabled.

a. Click Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager¡£
b. Expand SQL Server 2005 Network Configuration, click Protocols for OFFSERVERS.
c. In the right pane, make sure the "Shared Memory" protocol is enabled.
d. Expand SQL Native Client Configuration, click Client Protocols.
e. Ensure the Shared Memory is Enabled.

After that, please run SharePoint Products and Technologies Configuration Wizard again to see if the issue can be resolved.

If the "SQLCMD -E -S .\officeservers" is unsuccessful, it is very likely that there is a corrupted configuration database. You can create a new configuration database by running the following command:

1. In the command line, locate to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin.

2. Run the command below:

psconfig -cmd configdb -create -database <uniquename>

For example: psconfig -cmd configdb -create -database MOSS_Config.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6704
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Postby chicagotech » Wed Mar 05, 2008 11:43 pm

I don't have SQLCMD. The below is the message.

C:\Documents and Settings\Administrator>SQLCMD -E -S .\officeservers
'SQLCMD' is not recognized as an internal or external command,
operable program or batch file.

C:\>dir sqlcmd /s
Volume in drive C has no label.
Volume Serial Number is 2855-2C24
File Not Found

Also, I don't have SQL server in the services. I have only
SQLAgent$SharePoint running.

According to this symptom, the MS SQL Server Express edition was
not installed successfully. I suggest we follow the steps below to uninstall MOSS 2007 and the SQL Server Express edition.

1. Go to Add/Remove program in Control Panel.
2. Uninstall Microsoft Office SharePoint Server 2007.
3. And then, uninstall Microsoft SQL Server 2005 in the Add/Remove program.

Please restart the server and reinstall Microsoft Office SharePoint Server 2007 in Standalone installation to see if the issue disappears.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6704
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Postby chicagotech » Wed Mar 05, 2008 11:44 pm

I just found my SBS server doesn't meet the Office SharePoint requirement. I
have only 500MB RAM and two 1.33 MHz processors. Do you think that is the
problem?

After removed the Office SharePoint 2007 from the SBS, I can't access
http://companyweb/. It display:
You are not authorized to view this page
If I go to Manage your company intranet web site in the Internet Web site
under server management, I receive this error.
Server Error in '/' Application.
--------------------------------------------------------------------------------


The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its
dependencies) could have been removed, had its name changed, or is
temporarily unavailable. Please review the following URL and make sure that
it is spelled correctly.

Requested Url: /_layouts/1033/settings.aspx


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300
I have tried to run CEICW and KB823379.
You receive a "Server Error in '/' Application. Access to the path
...Describes how you receive an error message and you cannot log on to
SharePoint Services installed on a domain controller by using a correct user
name and ...
support.microsoft.com/kb/823379

Help.

Based on my experience, this issue could be caused by the problematic virtual server settings. Please follow the steps below to resolve this issue.

Suggestion 1: Check the ASP.net version on the companyweb
=========
1. In the IIS manager, right click companyweb and click properties.
2. On the ASP.net tab, ensure 1.1.4322 is selected.

If the vesion is correct, let's go ahead to rebuild the companyweb site.

Suggestion 2: Rebuild the companyweb site
===========
Step 1: Check the content database name
----------------------------------------------------
1. Open WSS Central Administration site.
2. Click Configure Virtual Server settings.
3. Click Companyweb.
4. Click Manage continent database under Virtual Server Management.
5. Write down the content database name of company web. By default, it is STS_SBSSERVER_1

Step 2: Remove Companyweb from virtual server
----------------------------------------------------------
1. Go back to Companyweb's Virtual Server settings.
2. Click Remove Windows SharePoint Services from virtual server.
3. DO NOT select "Remove delete content database" and click OK. *

Step 3: Go to IIS manager to remote Companyweb and recreate one
-------------------------------------------------------------
1. Open IIS Manager and delete the IIS website: companyweb.
2. Re-create an IIS website. In the port number line, leave it default: 80. In host header line, input: companyweb. In web site access permission setting, please select "read", "Run script" and "Execute".

Step 4: Extend to the new IIS virtual server
----------------------------------------------------
1. Open WSS Central Administration site.
2. Click Extend or upgrade virtual server.
3. Extend on the new created IIS website.
4. After it is extended, go to the virtual server settings page of the new companyweb site.
5. Click Manage content databases.
6. Delete the existing one first and then click Add a content database.
7. Input the original content database name we have just written down in Step 1 in the Database name field.
8. Click OK.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6704
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Postby chicagotech » Wed Mar 05, 2008 11:46 pm

1. ASP.net is 1.1.4322.
2. Do I still have WSS Central Administration site even I had removed the
Office SharePoint? I don't see it from Administrative Tools.

How can I re-install it?
Or perhaps I need to re-install IIS?

I'm afraid we need to uninstall and reinstall WSS 3.0 on this SBS 2003 server.

Please be assured that the original content in the companyweb site won't be lost. I will guide you to restore the site from the database later after the reinstall is complete.

You may refer to the following KB article to reinstall WSS 2.0 on SBS 2003.

How to remove and how to install the Windows Small Business Server 2003 SharePoint Services 2.0 companyweb Web site
http://support.microsoft.com/default.as ... -us;829114

NOTE: Please do not delete the contents under C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT as we need to restore the site from the database file after reinstall.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 6704
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA


Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 8 guests