SharePoint 2010 Site Template ID
| ||
ID
| Display group | |
| 0 | GLOBAL#0 | Global template |
| 1 | STS#0 | Team Site |
| 1 | STS#1 | Blank Site |
| 1 | STS#2 | Document Workspace |
| 2 | MPS#0 | Basic Meeting Workspace |
| 2 | MPS#1 | Blank Meeting Workspace |
| 2 | MPS#2 | Decision Meeting Workspace |
| 2 | MPS#3 | Social Meeting Workspace |
| 2 | MPS#4 | Multipage Meeting Workspace |
| 3 | CENTRALADMIN#0 | Central Admin Site |
| 4 | WIKI#0 | Wiki Site |
| 7 | BDR#0 | Document Center |
| 9 | BLOG#0 | Blog |
| 15 | SGS#0 | Group Work Site |
| 16 | TENANTADMIN#0 | Tenant Admin Site |
| 20 | SPS#0 | SharePoint Portal Server Site |
| 21 | SPSPERS#0 | SharePoint Portal Server Personal Space |
| 22 | SPSMSITE#0 | Personalization Site |
| 30 | SPSTOC#0 | Contents area Template |
| 31 | SPSTOPIC#0 | Topic area template |
| 32 | SPSNEWS#0 | News Site |
| 33 | SPSNHOME#0 | News Site |
| 34 | SPSSITES#0 | Site Directory |
| 36 | SPSCOMMU#0 | Community area template |
| 38 | SPSREPORTCENTER#0 | Report Center |
| 39 | CMSPUBLISHING#0 | Publishing Site |
| 40 | OSRV#0 | Shared Services Administration Site |
| 47 | SPSPORTAL#0 | Collaboration Portal |
| 50 | SRCHCEN#0 | Enterprise Search Center |
| 51 | PROFILES#0 | Profiles |
| 52 | BLANKINTERNETCONTAINER#0 | Publishing Portal |
| 53 | BLANKINTERNET#0 | Publishing Site |
| 53 | BLANKINTERNET#1 | Press Releases Site |
| 53 | BLANKINTERNET#2 | Publishing Site with Workflow |
| 54 | SPSMSITEHOST#0 | My Site Host |
| 56 | ENTERWIKI#0 | Enterprise Wiki |
| 61 | visprus#0 | Visio Process Repository |
| 90 | SRCHCENTERLITE#0 | Basic Search Center |
| 90 | SRCHCENTERLITE#1 | Basic Search Center |
| 2000 | SRCHCENTERFAST#0 | FAST Search Center |
| 2764 | ACCSRV#0 | Access Services Site |
| 2764 | ACCSRV#1 | Assets Web Database |
| 2764 | ACCSRV#3 | Charitable Contributions Web Database |
| 2764 | ACCSRV#4 | Contacts Web Database |
| 2764 | ACCSRV#6 | Issues Web Database |
| 2764 | ACCSRV#5 | Projects Web Database |
| 3100 | PPSMASite#0 | PerformancePoint |
| 3200 | BICenterSite#0 | Business Intelligence Center |
| 14483 | OFFILE#0 | (obsolete) Records Center |
| 14483 | OFFILE#1 | Records Center |
Wednesday, May 2, 2012
SharePoint 2010 Site Template ID Numbers
Configure Excel Services data refresh by using the unattended service account
Excel Services in Microsoft SharePoint Server 2010 provides three methods of using Secure Store to refresh the external data source in a workbook
=> You can use an unattended service account
=> You can specify a Secure Store target application in a workbook. (This is known as an embedded connection.)
=> You can use an Office Data Connection (ODC) file that specifies a Secure Store target application
Using the unattended service account involves configuring an Active Directory account and granting it access to your data, storing the credentials for this account in Secure Store, and configuring Excel Services to use the stored credentials when it needs to refresh the data in a workbook.
The following steps are required to configure the unattended service account in Excel Services.
=> Configure a data access account
=> Configure a Secure Store target application for the unattended service account
=> Configure Excel Services Global Settings
=> Configure a workbook to use the unattended service account
=> Configure a data access account
The unattended service account requires an Active Directory account for data access. Have your domain administrator create an Active Directory account that you can use for data access.
Once the account has been created, you must grant this account read access to the data source that you will be using in your data-connected Microsoft Excel workbook. Use the following procedure to create a logon for the data access account in Microsoft SQL Server.
To create a SQL Server logon for the data access account
=> In SQL Server Management Studio, connect to the database engine.
=> In Object Explorer, expand Security.
=> Right-click Logins, and then click New Login.
=> In the Login name box, type the name of the Active Directory account that you created for data
access.
=> In the Select a page section, click User Mapping.
=> Select the Map check box for the database that you want to provide access to, and then, under
Database role membership for: <database>, select the db_datareader check box.
=> Click OK.
Now that you have created a logon for the data access account and granted the account access to your data source, you must create a target application in Secure Store to contain the credentials for the data access account.
Configure a Secure Store target application for the unattended service account
The Secure Store Service uses a target application to define connection parameters and authorized users. The unattended service account is generally considered a catch-all account that is used for general data access. All users are granted access to the unattended service account through the target application.
In order to grant all users data access through the unattended service account, the account that is running the Excel Services application pool is added as a member of the Secure Store target application. If you do not know which account is being used to run the Excel Services, follow these steps to determine which account that is.
To find the Windows identity assigned to the Excel Services application pool
=> On the SharePoint Central Administration Web site home page, click Security.
=> On the Security page, under General Security, click Configure service accounts.
=> On the Service Account page, in the Credential Management section, from the drop-down list, select the application pool that runs Excel Services Application.
When this option is selected, the name of the Excel Services Application appears in the box underneath the drop-down list. This is the Windows identity that you need for the Members list when you configure the unattended service account in Secure Store.
=> Click Cancel.
Once you have determined which account is being used to run the application pool for the Excel Services service application, the next step is to create a target application in Secure Store for the unattended service account. Use the following procedure to create the target application.
To create a target application for the unattended service account
=> On the Central Administration home page, in the Application Management section, click Manage service applications.
=> Click the Secure Store service application.
=> On the ribbon, click New.
=> In the Target Application ID box, type a unique identifier for this target application (for example,
ExcelServicesUnattended).
=> In the Display Name box, type a friendly name or short description.
=> In the Contact E-mail box, type the e-mail address for a contact for this target application.
=> In the Target Application Type drop-down list, select Group.
=> Click Next.
=> Leave the default credential fields, and then click Next.
=> On the Specify the membership settings page:
In the Target Application Administrators box, type the account of the user who will administer this target application.
Note:
You can specify multiple users or an Active Directory group.
=> In the Members box, type the Excel Services application pool account that you located in the previous procedure.
=> Click OK.
=> Once the target application is created, you must specify which credentials should be used by it. These are the credentials of the Active Directory account that you created previously, and which have been granted read access to your data source.
Use the following procedure to set the credentials for the target application.
To set the credentials for the target application
=> On the Secure Store Service Application page, in the Target Application ID column, point to the target application that you just created, click the arrow that appears, and then click Set Credentials.
=> Type the user name and password of the data access account.
=> Click OK.
=> Once you have set the credentials for the target application, the Secure Store Service configuration for the unattended service account is complete. The next step is to configure Excel Services to use this target application for the unattended service account.
Configure Excel Services Global Settings
The unattended service account configuration is part of the Excel Services Global Settings. Use the following procedure to configure the unattended service account in Excel Services.
To configure Excel Services Global Settings
=> On the Central Administration home page, in the Application Management section, click Manage
service applications.
=> On the Manage Service Applications page, click the Excel Services service application.
=> On the Manage the Excel Services page, click Global Settings.
=> On the Excel Services Settings page, in the External Data section, in the Application ID box, type the Target Application ID of the target application that you created.
=> Click OK.
With the Excel Services Global Settings configured, setup of the unattended service account is complete. The next section describes how to configure the Excel Services authentication settings in a data-connected Excel workbook to refresh the data with the unattended service account after the workbook has been published to a SharePoint document library.
Configure a workbook to use the unattended service account
=> You must configure the Excel Services Authentication Settings in the workbook before you publish it to SharePoint Server 2010. Doing so enables the workbook to use the unattended service account to refresh data when the workbook is rendered in Excel Services. Use the following procedure to configure the authentication settings.
To configure Excel Services authentication settings
=> In a data-connected Excel workbook, on the Data tab, click Connections.
=> On the Workbook Connections dialog box, select the data connection that you want to update, and then click Properties.
=> On the Connection Properties dialog box, on the Definition tab, click Authentication Settings.
=> On the Excel Services Authentication Settings dialog box, select the None option, and then click OK.
=> On the Connection Properties dialog box, click OK.
Note:
If you see a warning that the link to the external connection file will be removed, click Yes.
On the Workbook Connections dialog box, click Close.
With the Excel Services Authentication Settings set to None, Excel Services uses the unattended service account to refresh the data in the workbook after you have published it to SharePoint Server 2010
=> You can use an unattended service account
=> You can specify a Secure Store target application in a workbook. (This is known as an embedded connection.)
=> You can use an Office Data Connection (ODC) file that specifies a Secure Store target application
Using the unattended service account involves configuring an Active Directory account and granting it access to your data, storing the credentials for this account in Secure Store, and configuring Excel Services to use the stored credentials when it needs to refresh the data in a workbook.
The following steps are required to configure the unattended service account in Excel Services.
=> Configure a data access account
=> Configure a Secure Store target application for the unattended service account
=> Configure Excel Services Global Settings
=> Configure a workbook to use the unattended service account
=> Configure a data access account
The unattended service account requires an Active Directory account for data access. Have your domain administrator create an Active Directory account that you can use for data access.
Once the account has been created, you must grant this account read access to the data source that you will be using in your data-connected Microsoft Excel workbook. Use the following procedure to create a logon for the data access account in Microsoft SQL Server.
To create a SQL Server logon for the data access account
=> In SQL Server Management Studio, connect to the database engine.
=> In Object Explorer, expand Security.
=> Right-click Logins, and then click New Login.
=> In the Login name box, type the name of the Active Directory account that you created for data
access.
=> In the Select a page section, click User Mapping.
=> Select the Map check box for the database that you want to provide access to, and then, under
Database role membership for: <database>, select the db_datareader check box.
=> Click OK.
Now that you have created a logon for the data access account and granted the account access to your data source, you must create a target application in Secure Store to contain the credentials for the data access account.
Configure a Secure Store target application for the unattended service account
The Secure Store Service uses a target application to define connection parameters and authorized users. The unattended service account is generally considered a catch-all account that is used for general data access. All users are granted access to the unattended service account through the target application.
In order to grant all users data access through the unattended service account, the account that is running the Excel Services application pool is added as a member of the Secure Store target application. If you do not know which account is being used to run the Excel Services, follow these steps to determine which account that is.
To find the Windows identity assigned to the Excel Services application pool
=> On the SharePoint Central Administration Web site home page, click Security.
=> On the Security page, under General Security, click Configure service accounts.
=> On the Service Account page, in the Credential Management section, from the drop-down list, select the application pool that runs Excel Services Application.
When this option is selected, the name of the Excel Services Application appears in the box underneath the drop-down list. This is the Windows identity that you need for the Members list when you configure the unattended service account in Secure Store.
=> Click Cancel.
Once you have determined which account is being used to run the application pool for the Excel Services service application, the next step is to create a target application in Secure Store for the unattended service account. Use the following procedure to create the target application.
To create a target application for the unattended service account
=> On the Central Administration home page, in the Application Management section, click Manage service applications.
=> Click the Secure Store service application.
=> On the ribbon, click New.
=> In the Target Application ID box, type a unique identifier for this target application (for example,
ExcelServicesUnattended).
=> In the Display Name box, type a friendly name or short description.
=> In the Contact E-mail box, type the e-mail address for a contact for this target application.
=> In the Target Application Type drop-down list, select Group.
=> Click Next.
=> Leave the default credential fields, and then click Next.
=> On the Specify the membership settings page:
In the Target Application Administrators box, type the account of the user who will administer this target application.
Note:
You can specify multiple users or an Active Directory group.
=> In the Members box, type the Excel Services application pool account that you located in the previous procedure.
=> Click OK.
=> Once the target application is created, you must specify which credentials should be used by it. These are the credentials of the Active Directory account that you created previously, and which have been granted read access to your data source.
Use the following procedure to set the credentials for the target application.
To set the credentials for the target application
=> On the Secure Store Service Application page, in the Target Application ID column, point to the target application that you just created, click the arrow that appears, and then click Set Credentials.
=> Type the user name and password of the data access account.
=> Click OK.
=> Once you have set the credentials for the target application, the Secure Store Service configuration for the unattended service account is complete. The next step is to configure Excel Services to use this target application for the unattended service account.
Configure Excel Services Global Settings
The unattended service account configuration is part of the Excel Services Global Settings. Use the following procedure to configure the unattended service account in Excel Services.
To configure Excel Services Global Settings
=> On the Central Administration home page, in the Application Management section, click Manage
service applications.
=> On the Manage Service Applications page, click the Excel Services service application.
=> On the Manage the Excel Services page, click Global Settings.
=> On the Excel Services Settings page, in the External Data section, in the Application ID box, type the Target Application ID of the target application that you created.
=> Click OK.
With the Excel Services Global Settings configured, setup of the unattended service account is complete. The next section describes how to configure the Excel Services authentication settings in a data-connected Excel workbook to refresh the data with the unattended service account after the workbook has been published to a SharePoint document library.
Configure a workbook to use the unattended service account
=> You must configure the Excel Services Authentication Settings in the workbook before you publish it to SharePoint Server 2010. Doing so enables the workbook to use the unattended service account to refresh data when the workbook is rendered in Excel Services. Use the following procedure to configure the authentication settings.
To configure Excel Services authentication settings
=> In a data-connected Excel workbook, on the Data tab, click Connections.
=> On the Workbook Connections dialog box, select the data connection that you want to update, and then click Properties.
=> On the Connection Properties dialog box, on the Definition tab, click Authentication Settings.
=> On the Excel Services Authentication Settings dialog box, select the None option, and then click OK.
=> On the Connection Properties dialog box, click OK.
Note:
If you see a warning that the link to the external connection file will be removed, click Yes.
On the Workbook Connections dialog box, click Close.
With the Excel Services Authentication Settings set to None, Excel Services uses the unattended service account to refresh the data in the workbook after you have published it to SharePoint Server 2010
Friday, April 27, 2012
Configure Recycle Bin settings in Sharepoint 2010
Recycle Bins are used to help users protect and recover data.Microsoft SharePoint Foundation 2010 supports two stages of Recycle Bins: the first-stage Recycle Bin and second-stage Recycle Bin.
When a user deletes an item, the item is automatically sent to the first-stage Recycle Bin. By default, when an item is deleted from the first-stage Recycle Bin, the item is sent to the second-stage Recycle Bin. A site collection administrator can restore items from the second-stage Recycle Bin.
You turn on and configure Recycle Bins at the Web application level. By default, Recycle Bins are turned on in all the site collections in a Web application.
Note: You cannot perform this task by using Windows PowerShell cmdlets. You can use the Stsadm command-line tool or the SharePoint Central Administration Web site instead.
To configure Recycle Bin settings by using Central Administration
Verify that the user account that is performing this procedure is a member of the Farm Administrators SharePoint group.
=> On the SharePoint Central Administration Web site, click Application Management.
=> On the Application Management page, click Manage Web Applications.
=> Click the Web application for which you want to configure Recycle Bin settings. The ribbon becomes
active.
=> On the ribbon, click the General Settings drop-down menu, and then click General Settings.
=> On the Web Application General Settings page, in the Recycle Bin section, you can configure the
following settings:
You can set the Recycle Bins for the Web application to be On or Off. By default, Recycle Bins are turned on.
Note:
If you turn off the Recycle Bins, any existing items in both the first and second-stage Recycle Bins are deleted. Depending on how much data is contained in the Recycle Bins, deleting these items can take a long time.
You can specify a time after which items in the Recycle Bins are deleted, or you can specify that these items should never be deleted. By default, items are deleted after 30 days.
You can specify a percentage of live site quota for second-stage deleted items. The default setting is 50 percent. You can also turn off second-stage Recycle Bins. If you select Off, site collection administrators cannot recover items deleted from end-user Recycle Bins.The second-stage Recycle Bin quota percentage must be a value from 1 through 500.
7.After you have finished configuring the Recycle Bins, click OK.
Powershell command to Turn off the session state service on the farm
Disable-SPSessionStateService [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-WhatIf [<SwitchParameter>]]
Detailed Description
The Disable-SPSessionStateService cmdlet turns off the session state service. If your farm does not depend on session state service, we recommend that you disable it.
The Disable-SPSessionStateService cmdlet turns off the session state service. If your farm does not depend on session state service, we recommend that you disable it.
Note:
When session state is disabled, some Microsoft SharePoint Server 2010 services, components, and third-party components no longer function. Changing this property modifies the Web.config file on every content Web application on every server in the farm.
When session state is disabled, some Microsoft SharePoint Server 2010 services, components, and third-party components no longer function. Changing this property modifies the Web.config file on every content Web application on every server in the farm.
Powershell command to Disable a timer job
Disable-SPTimerJob [-Identity] <SPTimerJobPipeBind> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-WhatIf [<SwitchParameter>]]
Identity -
Specifies the timer job to disable.
The type must be a valid GUID, in the form 12345678-90ab-cdef-1234-567890bcdefgh; a valid name of a timer job (for example, TimerJob1); or an instance of a valid SPTimerJob object.
Detailed Description
The Disable-SPTimerJob cmdlet disables a timer job.
Powershell command to disable an installed SharePoint Feature at a given scope
Disable-SPFeature [-Identity] <SPFeatureDefinitionPipeBind> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-Force <SwitchParameter>] [-Url <String>] [-WhatIf [<SwitchParameter>]]
Identity -
Specifies the name of the Feature or GUID to disable.
The type must be the name of the Feature folder located in the 14\Template\Features folder or GUID, in the format 21d186e1-7036-4092-a825-0eb6709e9281.
Identity -
Specifies the name of the Feature or GUID to disable.
The type must be the name of the Feature folder located in the 14\Template\Features folder or GUID, in the format 21d186e1-7036-4092-a825-0eb6709e9281.
Other Parameters are optional
Detailed Description
The Disable-SPFeature cmdlet disables a SharePoint Feature at the given scope. If the scope of the Feature is the farm, the URL is not needed. Otherwise, provide the URL at which this Feature is to be deactivated (explicit scope is not needed).
Perform a backup of a site collection Using powershell Command
Backup-SPSite [-Identity] <SPSitePipeBind> -Path <String> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-Force <SwitchParameter>] [-NoSiteLock <SwitchParameter>] [-UseSqlSnapshot <SwitchParameter>] [-WhatIf [<SwitchParameter>]]
Identity -
Specifies the URL or GUID of the site collection to be backed up.
For example, a valid URL, such as http://server_name/sites/site_name or a GUID such as, "01234567-89ab-cdef-0123-456789abcdef"
Path -
Specifies the full path to the backup file (that is, C:\Backup\site_name.bak.
Identity -
Specifies the URL or GUID of the site collection to be backed up.
For example, a valid URL, such as http://server_name/sites/site_name or a GUID such as, "01234567-89ab-cdef-0123-456789abcdef"
Path -
Specifies the full path to the backup file (that is, C:\Backup\site_name.bak.
Detailed Description
The Backup-SPSite cmdlet performs a backup of the site collection when the Identity parameter is used.
By default, the site collection will be set to read-only for the duration of the backup to reduce the potential for user activity during the backup operation to corrupt the backup. If you have SQL Server Enterprise Edition, we recommend that UseSqlSnapshot parameter be used because this ensures a valid backup while it allows users to continue reading and writing to the site collection during the backup.
Subscribe to:
Posts (Atom)