“Cannot connect to the configuration database” error message

http://support.microsoft.com/kb/823287

“Cannot connect to the configuration database” error message

This behavior occurs if one of the following conditions is true:

• The SQL database is not running.
• Internet Information Services (IIS) is configured to run in IIS 5.0 isolation mode.
• The account that is used by application pool does not have the required permissions to the SQL Server database.
• Network connectivity has been lost between the Windows SharePoint Services server and the Microsoft SQL Server server.

Method 1: Verify that the SQL database is running

1. Click Start, point to Programs, point to Administrative Tools, and then click Services.
2. In the list of services, locate the MSSQLSERVER service. This service may also be listed as MSSQL$SHAREPOINT.
3. Note the value of the Status column. If the Status column lists Started, the database server is running. If the Status column is empty, the database server is not running.

   To start the database server, right-click the MSSQLSERVER service, and then click Start.

Method 2: Verify that IIS is not running in IIS 5.0 isolation mode

1. Click Start, point to Programs, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
2. In the left pane, right-click your server name, and then expand the local computer.
3. Right click Web Sites, and then click Properties.
4. Click the Service tab.
5. Click to clear the Run WWW service in IIS 5.0 isolation mode check box.
6. Click OK
7. To start the WWW service, click Yes.

Method 3: Make sure that the account that is used by the application pool is the account that has the required permissions to the SQL Server database

First, you must first determine the application pool identity. To do this, follow these steps:

1. Click Start, point to Programs, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
2. Double-click the Web Sites folder.
3. Right-click the virtual server that is running Windows SharePoint Services 2.0, and then click Properties.
4. Click Home Directory.
5. Note the information that is in the Application name box (this is the application pool name), and then click Cancel.
6. In the left pane, right-click Application Pools, and then click Properties.
7. Click the Identity tab.
8. Note the information that is in the Application pool identitypane, and then click Cancel.

Next, you must verify that this account has the required permission the SQL Server database. To do this, follow these steps:

1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
2. In the left pane, double-click Microsoft SQL Servers, and then double-click your SQL server group.
3. Double-click your server.
4. Double-click Security.
5. In the left pane, click Logins.
6. In the right pane, double-click the user who you noted step 8 of the previous procedure.
7. In the SQL Server Login Properties dialog box, click Server Roles.
8. Click to select both the Security Administrators and the Database Creators check boxes, and then click Database Access.
9. Under the Permit column, click to select the Windows SharePoint Services database.
10. Click OK.

Method 4: Make sure that you have network connectivity and correct name resolution between the servers

To do this, follow these steps:

1. Verify that the Windows SharePoint Services server is using the correct IP address for the SQL server. To do this, run the ping command on the Windows SharePoint Services server.
2. Verify that the Windows SharePoint Services server is obtaining the correct IP address for the SQL server from DNS. To do this, run the nslookup command from the Windows SharePoint Services server.
3. Make sure that there are no incorrect entries for the SQL server. To do this, examine the Hosts file on the Windows SharePoint Services server. This file is in the following location:
   %systemroot%\system32\drivers\etc\Hosts
4. On the Windows SharePoint Services server, look for SQL client aliases. To do this, follow these steps:
   1. Click Start, click Run, and then type cliconfg in the Open box.
   2. Click the Alias tab.

   By default, there are no SQL client aliases. If you have any aliases for the SQL server, verify that they are correct, or remove them.

Game N^2 – 1

My download: http://www.box.net/shared/8hiy1tncc8

CSharp_9_9_DothiVaBus

My Download : http://www.box.net/shared/wmiffchs00

Windows SharePoint Services Farm Topology Examples

Small Farm

Medium Farm

Large Farm

Backing Up a Complete Farm with Stsadm

1. Log on to the SharePoint server as the administrator.
2. Open a command window and run the following command:

       Stsadm --o backup directory c:\bkup --backupmethod full

3. Open the c:\bkup folder and verify that it contains a newly created folder starting with “SPBR” and an index number.
4. Open SharePoint Central Administration, and switch to the Operations page; click “Backup and restore history” in the Backup and Restore section. The backup process you started in step 2 should be listed here.

Improtent

When running this backup process, you will see a lot of details listed. To stop STADM from showing these details, add the command switch “-o quiet” at the end of step 2.

Backing Up a Single Site with STSADM

1. Log on to the SharePoint server as the administrator.
2. Open a command window and run the following command:

       Stsadm --o export --url http://srv1/sitedirectory/it -includeusersecurity↩ --filename c:\bkup\it.bak

3. Open the c:\bkup folder and verify that your backup file is there, along with a log file.
4. Next, restore this file to the URL http://srv1/sitedirectory/sales/it:

       Stsadm --o import --url http://srv1/sitedirectory/sales/it↩ -includeusersecurity --filename c:\bkup\it.bak

