Sharepoint Insight by Namwar Rizvi

Sharepoint Tips, Tricks and inside knowledge from real world experience by Namwar Rizvi

Archive for the ‘Management’ Category

List of all SharePoint Back-End databases

Posted by namwar on July 16, 2009


SharePoint stores end-user content and application configurations across multiple relational databases in the back-end database servers. At a high level, the following are the relational databases:
 Configuration database: Stores topology and configuration information for the complete deployment. Every farm has exactly one configuration database. For information about the configuration database protocols, see Configuration Database.
 Central Administration content database: Stores content associated with the Central Administration site.
 Shared Services Providers (SSP) database: Stores content and configuration for Shared Service Providers (SSPs), such as the user profile services. The capabilities of SSPs are described in [MS-SPFEPO], Section 2.2.2 (Shared Service Provider).
 Shared services administration content database: Stores content for the shared services administration site.
 Content database: Stores all end-user and site content. For information about content databases and protocols, see List and Library Storage.
 Search property store: The search metadata index that stores properties related to pieces of content that are indexed for full-text querying. For information, see section 7.4.1.1.2.
11 of 43
[MS-SPBEPO] SharePoint Back-End Protocols Overview – v1.0
[MS-SPBEPO]: SharePoint Back-End Protocols Overview
Copyright © 2008 Microsoft Corporation.
Release: Friday, June 27, 2008
 Single sign-on database: Stores credentials for end-users to access information from external applications through SharePoint. For information about the protocols used to access the single sign-on (SSO) database, see Business Data Catalog Protocols.

As described by Microsoft in SharePoint Back-End Protocols Overview

SharePoint stores end-user content and application configurations across multiple relational databases in the back-end database servers. At a high level, the following are the relational databases:

  1. Configuration database: Stores topology and configuration information for the complete deployment. Every farm has exactly one configuration database.
  2. Central Administration content database: Stores content associated with the Central Administration site.
  3. Shared Services Providers (SSP) database: Stores content and configuration for Shared Service Providers (SSPs), such as the user profile services.
  4. Shared services administration content database: Stores content for the shared services administration site.
  5. Content database: Stores all end-user and site content.
  6. Search property store: The search metadata index that stores properties related to pieces of content that are indexed for full-text querying.
  7. Single sign-on database: Stores credentials for end-users to access information from external applications through SharePoint.

Posted in Architecture, Debugging, Guidance, Management, Tips | Tagged: , , , , , | Leave a Comment »

Quickest way to copy files from GAC

Posted by namwar on May 30, 2009


Yes, I know how painful it is to realize that you can not copy an assembly out from Global Assembly Cache (GAC), at least not by usual way of copying a file from a windows folder. Don’t worry, there are some ways to do it and the quickest way to browse the GAC and copy files from it is to just map a drive on Windows\Assembly folder.

Here you go, 

  1. From Start-Run type cmd to launch command prompt
  2. Type subst Z: C:\windows\Assembly and press Enter
  3. Thats it!

Now, you got a drive Z which is mapped to your GAC folder and you can easily open it in Windows Explorer and copy files from it.

Isn’t it easy?

Posted in Management, Tips | Tagged: , , , | 1 Comment »

Display filtered files list without creating new views

Posted by namwar on March 15, 2009


You may have noticed already thatwhen you try to save file in any document library from Microsoft office applications, you get a nice view of files list inside file dialog box like below:

flie-dialog2

This view is just an html generated by the owssvr.dll file located in _vti_bin folder of your virtual server. You can use this to display list of files on your web page by using Page Viewer Web Part. Say, for example, you want to display all the .doc files of Shared Documents documents library then URL will be

http://mossdev:500/Yahoo/_vti_bin/owssvr.dll?location=Shared%20Documents&dialogview=FileSave&FileDialogFilterValue=*.doc;

You will get the following display in your Page Viewer Web Part

file-properties

