SYMPTOMS
If a Microsoft Office SharePoint Portal Server 2003 portal site and a Microsoft Windows SharePoint Services Web site are hosted on the same virtual server, and you remove Windows SharePoint Services from that virtual server by using the Remove and delete content databases option, you experience the following symptoms:
|
• |
The portal site is still listed on the Manage Portal Sites page of SharePoint Portal Server Central Administration. If you click the down arrow that is next to the name of the portal site, and then click Manage Portal Site Properties or click Delete Portal Sites, you may receive an error message that is similar to the following:
Cannot open database requested in login 'DatabaseName', Login fails.
Login failed for user 'DomainName\UserName' |
|
• |
If you extend the virtual server in Windows SharePoint Services Central Administration, and then you try to connect to the home page of the portal site, you may receive an error message that is similar to the following:
Unable to connect to database. Check database connection information and make sure the database server is running. |
|
• |
If you have a backup of the portal site data, and you try to use the SharePoint Portal Server Data Backup and Restore tool (Spsbackup.exe) to restore your data, the restore operation is not completed successfully. The Spsbackup.exe tool detects that a portal site still exists, and you cannot restore your portal site. |
CAUSE
When you remove Windows SharePoint Services from a virtual server by using the Remove and delete content databases option, the content database for the virtual server is permanently deleted. This is expected behavior. To recover SharePoint content to that virtual server, you have to restore the data from backup.
However, if the portal site and the Windows SharePoint Web site are hosted on the same virtual server, and you unintentionally remove Windows SharePoint Services from the virtual server by using the Remove and delete content databases option, inconsistencies may exist in the configuration database for the portal site. In this situation, you experience the symptoms that are described earlier in the "Symptoms" section of this article.
WORKAROUND
To work around this problem, remove the server topology settings, delete and re-create the configuration database, reassign the server topology settings, and then restore the portal site data from backup. To do so, follow these steps.
Note To follow these steps, you must have a backup copy of SharePoint Portal Server data that you can use to restore the portal site.
|
1. |
Start SharePoint Central Administration. |
|
2. |
Remove the components that are active on the server. To do so, follow these steps:
|
a. |
Under Server Configuration, click Configure server topology. |
|
b. |
On the Configure Server Topology page, click Change Components. |
|
c. |
On the Change Component Assignments page, in the Component Assignment area, click to clear the Web check box, the Search check box, and Index check box (if the check boxes are selected). |
|
d. |
In the Job Server Component area, in the Job server box, click none. |
|
e. |
Click OK, and then click Close. | |
|
3. |
Stop, and then restart the MSSQLSERVER service. To do so, follow these steps:
|
a. |
Click Start, point to Administrative Tools, and then click Services. |
|
b. |
In the right pane, right-click MSSQLSERVER, and then click Stop. |
|
c. |
In the right pane, right-click MSSQLSERVER, and then click Start. | |
|
4. |
In SQL Server Enterprise Manager, delete the configuration database (and any other databases that are associated with the portal). To do so, follow these steps:
|
a. |
Start SQL Server Enterprise Manager. |
|
b. |
Expand Databases. |
|
c. |
Right-click the name of the configuration database, and then click Delete. |
|
d. |
When you are prompted to confirm the deletion, click Yes. |
|
e. |
Repeat steps 4c and 4d to delete any other databases that are associated with the portal site, including the profile database and the component settings database. For example, delete the following databases (if the databases are present):
|
• |
SiteName_PROF |
|
• |
SiteName_SERV | | |
|
5. |
Re-create the configuration database. To do so, follow these steps:
|
a. |
Start SharePoint Central Administration. |
|
b. |
On the Specify Configuration Database Settings for ServerName page, in the Database Connections area, click Disconnect from configuration database, and then click OK. |
|
c. |
On the Configure Server Farm Account Setting page, in the Default Content Access Account area and in the Portal Site Application Pool Identity area, specify the appropriate account settings, and then click OK. |
|
d. |
On the Specify Configuration Database Settings for ServerName page, in the Database Connections area, click Create configuration database. |
|
e. |
In the Configuration Database Server area, in the Database server box, specify the name of the server that is running Microsoft SQL Server. |
|
f. |
In the Configuration Database Name area, specify the name of the configuration database, and then click OK. | |
|
6. |
On the Configure Server Farm Account Settings page, specify the settings that you want in the Contact E-mail Address area and in the Proxy Server Settings area, and then click OK. |
|
7. |
On the Configure Server Topology page, click Change Components. |
|
8. |
On the Change Components Assignments page, specify the components that are active on the server. To do so, follow these steps:
|
a. |
In the Component Assignment area, click to select the check boxes that you want. |
|
b. |
In the Job Server Component area, in the Job server box, click the name of the server. |
|
c. |
Click OK, and then click Close. | |
|
9. |
Restore the portal site from backup. For more information about how to restore SharePoint Portal Server data, see the "Backup and Restore" topic in the Microsoft Office SharePoint Portal Server 2003 Administration Guide. |
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.
MORE INFORMATION
When you remove Windows SharePoint Services from the virtual server by using the Remove and delete content databases option, the Windows SharePoint Services folders from the virtual server are removed and the content database for the virtual server is deleted. Typically, you use this method to permanently remove a virtual server. For example, use this method if you are finished with a project and you no longer need the associated Web sites. To reconstruct the content that was previously stored on that virtual server, you have to restore the data from backup.
For immediate server support, call (877) 752-1122 or email support@exiis.net
About our Search Engine
Information on our site is produced from a variety of recourses including internal support professionals, Microsoft Product Support, Cisco Systems Support, and other third-party resources. The information is provided as a resource only and no warranty is given nor implied as to their accuracy. Our search engine is based on Microsoft Office SharePoint Server (MOSS) 2007 Search Technologies and filtered to produce the best possible results for our end users.
Overview of Exiis Corporation
Exiis Corporation is a client-centric, outsourced professional IT firm specializing in Microsoft Products and Technologies. Our extensive experience with network management and security, application support, and Cisco networking products make us an ideal partner when local resources and IT departments need additional support with their network services.
Microsoft and Cisco Support Technology
Our teams of professional consultants and support engineers have been providing local and remote network, server, and application support for nearly two decades, making us one of the oldest, experienced, and trusted outsourced IT service providers. Our unique “Pay-As-You-Go” model allows business organizations of all sizes to determine exactly how much they would like to spend on their outsourced IT budget, without the hassle of complicated monthly recurring fees or long-term contracts
Remote “Help Desk” Solutions
Exiis Corporation’s remote “Help Desk”, staffed by a team of Microsoft Certified Support Professionals can address these questions in a quick, efficient, time-saving manner that frees your IT team from having to research issues products that are new to them to or not normally maintained on a daily basis.
Access to Resources
Exiis Corporation offers access to the most prestigious collection of Microsoft Certified Professionals. Many organizations have some sort IT Support available to them, either internally or by a local computer provider. Exiis Corporation is able to augment the local IT talent with additional knowledge and experience in Microsoft Products and Technologies such as:
Microsoft Customer Relations Manager (CRM)
Microsoft Office SharePoint Server (MOSS)
Microsoft Exchange Server
Microsoft Great Plains Dynamics (GP)
Microsoft Internet Security and Acceleration Server (ISA)
Microsoft Live Communications Server (LCS)
Microsoft Operations Manager (MOM)
Microsoft Small Business Server (SBS)
Microsoft SQL Server
Microsoft Systems Management Server (SMS)
Microsoft Windows Server
Microsoft Office SharePoint Server (MOSS) 2007 Assistance and Custom Design Development
For larger organization or those that need to manage hundreds or even thousands of documents, who fall under regulatory compliance, and who are seeking a complete “one-stop-portal”, Exiis recommends utilizing the full version of Microsoft Office SharePoint Server (MOSS). MOSS allows for organizations to manage thousands of documents with complete security control, custom branding, advanced search, inter-operability with third-party applications, and a whole host of other features such as: Excel Services, Forms Server, and Business Catalog Services. Microsoft Office SharePoint Server (MOSS) is the de-facto standard for internal portal solutions.
For Additional Support, please see:
http://moss.exiis.net/sharepoint-server-support/Pages/default.aspx