5. Log on to the new site and verify that it works and that it has the same user permissions.

Send Mail in Moss 2007

SPWeb site = SPControl.GetContextWeb(Context);

string Msg = "";

SPDocDiscussionCollection discs = site.GetDocDiscussions("Document_Library_Name");

foreach (SPDocDiscussion disc in discs)
{
if (disc.CommentCount > 20)
{
Msg = "The file <A href='" + disc.DocUrl.ToString() + "'>" + disc.DocUrl.ToString() +
"</A> has received " + disc.CommentCount.ToString() + " comments.";

SPUtility.SendEmail(site, false, false, "e-mail_address", "Web Discussion Report", Msg);
}
}

Hide/Remove the View All Site Content link in SharePoint

Article: http://www.crsw.com/mark/Lists/Posts/Post.aspx?ID=36

Summary
This article covers how to hide (remove) the View All Site Content link and/or the Recycle Bin link from the quick launch navigation without having to customize the master page.  Additionally, I cover how I accomplished along with other options, all using the standard functionality provided in Windows SharePoint Services 3.0.

Important:  This solution is not an answer for security.  The user will still have access to the View All Site Content page.  The View All Site Content link is simply removed or hidden from the page.

Applies To

- Windows SharePoint Services 3.0
- Microsoft Office SharePoint Server 2007

Licensing

• There is no license required to use the Hide View All Site Content feature.
• This is available to the public (business or personal) for free.
• There is no support.
• There is no implied or explicit warranty.
• Use at your own risk.

Downloads

Hide View All Site Content – Solution Package
Hide View All Site Content – Solution Package and Source Code

Installation and Activation
(Very easy, no coding required)

For those interested in how to install this solution, it is very easy and does not require any coding, compiling, or editing.

Basic Install Steps:

Note: This command must be executed on the (only one) SharePoint web server, and you must be a local administrator.

1. Add the solution using the STSADM command: stsadm -o addsolution -filename [path]\VASCSiteAction.wsp
2. Deploy the solution using the STSADM command: stsadm -o deploysolution -name VASCSiteAction.wsp -allowgacdeployment -immediate -allcontenturls
3. Optional – to restart IIS: iisreset /noforce

Using (Activating) the new feature:

1. Navigate to the site you want to hide the View All Site Content link.
2. Go to the Site Settings for that site (Site Actions > Site Settings).
3. Click the Site Features (not the Site Collection Features) link under the Site Administration section.
4. Activate the new feature named “Hide the View All Site Content link”.

Your View All Site Content link should now be hidden and the View All Site Content link should now appear in the Site Actions menu.

For those only interested in using this solution, you do not need to read any further.  However, for those who are interested in how this is accomplished, the rest of this article discusses just that.

Install language packs for Microsoft Office SharePoint Server (MOSS) 2007

http://www.fivenumber.com/install-language-packs-for-microsoft-office-sharepoint-server-moss-2007/

Click Start > Settings > Control Panel, then click Regional and Language Options.

Regional and Language Options 

In Regional and Language Options box, under Supplemental language support section, check both check boxes
Install files for complex script and right-to-left languages
and
Install for East Asian languages
Click OK to install
Download language packs for Microsoft Office SharePoint Server (MOSS) 2007:

Select the language from Change Language dropdownlist

 

Available language packs:

Arabic
Bulgarian
Catalan
Chinese (Simplified)
Chinese (Traditional)
Croatian
Czech
Danish
Dutch
English
Estonian
Finnish
French
German
Greek
Hebrew
Hindi
Hungarian
Italian
Japanese
Korean
Latvian
Lithuanian
Norwegian (Bokmal)
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Romanian
Russian
Serbian (Latin)
Slovak
Slovenian
Spanish
Swedish
Thai
Turkish
Ukrainian

After downloading the Server Language Pack.img

Extract the ServerLanguagePack.img file (I prefer to extract using ISO Edit)

Extract the ServerLanguagePack.img 

Run Setup

After installing the language pack

Rerun the Sharepoint Products and Technologies Configuration Wizard using default settings.(If you don’t run the language pack will not be installed properly)

To run the Sharepoint Products and Technologies Configuration Wizard:

Click Start > Programs > Administration Tools click sharepoint Products and Technologies Configuration Wizard

then click Next

Click Yes in the dialog box.

On the modify server farm settings, click Do not disconnect from this server farm, then Next

After configuration successful click Finish

After success installation, you will be find the language pack which you installed before in the dropdownlist while creating the site collection

Creating site collection 

Result:

Sharepoint collaboration portal in German language 

Trình biên dịch (Compiler)

http://www.box.net/shared/qs2r2xsb44