Site Collection Quotas

When you set a quota limit for storage, you can set two values: a warning value and a maximum value. When a site collection passes the warning limit, an e-mail message is sent to the site administrator and owner notifying them that their site collection is near to their storage quota. E-mail messages are sent daily until the storage level drops below the warning level. When a site collection meets the maximum limit, another e-mail message is sent to the owner and administrator, and no new content can be added to the site collection.

There are 2 important questions based on site quotas, such as:

How to manage quota template?

How to Change an existing quota template?

Let’s see and understand the complete process:

How to create a quota template

1.   Click Start, point to All Programs, point to Administrative Tools, and then click SharePoint Central Administration.

2.   On the Central Administration page, under Component Configuration, click Manage quotas and locks.

3.   On the Manage Quotas and Locks page, click Manage Quota Templates.

4.   On the Manage Quota Templates page, in the Template name area, select create a new quota template.

5.   In the Template to start from box, select a template to base your new template on.

6.   In the New template name box, type the name to use for your new quota template.

7.   In the Storage Limit Values section, select the Limit site storage to a maximum of: MB check box, and then type the amount of storage to allow at a maximum.

8.   Select the Send warning e-mail when site storage reaches MB check box, and then type the amount of storage to allow before sending a warning e-mail message.

9.   When you click OK, the new template is added to the list of available templates, and the page is refreshed.

How to Change an existing quota template?

1.   Click Start, point to All Programs, point to Administrative Tools, and then click SharePoint Central Administration.

2.   On the Central Administration page, under Component Configuration, click Manage quotas and locks.

3.   On the Manage Quotas and Locks page, click Manage Quota Templates.

4.   On the Manage Quota Templates page, in the Template name area, select edit an existing template.

5.   In the Template to modify box, select the quota template you want to change.

6.   Update the options you want to change, and then click OK.

7.   When you click OK, the template is updated, and the page is refreshed.

Please let me know in case of any further queries/questions regarding the above mentioned information. I would be more than happy to help you as well as resolves your issues, Thank you J J

Excel Services trusted file locations

How to add a file in excel trusted file locations:

1.   On the SharePoint Central Administration Web site home page

2.   In the Application Management section,

3.   Click Manage service applications.

4.   On the Manage service applications page

5.   Click the Excel Services service application that you want to configure.

6.   On the Manage Excel Services Application page

7.   Click Trusted File Locations.

8.   On the Excel Services Application Trusted File Locations page,

9.   Click Add Trusted File Location.

SharePoint 2010 Redirect Web Part

This is a sandbox web part for SharePoint 2010.

The web part will redirect a user to a given page if that user is effectively part of a SharePoint group. So If a user is in Active Directory group and the AD group is in the given SharePoint group, the user will be redirected.

Please use the following Link

http://sharepointredirect.codeplex.com/

what is a SharePoint redirect what part?The SharePoint redirect Web parts is a SharePoint 2010 sandbox solution. It gives you a Web parts that you can place on any SharePoint page. The web parts will automatically redirects the user to any specified page based on the user's membership to a SharePoint group whether this membership is a direct membership or an indirect membership.

A direct membership means that the user is directly added to the SharePoint group. An indirect membership means that the user for example belongs to an active directory group and that active directory group is part of the SharePoint group.

installation

This solution is simple. The only file you need is the WSP file. And the only access you need is to be a SharePoint site collection administrator.

Simply navigate to the site collection site settings page link like on solutions. Add a solution by selecting the WSP file. Then activate the solution. Once you do that browse to any page where you want and the Web part and try to insert a web part to the page. Under the custom Web part category you will see the Web part.

configuration

Configuring the web part is easy. Simply edit the web parts and you'll see three main fields to to use. The first one is the SharePoint group name. This is the group that the current user will be tested against and the user will be redirected based on whether they belong to that group or not. The second field is then redirect to page. This is the page to be redirected to event the user belongs to that SharePoint group. The last field is a status field which simply either makes the web part active or inactive.

Uses
This web part is very useful in any SharePoint environment. Espeically in hosted SharePoint environments where uploading server side code is not allowed.

Data Refresh Failed

When we use external data connections then the data connection file talks with the excel services by means of authentication. These authentications are of three types:

1.       Windows

2.       None

3.       SSO

In Windows authentication mode, Excel Services attempts to use the Windows identity of the user who is logged on when authenticating with the external data source.

 

In SSO option, The SSO service uses a centralized database to store authentication credentials. Excel Services uses the SSO application ID that is specified for the data connection to request the credentials when authenticating with the data source.

Now the options remains is NONE-Selecting None for the authentication mode in the Excel Services Authentication Settings dialog box causes Excel Services to assume that the connection string contains the user name and password needed to authenticate with the data source. If the connection string requires the use of integrated security, the Excel Services Unattended Account is used for authentication.

To use the None option, we need to have:

Configured the Unattended Account. Excel Services impersonates the Unattended Account when it tries to authenticate with a data source by using either no authentication setting (None), or single sign-on (SSO) when the SSO application is not storing Windows account credentials.

Where is this unattended account we need to specify?

Central Administration

Shared Service provider (SSP

Excel service settings

Unattended account.

Here is the screenshot regarding this: 

If you have any queries / questions regarding the above mentioned information then please let me know.
I would be more than happy to help you as well as resolves your issues, Thank you

Create a permission level

How to create a permission level in SharePoint 2010?

1. Verify that you have one of the following administrative credentials:

· You are a member of the Administrators group for the site collection.

· You are a member of the Owners group for the site.

· You have the Manage Permissions permission.

2. On the Site Settings page,
3. Under Users and Permissions,
4. Click Site permissions.
5. In the Manage section of the ribbon
6. Click Permission Levels.
7. On the toolbar,
8. Click Add a Permission Level.
9. On the Add a Permission Level page, in the Name field, type a name for the new permission level.
10. In the Description field, type a description of the new permission level.
11. In the list of permissions, select the check boxes to add permissions to the permission level.
12. Click Create.

That’s it and you are done J

If you have any queries regarding the above mentioned information then please let me know.

I would be more than happy to help you as well as resolves your issues, Thank you