Following are the details of query parameters:

  1. location=document library name
  2. dialogview=FileSave (there may be other options but for the list, we will use this options)
  3. FileDialogFilterValue =specifies what type of files will be displayed in the list, feel free to specify any file filter as you normally specify in windows file dialgogue boxes. For example, for all xls files starting with a can be listed by specifying the filter value as a*.xls.



Posted in Management | Tagged: , | 1 Comment »

How to hide user name in Sharepoint Survey?

Posted by namwar on January 20, 2009


If you want to hide the identity of the user who responded your survey, just perform the following steps:

  1. Navigate to your survey page
  2. Click Settings and then click Survey Settings
  3. survey-settings

  4. Under General Settings click Title, description and navigation link
  5. general-settings

  6. Under Survey Options, select No for the question Show user names in survey results?
  7. show-user-names

  8. Click Save

Now, check your survey and you will see that all user identity fields like Created By and Last Modified By will just show *** instead of the original user name.

Posted in Management | Tagged: , , | Leave a Comment »

How to solve “Unable to connect publishing custom string handler for output caching”

Posted by namwar on January 11, 2009


If you are getting “Unable to connect publishing custom string handler for output caching” error in your event log then it is because of a custom web service you have installed on your Sharepoint server. Reason for this error is that you have a web part on your portal page which use the custom web service. Now, since Sharepoint uses output caching for the web pages to optimize the rendering experience and fast delivery of unchanged pages therefore, publishing infrastructure of Sharepoint tries to access the web service through your web part and due to any issue in your service, it starts generating this error.

Anyway, cutting a long story short, here is the solution:

Edit the web.config of custom web service (Please do not edit your Sharepoint Web application web.config) and make sure you have following under httpModules node which is located under system.web node. 

            <remove name=PublishingHttpModule />



Posted in Errors, Management | Tagged: , , , , | 7 Comments »

How to remove or Extend New! Item tag for Sharepoint List Items

Posted by namwar on September 7, 2008


Whenever you add a new item in any Sharepoint list “New!” item tag displays against that item for a time being. The time to display this tag depends on a property called “Days to Show New Icon”. The value of this property determines the number of days to display the New! tag against an item.

If you set this property to zero then newly added items will not have this tag. On the other hand if you want to display this tag to be displayed longer then usual then you can set its property in number of days as per your requirement.

Following is the step-by-step procedure to do that:

  1. Click Start, point to All Programs, point to Accessories, and then click Command Prompt
  2. Type the following commands, and then press ENTER after each command:
    cd /d %programfiles%\Common Files\Microsoft Shared\Web Server Extensions\12\BIN
     stsadm.exe -o setproperty -pn days-to-show-new-icon -pv 0 -url [Your Virtual Server’s URL]

Posted in Configuration, Management | Tagged: , | 1 Comment »

Moving Sharepoint Portal from one server to another server

Posted by namwar on August 28, 2008


I found following article quite informative to move Sharepoint Portal from one server to another server.

http://www.sharepointforum.com/en-US/Wiki/Forms/DispForm.aspx?ID=7

It describes step-by-step procedure to move databases from one machine to another machine and how to attach them.

Posted in Configuration, Management | Tagged: , | Leave a Comment »

How to disable My Site functionality?

Posted by namwar on August 27, 2008


If you want to disable My Site or My Links functionality, here are the steps to follow:

  1. Open Central Administration site
  2. Under Shared Services Administration click your Shared Services Provider (SSP) which is running your  My Site functionality
  3. Under User Profiles and My Sites, click Personalization  Services Permissions
  4. Here you can assign different permission set for different users and groups for Personalization functionality.  For example
    1. To disable My Site functionality for all users click NT Authority\Authenticated Users group and uncheck Create personal site
    2. To disable My Links uncheck User personal features
  5. Click Save
  6. Repeat above steps to individually manage Personalization for different users and groups

Posted in Management | Tagged: , | Leave a Comment »