All servers inherit a set of shared platform and management capabilities from Microsoft Windows SharePoint Services 3.0. The following tables are broken down into functional areas and provide a comparison of features available across the different editions of Microsoft SharePoint Product and Technologies.
KEY: = Feature Included
Wikis leverage existing SharePoint functionality including search, navigation, alerts, and custom fields.
Top of Page
SharePoint sites can be provisioned in two ways:
Content types are different from traditional file types (which map to physical file formats like Word documents or Excel spreadsheets). Content types are used to define and implement business documents such as functional specifications, budget planning spreadsheets, or new product concept presentation.
The Job service also provides a facility for distributing work amongst servers in a farm; for example, based on a request to create a site (which originates on a Web front end), a one-time job may run as soon as is reasonable on an indexing server.
The following table offers a detailed comparison between the capabilities offered by the Visual Studio 2005 Designer for Windows Workflow Foundation and Office SharePoint Designer 2007, and the workflows you can create with each.
Visual Studio 2005 Designer for Windows Workflow Foundation
Office SharePoint Designer 2007
Can write workflows for Windows SharePoint Services 3.0
Code-behind file enables developer to write custom Microsoft Visual C# or Microsoft Visual Basic code to express business logic
No code behind; workflow rules file declaratively encapsulates business logic instead
Generates workflow markup file
Workflow is authored as a template, which can be associated with multiple sites and lists
Workflow is authored against and data-bound to specific list at design time
Workflow markup file, or markup and code-behind files, compiled into workflow assembly
Workflow markup, workflow rules, and supporting file are stored, uncompiled, in a specific document library on the site
Workflow template must be associated with each list on which it is to be available.
Association happens when the workflow is authored against the specific list; no later association is necessary or possible
Workflow template can be associated with a site content type.
Cannot author workflows against content types.
Can use any forms technology. For example, Microsoft ASP.NET 2.0 forms for Windows SharePoint Services 3.0 workflows.
Automatically generates Microsoft ASP.NET 2.0 forms, which you can then customize.
Can include workflow modifications
Workflow modifications are not available
Can author custom activities for inclusion in workflows
Must use activities provided
Package workflow assembly and workflow definition as a SharePoint Feature, and deploy to the site
Automatically handles deployment to specific list
Can use Initiation form to gather information from the user when they start the workflow
Can use custom forms for users to interact with tasks in Windows SharePoint Services 3.0
Can use custom forms for users to interact with SharePoint tasks
Visual Studio debugging available
No step-by-step debugging available
Can author both sequential and state workflows
Can author only sequential workflows
The following sections contain the character limitations that apply to various user-specified parameters in Microsoft Office SharePoint Portal Server 2003.
The portal site name can consist of all alphanumeric characters except for the following: \ / : * ? " < > |
The portal site description can consist of all alphanumeric characters, as well as the following: # % * + \ | " ? $ @ [ ] { } ⌂
The URL for the portal site logo can consist of all alphanumeric characters except for the following: # % * + \ | " ? > < $ @ [ ] { } ⌂
The following file formats are supported for the graphics file: .gif, .bmp, .jpg, and .png. TIFF files are not supported.
The URL must end with /_layouts/language/scsignup.aspx.
The content index name cannot contain the following characters: + ~ # ' % * ( ) = [ ] { } | \ " < > . ? / @ & or the euro symbol or a space.
This topic lists and explains the operations you can perform with Stsadm.exe. For detailed information about the required and optional parameters, including short forms of the parameters, see Command-Line Parameters. For more information about using the command-line tool, see "Introducing the Administration Tools for Windows SharePoint Services" in the Windows SharePoint Services Administrator's Guide.
Note To use stsadm.exe, you must be a member of the local Administrators group for the server computer.
You can also get a list of the command-line operations by typing stsadm.exe -help on the command line. Syntax help for specific operations is available by typing stsadm.exe -help <operation name>.
Adds a defined path (inclusion or exclusion) to a virtual server
-type
Sample syntax:
stsadm.exe -o addpath -url <url> -type <exclusion/explicitinclusion/wildcardinclusion>
Adds a site template to the template gallery.
Note If you want the changes to the template list to take effect immediately, run the iisreset command after you run the addtemplate operation.
-title
stsadm.exe -o addtemplate -filename <template filename> -title <template title> [-description <template description>]
Adds a user account to the specified site and assigns it to the specified site group. Use the siteadmin parameter to register the user as the site administrator.
-userlogin
-useremail
-role
-username
stsadm -o adduser -url <url> -userlogin <DOMAIN\username> -useremail <someone@example.com> -role <site group name> -username <user's display name> [-siteadmin]
Adds a Web Part package to your server Web Part gallery. Use the globalinstall parameter to install the Web Parts in the global assembly cache (GAC) rather than in the Bin directories of each virtual server. Assemblies installed in the GAC are available to all applications on the server. The url parameter optionally specifies the URL of the virtual server on which to install the Web Parts. To install the Web Parts on every virtual server on a server, omit theurl parameter. Use the force parameter to overwrite an existing Web Part package with a new version, or to repair a Web Part package by reinstalling it. Use the lcid parameter to specify a language for the Web Part package.
Use filename to specify the path to the cabinet file containing the Web Parts and associated resources. If the Web Part package has already been installed on another server in a server farm configuration, you can install the Web Part package from the configuration database by using the name parameter.
-globalinstall
-force
-lcid
stsadm.exe -o addwppack -filename <Web Part Package filename> [-url <url> -globalinstall -force -lcid <language>]
Creates a backup of the site at the specified URL. Use the overwrite parameter to replace an existing backup file.
-filename
stsadm.exe -o backup -url <url> -filename <filename> [-overwrite]
Registers a data retrieval service for the list of data retrieval services that pertain to a specific setting on the Data Retrieval Services Settings page. Specify the service name and then the setting. Settings include enabled, responsesize, timeout, and update.
-setting
stsadm.exe -o binddrservice -servicename <service name> -setting <enabled/responsesize/timeout/update>
Creates the administration virtual server for Microsoft Windows SharePoint Services. Use the admapid... parameters to create a new application pool for IIS, or to specify the application pool to use for the administration virtual server.
-admapidname
-admapidtype
-admapidlogin
-admapidpwd
stsadm.exe -o createadminvs [-admapcreatenew] [-admapidname <app pool id>] [-admapiptype <configurableid/NetworkService/LocalService/LocalSystem>] [-admapidlogin <app pool user account>] [-admapidpwd <app pool password>]
Creates a site at the specified URL with the specified user as owner and administrator. If you do not specify the template to use, the owner can choose the template when he or she first browses to the site.
-ownerlogin
-owneremail
-sitetemplate
-description
-quota
stsadm.exe -o createsite -url <url> -ownerlogin <DOMAIN\username> -owneremail <someone@example.com> [-ownername <display name>] [-lcid <language>] [-sitetemplate <site template>] [-title <title>] [-description <description>] [-quota <quota template>]
Note You must specify the -lcid option when using a non-English template.
Creates a site at the specified URL and creates a new content database with the username and password you specify. If you do not specify the template to use, the owner can choose the template when he or she first browses to the site.
-databaseuser
-databasepassword
-databaseserver
-databasename
-secondarylogin
-secondaryemail
-secondaryname
stsadm.exe -o createsiteinnewdb -url <url> -ownerlogin <DOMAIN\username> -owneremail <someone@example.com> [-ownername <owner's name>] [-databaseuser <databaseusername>] [-databasepassword <databasepassword> [-databaseserver <databaseserver>] [-databasename <databasename>] [-lcid <language>] [-sitetemplate <site template>] [-title <title>] [-description <description>] [-secondarylogin <DOMAIN\username>] [-secondaryemail <someone@example.com>] [-secondaryname <secondary owner's name>]
Creates a subsite at the specified URL. If you do not specify the template to use, the owner can choose the template when he or she first browses to the site. Use the unique parameter to specify unique permissions for the subsite.
-unique
stsadm.exe -o createweb -url <url> [-lcid <language>] [-sitetemplate <site template>] [-title <title>] [-description <description>] -unique]
Deletes the administration virtual server for Windows SharePoint Services.
stsadm.exe -o deleteadminvs
Deletes the configuration database for Windows SharePoint Services.
stsadm -o deleteconfigdb
Removes an included or excluded path from the list of paths managed by Windows SharePoint Services.
stsadm -o deletepath -url <url>
Deletes the specified site. To delete users from Active Directory directory services, specify true for the deleteadaccounts parameter.
stsadm.exe -o deletesite -url <url> -deleteadaccounts <true/false>
Deletes the specified site template.
stsadm.exe -o deletetemplate -title <template title> [-lcid <language>]
Deletes the specified user.
stsadm -o deleteuser -url <url> -userlogin <DOMAIN\username>
Deletes the specified subsite.
stsadm.exe -o deleteweb -url <url>
Removes the Web Parts in a Web Part package from a virtual server. When you delete the last instance of a Web Parts package on a server or server farm, Stsadm.exe also deletes the Web Part package from the configuration database.
The parameter name specifies the name of the Web Part package. The parameter url optionally specifies the URL of the virtual server on which to delete the Web Parts. If url is omitted, Stsadm.exe deletes the Web Parts from the Bin folder of every virtual server on the server or from the global assembly cache.
Use the lcid parameter to remove a particular language version of a Web Part package.
stsadm -o deletewppack -name <name of Web Part package> [-url <url> -lcid <language>]
Disables Self-Service Site Creation for the specified virtual server.
stsadm -o disablessc -url <url>
Disables the Windows SharePoint Services ISAPI extensions. This operation is used by the Setup program for Windows SharePoint Services.
stsadm -o disablestsisapis
Sets the e-mail configuration settings for your server, or for a specific virtual server (when you use the url parameter).
-fromaddress
-replytoaddress
-codepage
stsadm.exe -o email -outsmtpserver <SMTP server> -fromaddress <someone@example.com> -replytoaddress <someone@example.com> -codepage <codepage> [-url <url>]
Enables Self-Service Site Creation for the specified virtual server.
stsadm -o enablessc -url <url> [-requiresecondarycontact]
Enables the Windows SharePoint Services ISAPI extensions. This operation is used by the Setup program for Windows SharePoint Services.
stsadm -o enablestsisapis
Lists the site groups that are available for use in a particular site or subsite.
stsadm -o enumroles -url <URL>
Lists all of the sites that have been created under a particular virtual server. The url parameter must be the URL of a virtual server.
stsadm -o enumsites -url <URL>
Lists the subsites that have been created under a particular site.
stsadm -o enumsubwebs -url <URL>
Lists the site templates that are available.
stsadm.exe -o enumtemplates [-lcid <language>]
Lists the users of a particular site or subsite.
stsadm.exe -o enumusers -url <url>
Lists the Web Part Packages currently in your server Web Part gallery.
-url
stsadm -o enumwppacks [-name <name of Web Part Package>] [-url <URL>]
Extends a virtual server with Windows SharePoint Services and creates a new content database.
Note Extending a virtual server creates a site but does not require the createsite parameter. Use the donotcreatesite parameter if you do not want to create a site when you extend the virtual server.
-databaseuser (du)
-databaseserver (ds)
-databasename (dn)
-databasepassword (dp)
-donotcreatesite
-apcreatenew
-apidname
-apidtype
-apidlogin
-apidpwd
stsadm -o extendvs -url <url> -ownerlogin <DOMAIN\username> -owneremail <someone@example.com> [-ownername <display name>] [-du <database user>] [-ds <database server>] [-dn <database name>] [-dp <database user password>][-lcid <lcid>] [-sitetemplate <site template>] [-donotcreatesite] [-apcreatenew] [-apidname <app pool name>] [-apidtype <configurableid/NetworkService/LocalService/LocalSystem>] [-apidlogin <DOMAIN\username>] [-apidpwd <app pool password>]
Extend a virtual server with Windows SharePoint Services for use in a server farm. This operation does not create a new content database, but allows you to connect to an existing virtual server (vsname) and use the same content database.
-vsname
stsadm -o extendvsinwebfarm -url <url> -vsname <virtual server name> [-apcreatenew] [-apidname <app pool name>] [-apidtype <configurableid/NetworkService/LocalService/LocalSystem>] [-apidlogin <DOMAIN\username>] [-apidpwd <app pool password>]
Returns the administration port for Windows SharePoint Services.
stsadm -o getadminport
Returns the property value for the specified property name. For a list of valid properties, see Command-Line Properties.
stsadm -o getproperty -pn <property name> [-url <url>]
Removes a data retrieval service from the list of data retrieval services that pertain to a specific setting on the Data Retrieval Services Settings pages. Specify the service name, and then the setting. Settings include enabled, responsesize, timeout, and update.
stsadm.exe -o removedrservice -servicename <service name> -setting <enabled/responsesize/timeout/update>
Renames the specified subsite.
-newname
stsadm.exe -o renameweb -url <url> -newname <new subsite name>
Restores a Web site from a backup file. Use the overwrite parameter to replace any existing Web site at the new location.
stsadm.exe -o restore -url <url> -filename <filename> [-overwrite]
Sets the port number for the administration virtual server for Windows SharePoint Services. Use the ssl parameter to specify a Secure Sockets Layer (SSL) connection to the port. Use the admap... parameters to specify the IIS application pool to use or to create a new IIS application pool for the administration virtual server.
-admapcreatenew
stsadm.exe -o setadminport -port <port> [-ssl] [-admapcreatenew] [-admapidname <app pool id>] [-admapiptype <configurableid/NetworkService/LocalService /LocalSystem>] [-admapidlogin <app pool user account>] [-admapidpwd <app pool password>]
Creates the configuration database or specifies the connection to an existing configuration database. Setting the configuration database is required before a virtual server can be extended.
-hh
-adcreation
-addomain
-adou
stsadm.exe -o setconfigdb [-connect] -ds <database server> [-du <database user>] [-dp <database user password>] [-dn <database name>] [-hh] [-adcreation] [-addomain <AD domain> [-adou <AD OU>]
Sets the specified property with the specified value. Use the url property to specify a virtual server or site collection to apply the property to, or omit the url parameter to apply the property at the server or server farm level. For a list of valid properties, see Command-Line Properties.
-propertyvalue (pv)
stsadm.exe -o setproperty -pn <property name> -pv <property value> [-url <url>]
Sets the owner or secondary owner of a site collection. Either the ownerlogin or secondownerlogin parameter must be used.
either -ownerlogin or -secondownerlogin
stsadm.exe -o siteowner -url <url> [-ownerlogin <DOMAIN\username> | -secondownerlogin <DOMAIN\username>]
Removes Windows SharePoint Services from a particular virtual server. Use the deletecontent parameter to delete the content databases for the virtual server.
stsadm.exe -o unextendvs -url <url> [-deletecontent]
Uninstalls Windows SharePoint Services from the default virtual server at port 80. Any other virtual servers that were extended with Windows SharePoint Services will not be unextended. Uninstall removes the Windows SharePoint Services ISAPI extensions and any virtual directories or other files from the virtual server. It does not delete the content databases unless you include the deletecontent parameter. This operation is used by the Setup program for Windows SharePoint Services.
stsadm.exe -o uninstall [-deletecontent]
Upgrades the server or the specified virtual server with Windows SharePoint Services. This operation is used by the Setup program for Windows SharePoint Services.
stsadm.exe -o upgrade [-url <url>]
Specifies the site group membership for a user. Use the add and delete parameters to specify whether to add the user to a site group or remove the user from a site group.
-delete
stsadm.exe -o userrole -url <url> -userlogin <DOMAIN\username> -role <site group name> [-add] [-delete]
The following table lists and explains the parameters you can use with operations for Stsadm.exe. For detailed information about the operations, including sample syntax, see Command-Line Operations. For more information about using the command-line tool, see "Introducing the Administration Tools for Windows SharePoint Services" in the Windows SharePoint Services Administrator's Guide.
Values available in a default installation include:
STS#0 (Team Site)
STS#1 (Blank Site)
STS#2 (Document Workspace)
MPS#0 (Basic Meeting Workspace)
MPS#1 (Blank Meeting Workspace)
MPS#2 (Decision Meeting Workspace)
MPS#3 (Social Meeting Workspace)
MPS#4 (Multipage Meeting Workspace)
Note If you added a template to the central template gallery, you must specify the template name as _GLOBAL_#number, where number refers to the template ID.
This topic lists and explains the properties that can be set on the command line by using the Stsadm.exe tool with the getproperty and setproperty operations. To see the current value of a property, you use the getproperty operation. To set the value for a property, you use the setproperty operation. The following examples show the syntax to use when getting or setting a property:
stsadm.exe -o getproperty -pn <property name> [-url <url>] stsadm.exe -o setproperty -pn <property name> -pv <property value> [-url <url>]
Some properties are available for the entire server, and are called server properties. Some are only available for an individual virtual server. When you get or set a server property, you can omit the url parameter. You must include the url parameter to get or set virtual server properties. For more information about setting properties, see "Introducing the Administration Tools for Windows SharePoint Services" in the Windows SharePoint Services Administrator's Guide.
Use these properties to configure alerts for your server. Specify whether alerts are enabled, whether users are limited as to the number of alerts they can create, and if so, the maximum number of alerts. You can also specify the times to send out immediate, daily, and weekly alerts. For more information about alerts, see Managing Alerts.
Use these properties to configure antivirus protection for your server. Specify whether users can download infected files to their client computers, whether antivirus cleaning is enabled, whether the download and upload scans are enabled, the timeout time for scanning, and the number of threads to take up with antivirus processes. For more information about using antivirus scanning, see Configuring Antivirus Protection.
Use these properties to set the server name, user name, and password to use for the default content database for your server. For more information about the default content database, see Managing Content Databases.
Use these properties to configure data retrieval services for your virtual server, server, or server farm. Specify whether data retrieval services are enabled, whether to inherit the server farm settings for a virtual server, the time an adapter will wait for a response from the back-end data source, the maximum size for data returned from the back-end source, whether adapters can execute requests that contain updatable queries, and the list of supported OLEDB providers. For more information about data retrieval services, see Configuring Data Retrieval Services.
For example: "DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB"
Use the following properties to specify general settings for a virtual server. Specify how long (in days) to display the New icon for items added to a Web site, the default quota template and default time zone for Web sites, the maximum size for files posted to Web sites, and whether Web Discussions are enabled for the virtual server.
For more information about specifying virtual server general settings, see Configuring Virtual Servers.
Use these properties to specify HTML Viewer options for your server or server farm. Specify whether HTML viewing is enabled, the path (URL) to the HTML Viewer server, the maximum cache size for the HTML Viewer, the maximum file size that can be viewed, and the timeout time for HTML viewing. For more information about HTML viewing, see Managing HTML Viewers.
These properties can be set either at the server (and server farm) level or at the virtual server level. Specify whether to send e-mail notifications about unused Web sites, how long to wait before sending the first e-mail notification, how many notifications to send, whether to automatically delete unused Web sites, and when to delete unused Web sites. For more information about site confirmation and automatic deletion, see Managing Unused Web Sites.
This property can be set either at the server (and server farm) level or at the virtual server level. For more information about usage analysis, see Configuring Usage Analysis.
If you want the job to start at a specific time, set the beginning and end times to the same time, for example: "daily between 16:55:21 and 16:55:21".
Note This property can be set only to "daily", not to "weekly" or "immediate".
This topic explains the rights and site groups you can assign to users by using operations in Stsadm.exe and by using HTML Administration pages. Each user right or site group is listed by the name that appears in HTML Administration pages. The name used to identify a site group for the Stsadm.exe command-line tool is listed in a table. For each site group, the default rights included in that site group are listed. For each right, any rights dependent on the right are listed, as well as any default site groups that include the right.
For more information about user rights and site groups, see "Managing Site Groups and Permissions" and "Managing Users and Cross-Site Groups" in the Windows SharePoint Services Administrator's Guide. For more information about using the command-line tool, see "Introducing the Administration Tools for Windows SharePoint Services" in the Windows SharePoint Services Administrator's Guide.
Microsoft Windows SharePoint Services includes five site groups by default. You can customize the rights available in these site groups (except for the Guest and Administrator site groups) or add new site groups to combine different sets of rights.
The Guest site group is designed to be combined with per-list permissions on particular lists to give guest users access to a specific list, without giving them access to the entire site. The Guest site group cannot be customized or deleted.
The Reader site group allows a user to view items in lists and document libraries, view pages in the site, and create a site using Self-Service Site Creation.
View Pages
View Items
The Contributor site group allows a user to interact with Web Parts and lists and document libraries. They can also create and manage personal views and cross-site groups, and personalize Web Part Pages.
Add Items
Add/Remove Private Web Parts
Browse Directories
Create Cross-Site Groups
Delete Items
Edit Items
Manage Personal Views
Update Personal Web Parts
The Web Designer site group allows a user to customize the Web site using the HTML tools or a Web page editor compatible with Windows SharePoint Services, such as Microsoft Office FrontPage 2003. For example, Web Designers can create lists from within the site or add new pages to the site by using a Web page editor.
Add and Customize Pages
Apply Themes and Borders
Apply Style Sheets
Cancel Check-out
Manage Lists
The Administrator site group allows a user to have complete control over a Web site. Members of the Administrator site group can configure settings, manage users and site groups, and view usage analysis data.
Create Subsites
Manage List Permissions
Manage Site Groups
View Usage Data
Windows SharePoint Services includes 21 rights, which are used in the five default user site groups. You can change which rights are included in a particular site group (except for the Guest and Administrator site groups) or create a new site group to contain a specific list of rights.
Grants permission to create ASP.NET, ASP, and HTML pages for a Web site.
Grants permission to add items to lists or add documents to document libraries.
Grants permission to add and remove Web Parts in order to personalize Web Part Pages.
Grants permission to apply a style sheet to the entire Web site.
Grants permission to apply a theme or border to an entire Web site.
Grants permission to browse the directory structure of a Web site.
Grants permission to cancel the check-out action performed by another user.
Grants permission to create or delete cross-site groups, or to change membership of a cross-site group.
Grants permission to create a new subsite or workspace site, such as a Document Workspace site or Meeting Workspace site.
Grants permission to delete list items and documents from the Web site.
Grants permission to edit existing list items and documents in the Web site.
Grants permission to create, edit, or delete lists and change their settings.
Grants permission to change permissions for a list or document library.
Grants permission to create, edit, or delete personal views on lists.
Grants permission to create, delete, and edit site groups, both by changing the rights assigned to the site group and by changing which users are members of the site group.
Grants permission to perform administration tasks for a particular site or subsite.
Grants permission to update Web Parts to display personalized information.
Grants permission to use the Self-Service Site Creation tool to create a top-level Web site.
Grants permission to view items in lists, documents in document libraries, and Web discussion comments.
Grants permission to browse pages in the Web site.
Grants permission to view reports on Web site usage.
This appendix lists the detailed, minimum file permission settings that must be in place for Microsoft Windows SharePoint Services to perform as designed.
The Windows SharePoint Services installation directory is C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60 by default.
Administrators
SYSTEM
Full Control
This listing is for a Web site content area of \inetpub\wwwroot.
Note All directories enclosing the content root will grant LIST permissions to these accounts.
IIS_WPG
Internet Guest Account (IUSR_*)
Read & Execute, Read
Special Permissions
Read & Execute, Read, Special Permissions
IUSR_*
Windows SharePoint Services also changes permissions for two folders in the Microsoft Windows directory (%WinDir%).
STS_WPG
Network Service (for a domain controller only)
Read, Write
This appendix lists folders and files used by Microsoft Windows SharePoint Services.
The following files are added to the installation directory (c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60) when you install Windows SharePoint Services.
OWSTIMER.EXE — Microsoft SharePoint Timer service
SMIGRATE.EXE — Microsoft SharePoint Migration Tool
STSADM.EXE — Stsadm utility
STSCFG.EXE — Configuration utility used by Setup
ONETINTL.DLL — Core international binary file
appwpresweb.config — Configuration file
adminweb.config — Configuration file for the administrative virtual server
gacwpresweb.config — Configuration file
layoutsweb.config — Configuration file for the _layouts directory
web.config — Configuration file for virtual servers
wss_mediumtrust.config — Configuration file
wss_minimaltrust.config — Configuration file
*.aspx — Form pages
Global.asax — ASP.NET namespace definition
*.xml — XML file for managed code
*.DLL — Core binary files for managed code
web.config — Configuration file
*.htm
*.js
layout.swf
SCHEMA.XML — Schema file
*.HTM — Dialog boxes
_blankpage.htm
MASTER03.CSS
MASTER03.HTM
MASTER03.XML
PPTMPL.HTM
PPTMPL.POT
PRES.XML
PREVIEW.WMF
SLIDE001.HTM
_smartpage.htm
_webpartpage.htm
WDTMPL.HTM
SHEET001.HTM
SHEET002.HTM
SHEET003.HTM
STYLE.CSS
TABSTRIP.HTM
XLTMPL.HTM
XLTMPL.XLS
VCARD.VCF — Contacts form
EVENT.ICS — Event form
TASK.ICS — Task form
SmartNav.js
WebUIValidation.js
ASP.NET files
setuperror.htm — Setup messages
*.css — Style sheets
*.htm — Dialog boxes
*.htc — Menu control
*.js — JavaScript files
*.xml — XML templates
*.xsd — XML definitions
Note This folder is added only if you have used a Meeting Workspace template.
MEETINGS.JS — JavaScript file
theme.INF — Theme definition file
theme.utf8 — Theme file for UTF8 encoding
In addition to the installation directory, there is a Web Part resources directory that contains files used to support custom Web Parts in Windows SharePoint Services. The c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\wpresources directory contains a web.config file that is used to help control security for ASP.NET files used in Web Parts. For more information about custom Web Parts, see the Windows SharePoint Services Software Development Kit.
The following files are added to each top-level Web site or subsite when a SharePoint site is created.
services
All other Web site files are stored in the content and configuration database.
You use two methods to control the language settings available for Web sites based on Microsoft Windows SharePoint Services:
Language template packs allow you to use site templates designed for specific languages. When you create a site based on a site template in a language template pack, the navigation and pages for that site are displayed in that language.
Regional settings allow you to control how dates, times, and lists are displayed in a particular Web site. Regional settings do not control the language used for the navigation or pages in the site. For more information about regional settings, see Configuring Regional Settings.
Windows SharePoint Services uses the following terms to describe the language settings that are used for a Web site:
The language ID specified when a Web site is created controls the language used in the Web site itself. For example, if the site was created in French (language ID 1036), all of the toolbars, navigation bars, list and form pages, and so on, appear in French. If the site was created in Arabic (1025), the text is in Arabic, and the default left-to-right orientation of the site is change to right-to-left to properly display Arabic text.
By default, Windows SharePoint Services has language packs that contain site templates for many language IDs. You can install one or more of these language packs to your Web server to support users creating sites in as many languages as you need. For example, if you have a server running the Japanese version (language ID 1041) of Windows SharePoint Services, you can install a U.S. English (1033) language pack with templates that allow your users to create sites configured for U.S. English. New para
The locale ID is specified on the Regional Settings page, and affects how numbers, calendars, sorting, and time are displayed in the site. For example, if you have a U.S. English language site (language ID 1033), and you change the locale ID to French (Canada) (locale ID 3084), the Events list and Calendar views reflect the French notations for dates, numbers, time, and so on. The locale ID does not affect the orientation of the site. Choosing Arabic (Egypt) (locale ID 3073) does not change the site to right-to-left orientation, but does allow you to display the Events list with dates in Arabic notation. Each language template has a default locale ID. For example, in the U.S. English (1033) template, the default locale ID is also 1033.
Windows SharePoint Services supports all of the locale IDs supported by the Microsoft Windows Server 2003 family, which is a much larger set than the set of language IDs.
For more information about supported language IDs and locale IDs, see Regional and Language Settings.
When you create a site, you choose which language it is displayed in. You cannot display a site in more than one language, or change which language is used. If you need to create a site that can display more than one language, for example if you needed a site for both English and Spanish speakers, use the following method:
For example, on the US English site, use a Web page editor compatible with Windows SharePoint Services to edit the navigation strings to include both the English strings and the strings from the Spanish site. In this example, "Home" would become "Home/Pagina principal".
Because Windows SharePoint Services uses Unicode encoding, the strings from all of the languages should display correctly on the site you customize.
Language template packs for Windows SharePoint Services are available as downloadable files from Windows Update. There are language template packs that you can install to support Web sites in many languages. For a list of supported languages, see Regional and Language Settings.
To install a language template pack, you simply download it from Windows Update, and then run the setup program. Note that at the end of setup, Internet Information Services (IIS) is automatically restarted. If you are in a server farm environment, you must install the language template packs to each front-end Web server in your server farm.
During installation, the site templates are added to the Windows SharePoint Services installation directory, under the \TEMPLATE\LCID directory, where LCID is the locale ID for the language. For more information about where the language template files are stored on the server, see Special Directories and Storage Locations. After installation, server administrators, members of the SharePoint administrators group, and users with the Create Subsites right or the Use Self-Service Site Creation right can create Web sites based on the language templates by selecting the language on the Create Top-Level Web Site page or the New SharePoint Site page.
If you no longer need a language template pack, you can uninstall it by using Add or Remove Programs in Control Panel. Uninstalling removes the language template files from the \TEMPLATE\LCID directories.
Caution When you uninstall a language template pack, any sites based on that language no longer work. You can reinstall the language template pack to restore the sites.
This topic lists the regional and language settings you can specify from the command line by using operations in Stsadm.exe and by using HTML Administration pages. For more information about specifying regional and language settings, see Language Considerations. For more information about the syntax for command-line operations, see Command-Line Operations.
The following types of regional and language settings are used in Microsoft Windows SharePoint Services:
The Language ID determines the language used for text on pages in the Web site (such as the text on the Site Settings page). The languages available for site creation depend on the language template packs you have installed to your server or server farm. Web sites based on Windows SharePoint Services can be created in the following languages.
Windows SharePoint Services also supports input and display of text in the following languages, but not site creation.
The Locale ID controls the numbering, sorting, calendar, and time formatting for the Web site. You can change the locale for a Web site by using the Regional Settings page. Web sites based on Windows SharePoint Services can be set to the following Locale IDs.
Web sites based on Windows SharePoint Services can be set to any of the time zones recognized by Microsoft Windows Server 2003.
Web sites based on Windows SharePoint Services can be set to use the following currencies.
Every Web site (both top-level Web sites and subsites) based on Microsoft Windows SharePoint Services can be customized to use specific regional settings that apply to the users of your site. You can specify the following regional settings:
Controls how numbers and dates are displayed in the site.
Controls the sort orders used for lists and libraries.
Controls the time zone for the Web site.
Note You cannot configure a client's view to see document information in their time zone if it is different than the site's time zone. For example, if you have a site set to Eastern Time (US and Canada), and a user in Amsterdam adds a document at 1:00 PM (or 13:00) local time, the document properties show that it was added at 7:00 AM Eastern Time. If this is a problem for your site, you may want to consider creating a personalizable Web Part to show all documents and list items in a specific time zone. For example, the Web Part could list all document libraries and lists in the site, and then the user could select which document library or list to display and the time zone to display it in, and then they would see the data from that document library or list converted to their time zone. For more information about creating custom Web Parts, see the Windows SharePoint Services Software Development Kit.
Specifies whether to display times in 12-hour or 24-hour format.
To specify the locale ID for a site, you can use either HTML Administration pages or the command line. To change the sort order, time zone, or time format for a site, you must use HTML Administration pages. For more information about language settings in Windows SharePoint Services, see Language Considerations.
You can change the locale ID, sort order, time zone, and time format for an individual site by using the Regional Settings page in the Site Administration pages.
Server administrators and members of the SharePoint administrators group can also specify a default time zone to use for all sites on a virtual server. For more information, see Configuring Virtual Servers.
When you extend a virtual server, create a new top-level Web site, or create a new subsite from the command line, you can specify the locale ID to use. The extendvs, createsite, createsiteinnewdb, and createweb operations all accept the lcid parameter. To enter a locale ID in any of these operations, you type the numerical value for the locale (such as 1033 for U.S. English or 1036 for French/France). For example, to create a new subsite and use the French locale ID for France, you would use the following syntax:
stsadm.exe -o createweb -url http://server_name/site1/subsite1 -lcid 1036
All of these operations take several other parameters
You can use the object model for Microsoft Windows SharePoint Services to manage your servers, sites, users, and other resources. To access the administrative object model for Windows SharePoint Services, you must be an administrator of the local server computer or a member of the SharePoint administrators group.
If you are using a Web application (such as a billing application) to access the object model and perform administrative functions, you must be sure that the Web application is running in the same security context as Windows SharePoint Services. In other words, the Internet Information Services (IIS) application pool for the Web application must allow access to the SharePoint administrators group, or you must include the application pool account in the SharePoint administrators group, or the application pool must be the same application pool as is used for SharePoint Central Administration.
If you are relying on the SharePoint administrators group for the security context, keep in mind that there are some actions that that group cannot perform. The following actions must be performed by a member of the local administrators group for the server computer:
If you want to perform these tasks from a custom application that calls the administrative object model directly, the application must be running as a member of the local administrator group.
There are many times when it would be useful to use the object model to perform administrative tasks for Windows SharePoint Services, rather than using the command line tool or HTML Administration pages. For example, you would use the object model when:
If your environment is very complex, and your organization uses a special administrative application to manage servers, you can use the object model to call the Windows SharePoint Services administrative functions, rather than using the HTML Administration pages or the command line.
For example, if you have an application that coordinates online meetings, and you want to create Meeting Workspaces in Windows SharePoint Services automatically, you can use the object model to do so.
You can use the object model to enumerate the sites owned by particular users, find out how many users or how many files are being added to sites, or determine trends and perform capacity planning to decide when it is time to add another server to your server farm.
For example, you can use a billing application to verify billing information before a user can create a site. Or, you can use contact or billing information to generate a custom page that shows which sites belong to which site owners.
You can use the quota mechanisms to automatically lock a site if a customer or group is not current in its billing, and only allow access when the billing charges are rationalized. Or if a user is no longer part of your organization, you can lock all sites owned by that user until you determine what to do with the sites. For more information about quotas and locking sites, see Configuring Site Quotas and Locks.
For more information about the administrative object model and using it to perform administrative tasks, see the Windows SharePoint Services Software Development Kit.
There are a few of problems with this approach that become even more obvious when you install SharePoint on a database server that hosts more than one SharePoint Farm, and mix SharePoint databases with other application databases.
Some of the problems include:
To mitigate these problems, I normally recommend to clients that they use an alternative naming convention, that follows this standard:
sp<farm>_<type>_<name>
The convention is designed to be both brief (relatively short), but contain all the information necessary to be human readable, and orderly.
To support this naming convention, databases are classified into 3 types:
Below is an example of an installation using this convention. The SQL Server hosts two farms: a Development Integration farm for building and unit testing SharePoint solutions, and a QA/Testing server for doing user acceptance testing.
spdev_config_farm spdev_search_farm spdev_content_centraladmin spdev_config_ssp1 spdev_search_ssp1 spdev_content_ssp1admin spdev_content_mysites spdev_content_intranet sptest_config_farm sptest_search_farm sptest_content_centraladmin sptest_config_ssp1 sptest_search_ssp1 sptest_content_ssp1admin sptest_content_mysites sptest_content_intranet
I believe most people would agree this is much easier to read and manage than the defaults. The only obstacle to achieving this standard is that by default, the SharePoint Products and Technologies Configuration Wizard creates the first two farm databases for you using hard-code defaults. Specifically, the farm configuration database (SharePoint_Config), and the central administration content database (SharePoint_AdminContent_<Guid>).
To resolve this problem, SharePoint includes a command-line utility called PSCONFIG.EXE that can be used to pre-create the initial farm databases