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

Folder permission in sharepoint foundation 2010

If your site contains confidential data and you wants to restrict that data only for certain users and groups then this concept comes into the picture. For this, you need break permissions inheritance, and then edit permissions for the content on its own permissions page.

By default, all sub-sites, lists, and libraries within a site inherit permissions settings from whatever is directly above them in the site hierarchy. For example, a sub-site inherits permissions from the site above it. A list item inherits permissions from the list that it is in. A list inherits permissions from the site is on. In each of these cases, the content from which permissions are inherited is called the parent.

Here are the detailed steps:

1.     Open the list that you want to restrict access to.

2.     On the List Tools tab

3.     Click List to open the gallery of commands specific to the list.

4.     On the ribbon

5.     Click the List Permissions button.

The permissions page for the list opens, with a yellow status bar that explains that the list inherits permission from its parent site.

6.     Click the Stop Inheriting Permissions button.

Note: Now the list is disconnected from the parent site.

Two important things to note:

·         The list still has the same permission settings that it did before. But now, instead of inheriting permissions from the parent, it has its own copy of the parent’s permissions.

·         Changes that you make to the permissions settings for the parent site will not be inherited by this list.

Remove groups or users you don’t want

1.     In the Name section of the permissions page, select the checkboxes for the groups or users who should not have access to this list.

2.     Click Remove User Permissions.

The permissions page updates to show that the group or user no longer has permissions to the list.


Grant access to your Team members:
1. On the permissions page for the list, on the Edit tab, click the Grant Permissions button.
2. Type the name of the group or the individual you want to grant access to in the Users/Groups box.
3. Choose the level of permissions you want the group or individuals to have.
4. Click OK


That's it and You are done J J J

Custom Robots.txt

Robots.txt file helps you allow or block the search engine Robots to Crawl/index the pages. Now you can control what content you want to crawl or ignore by search engine. 

 

Not only this now you can use the robots.txt file to block search engines from crawling different parts of your blog like pages, archives, tags.  You can also add sitemap URL to BlogSpot’s robots.txt file for indexing. 

 

You can access the robots.txt file of any blog by visiting this url (http://yourblog.blogspot.com/robot.txt)

Warning!! If you don’t have much knowledge about this, never try to changing or Modifiying this file because it can effect the search engine visibility.