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

Customize an existing permission level

If you wants to create custom permission level that is a replica or identical to an existing default permission level and you do not need to use the default permission level, you can customize the default permission level.

To customize an existing permission level

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, under Users and Permissions, click Site permissions.
3. In the Manage section of the ribbon, click Permission Levels.
4. In the list of permission levels, click the name of the permission level you want to customize.
5. In the list of permissions, select or clear the check boxes to add permissions to or remove permissions from the permission level.
6. Click Submit.

That’s it and you are done J J

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