A usage report is not available for this site. Usage processing may be disabled on this server or the usage data for this site has not been processed yet.

When you try to view the Site Usage Report page, you may see the following message:
A usage report is not available for this site. Usage processing may be disabled on this server or the usage data for this site has not been processed yet.


Logging and usage processing must be turned on, and users must have visited a page on your site before any data can appear on the Site Usage Report page. Contact your site administrator to verify that logging and usage processing are turned on in Windows SharePoint Services 3.0. Also, if the site is new (created today) or has not been used before today, no data will appear until the usage log processing is completed (usually within 24 hours). Furthermore, if there has been no activity on the site for the past 31 days, you will see the "no data" message.
How to Enable Windows SharePoint Services usage logging:

Enable Windows SharePoint Services usage logging for the farm hosting the Web application containing the SSP. Please refer the following steps to enable usage logging for the farm:

-On the Central Administration home page, click Operations. 

-On the Operations page, in the Logging and Reporting section, click Usage analysis processing. 

-On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging. 

-Type a log file location and number of log files to create. 

-In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing. 

-Click OK.

Enable portal usage reporting:

After Windows SharePoint Services usage logging is enabled in the server farm, SSP administrators must enable the portal usage reporting service. SSP administrators can control the complexity of usage analysis processing, and select whether or not reporting is enabled for search queries. 

Please refer the following steps to enable portal usage reporting:

-On Central Administration home page, click the Shared Service Provider listed under Shared Services Administration in the Quick Launch bar. 
-On the SSP home page, in the Portal Usage Reporting section, click Usage reporting. 
-On the Configure Advanced Usage Analysis Processing page, in the Processing Settings section, click Enable advanced usage analysis processing. 
-In the Search Query Logging section, select Enable search query logging. 
-Click OK.

Note: If advanced usage analysis processing is not selected, usage reporting statistics will be minimal.

Reset Internet Information Server:


-Go to the Start Button and click Run 
-Type IISReset and click OK.

Activate portal usage reporting

After portal usage reporting is enabled for the SSP, site collection administrators must activate the reporting feature. Until the reporting feature is activated on a site collection, usage reports are not available. 

Please refer the following steps to activate the reporting feature:

-On the Site Actions menu, click Site Settings. 
-On the Site Settings page, in the Site Collection Administration section, click Site collection features. 
-On the Site Collection Features page, click the Activate button for the Reporting feature.

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

Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit. You must save your work to another location. Contact your administrator to change the quota limits for the Web site.

User trying to save file in shared documents on personal site. It’s telling user “ Your changes could not be saved because this SharePoint Web site has exceeded the storage quota limit.

A quota specifies storage limit values for the maximum amount of data that can be stored in a site collection. Quotas also specify the storage size that, when reached, triggers an e-mail alert to the site collection administrator. Quota templates apply these settings to any site collection in a SharePoint farm.

To Track Quotas:
-Site administrators can go to Site Actions -Site Settings and click "Storage space allocation" to review space usage.
-Here they can display lists of libraries, documents, lists and Recycle Bin contents.
-These lists are by default sorted on size, descending. They can be resorted on Date Modified or Size

Resolution:
Server administrators are able to set limits on the amount of storage space that sites can use on the server. Contact your server administrator to request that the storage quota for the Web site be increased.

Exact Steps:
1. Go to your Central Administration a Application
2. On the Application Management page, in the SharePoint Site Management section, click Quota Templates.

I have also seen that user faced this kind of error message usually for their mysites because Personal site’s Limit site storage is set to 100M by default.

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, Thanks..

Opening PDFs in SharePoint 2010

As i am working in SharePoint support(administration), i faced so many issues on day-2-day basis. yesterday i had faced one issue which belongs to opening of pdf files.


User Requirement/Issue Description: I have a document library with a PDF file. Whenever I click on the PDF file, I am prompted to save the file. I do not get the option of opening the file, I am forced to save it. What I want is for the PDF file to open, either in the browser or in a separate Adobe Reader window, depending on the Adobe Reader settings. 


Please refer the following steps to resolve this issue:


1. Open the central administration
2. Click Manage Web Applications
3. Click on the web app you want to change, and go to ‘General Settings’
4. Scroll down and reach the section called as ‘Browser File Handling’
5. Change the radio box from Strict to Permissive.
6. Click OK.
7. Settings has been successfully configured :-)


Go to the sharepoint document library and try to open the PDF documents & check the results !!


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

Creating a New Document Template

Many users already know that we can create a new Word document from within a document library. However, Microsoft Office SharePoint Server (MOSS) 2007 takes this one step ahead by giving you the option to create any type of document you want within the same document library. You could do this in previous versions, but it was difficult to implement and was not an out-of-the-box solution — and it generally resulted in a separate document library for each document type. With MOSS 2007, this feature is now part of the application and is reasonably easy to implement at both the site and document library level.

One of the most powerful new features in SharePoint 2007 are content types. One of the benefits of having content types is that we now can have multiple document templates in one single document library. Each content type can have a document template.

Here are the steps to implement this:

1. Create a Document Library

2. Within the site that contains that Document Library, go to Site Actions > Site Settings

3. Under the Galleries section, click on Site Content Types

4. Click the Create link at the top of the list.

5. Give your Content Type a name and description.

6. Under Parent Content Type choose “Select parent content type from: Document Content Types” and “Parent Content Type: Document”

7. If this is the first time you’re creating a new Content Type, then you should choose to place it in a “New Group” and give it a meaningful name.

8. After creating the Content Type, you have the option of customizing some of the settings. Click on ‘Advanced Settings.’

9. Choose to upload a New Document Template.

10. Keep the default settings and press OK.

Now we’ll have to go back to the Document Library that we had created earlier. Within that Document Library:

11. Click on Settings > Document Library Settings

12. Under the General Settings Section, click on ‘Advanced Settings’

13. change ‘Allow management of content types’ from NO to YES. Keep the other settings as it is, and click OK.

14. Under the Content Types Section, click ‘Add from existing site content types’

15. Now you’ll have the option of choosing the from the menus, the Content Type Group and Content Type that was created earlier.

16. Go back to the Document Library, click the arrow next to the ‘New’ button and you should now have a new Document Template to choose from...

If you have any queries/questions regarding the above mentioned info then please let me know, Thanks...

Your personal site cannot be created because Self-Service Site Creation is not enabled. Contact your site administrator for more information.

I have installed MOSS 2007 enterprise in a simple-server farm mode using a SQL 2005 backend.

It appears I have everything else working except the My Site functionality.

When I click on My Site, I get:

Your personal site cannot be created because Self-Service Site Creation is not enabled. Contact your site administrator for more information.

So then I enable Self-Service Site Creation for the web app that is hosting the My Site service and try again. This time I receive:

There has been an error creating the personal site. Contact your site administrator for more information.

After doing some troubleshooting, i came to know about the exact resolution.

Please refer the following steps regarding the same:

Resolution:

Just follow the below steps to add "Personal" path as "Managed Path".

1. Go to "Central admin"

2. Select "Application Management" and select the specific "Web Application".

3. Type the 'MySite Host' URL. (I have created new site collection for MySite. So, I have added 'sites/mysite/personal').

4. Click OK.
Thats it...

You cannot use SharePoint. Your System Administrator has turned off this feature.

Hello Everybody,

Recently i was unable to open the attachments from outlook, not all but the attachments which was from sharepoint communications i.e. autogenerated emails from Alerts.

OR you will face this issue:

Any Task list | Actions toolbar item | Connect to Outlook
Receive an alert (from task, list, calendar, file, etc) in Outlook and try to open it.

Error Message: You cannot use SharePoint. Your System Administrator has turned off this feature.

Resolution:

I made the following changes in Registry Key and able to make it work. Now i can open all the attachments without any issues.

1.On the command-line and run REGEDIT

2.Go to

HKEY_CURRENT_USER/Software/Microsoft/Office/14.0/Outlook/Options/wss

3.Double-click on the disable and change it to 0 from 1 and click ok.

4. Restart outlook and check the results

It will work as expected, Thanks

If you have any queries/questions regarding the above mentioned information then please let me know, Thanks

How to create a survey in sharepoint 2010

Please refer the following steps regarding the survey creation.

-Click the Site Actions menu and select the Create option. The Create page will open

-Under Tracking, click Survey.

-Enter the name for the Survey as per your requirements

-Keep the default options as it is (eg. click Yes to display the survey in the quick launch)

-Select the proper options in the survey options.

-Next, Select the question type and settings and click Next Question

-When you’ve entered all questions, click Finish.
if you wants to make any modifications in the created survey then please follow these steps:

-open the survey list that we have just created

-Settings

-Survey Settings

you will see everything listed out here regarding the survey columns,survey permissions,advanced settings for the survey etc...

If you face any issues regarding the above mentioned steps then please let me know... I would be more than happy to help you as well as resolves your issues, Thanks

Create a Custom View for Survey List

In SharePoint, custom views are used to display the items in a list/libraries with custom look and feel.Therefore you have to choose a view format like Standard View, Calendar View, Datasheet View or Gantt View and accordingly you can customize the display style by choosing Filter condition, Sort method, Group By condition etc. SharePoint allows us to create custom views for the list and libraries. But for the Survey type list, SharePoint documentation doesn't mention anything about creating a custom view. Below mentioned steps are can be adapted to create a custom view for Survey List.


-Open a SharePoint Site......Open the Survey List. 


-Find the ListID from the URL like


List=%7BF2141E9F%2D8EA2%2D42EE%2DA965%2D52F1D7362066%7D


-Now change the URL in the browser as


http://SiteName:PortNo/_layouts/ViewType.aspx?List=%7BF2141E9F%2D8EA2%2D42EE%2DA965%2D52F1D7362066%7D


-Then choose a view format for the survey list.


-Type a custom View Name.


-In the same page open the style tab, choose a style for this view e.g Basic Table 


-Then press OK to create the view.


-Custom view has been successfully created for your survey, Thanks..


If you have any queries/questions regarding the above mentioned info then please let me know, Thanks..

The List cannot be displayed in Datasheet view

SharePoint Lists are very useful in so many ways as it has the functionality of copy and paste.

We can use the SharePoint List in 2 ways:

1. Graphical User Interface (GUI)/ Standard View

2. Excel Spread sheet view /Datasheet View

Excel Spread sheet view is very powerful as we can easily transfer the data from your machine to SharePoint list by simply using copy and paste.

When we tried to switch from standard view to datasheet view then most of the users face the following error message:

The List cannot be displayed in Datasheet view for one or more of the following reasons:

-A datasheet component compatible with windows SharePoint services is not installed.

-Your Web browser does not support ActiveX controls

-Support for ActiveX controls is disabled.

Note: I have seen that most of the users face this kind of issue if they are using Internet Explorer 6.0 (IE 6). 

Please follow the below mentioned steps to resolve the issue:

Resolution Steps:

1. Windows SharePoint Service Support options for Microsoft Office should be installed (applicable for Office 2003 as well as for Office 2007)

How to enable this option:

A.   Start-Control Panel-Add or Remove Programs-click on Microsoft Office and then Change

B.   Add/Remove Features

C.   Expand the Office Tools category.

D.  Next verify that you have both the Microsoft Office Access Web Datasheet Component and the Windows SharePoint Services Support component installed.

E.   If these components are not installed choose to run them from your computer and then click the Continue button and go through the installation process. You may need your Office 2007 install media.

2. Next you want to verify that you can run ActiveX controls in Internet Explorer. To do this open IE and go to the Tools menu > Internet options

3. Next click on the Security tab and for your Trusted sites click (choose Internet if you do not add your SharePoint sites to your Trusted Sites) on the Custom level button

4. Verify that you can use previously unused ActiveX controls.

5. Verify that you can download signed ActiveX controls and that you can run ActiveX controls and plug-ins.

6. The next setting is –> select "Enable" for Script ActiveX controls marked safe for scripting.

7. Adjust these settings accordingly and then click OK twice to return to Internet Explorer.

8. You may need to close Internet Explorer and re-open the program before your new settings take hold and become active.

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

The formula contains a syntax error or is not supported. Troubleshoot issues with windows SharePoint services.

Hello Everybody,

This is regarding the above mentioned error message. Working on SharePoint from last few years, i had seen customers used the date functions on regular basis inside their SharePoint list and libraries.

Depending the same, i worked on similar case which was weird in the start but finally the issue has been  resolved with some perfect break-fix.

Let me describe the issue first:

-User had created one custom list.

-Created three columns: two were custom and one is calculated.
    Custom Columns:  Date1 and Date2 with content type Date and Time.
    Calculated Column:CalcDate with content type calculated.

-User wanted to use basic date functions as difference between two dates, TEXT Function,DATE(year,month,day) etc...

-Custom columns has been created without any issues but when he were using a formula inside calculated column then he got the following error message: 

Troubleshooting done:

-Created a same list on my personal mysite and used the same functions, it worked without any problems...
-Compared features between my site and user's site. Found only difference i.e. publishing feature was activated on my site but wait wait....this is of no use because after deactivating the publishing feature also, i can use the same date functions.
-We have site collections created under so many domains, so i had used a site collection which belongs to different domain & still i can use the date functions without any issues...
-I had used different site collection which belongs to same domain which is used by user also, and here also i can use without any problems...

Workaround:

-Save the SharePoint list as template on which we can use the date functions without any problems.

Next step is very simple, go to the affected site collection list gallery and upload ( please refer the following steps):

-open the site collection
-site actions
-site settings
-Galleries
-List Templates

Resolution:

You just have to use ";" instead of "," it works fine without any issues..

Examples:
+Calculate the difference between two dates:

=DATEDIF([Column1]; [Column2];"d")

Please refer the below mentioned Microsoft published article which is excellent as it contains a basic functions that we can use in SharePoint.
 
http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA010105479.aspx?CTT=3

If you face any queries /questions regarding the above mentioned procedure/information then please let me know...

I would be more than happy to help you as well as resolves your issues. Thank you very much once again :-)

Word experience an error trying to open the file / Word has encountered a problem

Right from last few days, i am trying to explorer office 2010 which is very advanced as compare to previous office suites n thats why i am heavily testing 'Word,Excel n PowerPoint' documents which are most commonly used by users.

while testing, i had found some strange errors which causes a lot of headache if you don't find the resolution quickly.

But don't worry and say cheers :-) as i have the resolution for this which will help everybody to get rid of this.

Whenever I try to open the Word 2010 /PowerPoint 2010/Excel 2010 documents stored in the SharePoint document libraries, I get the following error.

Resolution:

Please follow the below mentioned steps that will resolves your issues:1. Run one οf the Personnel 2010 application (e.g. Word 2010).
2. Click οn File menu, аnԁ select Options.
3. In the “Options” dialog, select Trust Center іn the left pane.
4. Click οn Trust Center Settings іn the rіɡht pane.
5. Select Protected View іn the left pane οf “Trust Center” dialog.
6. Disable аnу οf аƖƖ οf the protected view options аѕ below bу unticking thе check boxes:
* Enable Protected View fοr files thаt fail substantiation
* Enable Protected View fοr files originating frοm the Internet
* Enable Protected View fοr files located іn potentially unsafe locations
* Enable Protected View fοr Outlook attachments

Please refer the below mentioned screen-shot for detailed information:

I hope the above information will helps you resolve your issues...In case of any queries/questions then please let me know.. I would be more than happy to help you as well as resolves your issues, Thanks again :-) :-)

 

DataSheet views in Sharepoint 2007 don't work with Office 2010

I have installed Office 2010 (64 bit) in my windows 7 machine and did some testing with sharepoint 2007 sites.

As list and document libraries are the most common used components in SharePoint sites so i had started my testing with these ones and found out one problem /error message which takes some time to resolved it completely.

I would like to share my resolution with all of you so that you do not have to waste your time while digging the same problem.

I went to my SharePoint 2007 site and tried to edit a custom list in datasheet view. I’ve got an above mentioned error message :

The list cannot be displayed in Datasheet view for one or more of the following Reasons

Resolution:

Various editions of Microsoft Office 2007 include SharePoint support component, which is installed by default:

-Microsoft Office
-Office Tools
-Windows SharePoint Services Support.

Specifically the “Edit in datasheet” feature is supported by the sub-component named “Microsoft Office Access Web Datasheet Component”. I went and checked out the components installed for my Office 2010 – and the various unnecessary components were marked as installed:

What you have to do:

install back Windows SharePoint Services Support for Office 2007. Below is a screen shot – I only needed this specific part of the office and nothing else:



Now the “View in Datasheet” worked for me.

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

Office 2010 does not open SharePoint 2007 documents

I have been using Office 2010 but have been getting into complications while updating documents in a Share Point 2007 atmosphere. When I attempt to open a sharepoint document in Office 2010 . I got an error-'cannot open document' . The strange thing is if I save the same document from sharepoint to the Hard-Drive it opens without an issue.

I would like to share the resolution that worked for me and hope it will work for all the users too :-)

1. Open up Internet Explorer
2. Click Tools –> Internet Options
3. Click the Connections tab
4. Click LAN settings
5. Check “Use a proxy server for your LAN (These settings will not apply to dial-up or VPN connections).”
6. Enter 127.0.0.1 for the address
7. Click Advanced
8. In the Exceptions type: *.*
9. Click Ok

You should now be able to browse to a SharePoint site, click an Office document and have it successfully open in your Office 2010 client.

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

Exam 70-668: Microsoft SharePoint 2010, Administrator

Designing a SharePoint 2010 Farm Topology

# Design physical architecture.
-This objective may include but is not limited to: translating information architecture to physical architecture, determining capacity for a SharePoint farm (storage, number of users, bandwidth utilization, intranet/extranet, hardware), and scaling Web farm and services infrastructure

#Plan for farm deployment.
-This objective may include but is not limited to: sequential deployment, planning standalone deployment (Microsoft SQL Server Express), planning single-server farm (SQL Server), planning multi-server deployment in an N-Tier Farm, and designing a SharePoint virtual environment

# Plan for availability.
-This objective may include but is not limited to: designing SQL Server failover clustering strategy, types of availability (high-performance, acceptable downtime, Recovery Point Objective, Recovery Time Objective ), types of mirroring, high availability, high protection, whole farm as a failover cluster, and designing the Web Front-End NLB strategy

#Design SharePoint integration with network infrastructure.
-This objective may include but is not limited to: planning for internal and external farm communications, establishing network perimeter configuration, networking, Active Directory, DNS, SQL storage, IIS, and analyzing infrastructure services

# Design logical taxonomy.
-This objective may include but is not limited to: planning sites and site collections, planning for collaboration sites, planning My Site sites, planning for zones, planning for Service Applications, Web applications, content databases, sites and sub-sites vs. libraries, libraries vs. folders vs. document sets, security boundaries, site hierarchy, and content deployment path methodology

#Plan for sandbox solutions.
-This objective may include but is not limited to: content isolation, feature deployments, and trusted solutions


Planning for Search and Business Solutions

#Define search requirements.
-This objective may include but is not limited to: types of data, types of distribution (Internet, extranet), segregation of data, index file location, index size, federation requirements, content sources, search scopes, search taxonomy, server name mappings, promoting or demoting exclusions, synonyms and compound search processing, and defining facets for search

#Enterprise content management.
-This objective may include but is not limited to: records management, BPM (record deployment), document management, metadata planning, information management policies, implement data taxonomy structure, Web Content Management (WCM), and Information Rights Management (IRM)

#Social computing and collaboration.
-This objective may include but is not limited to: user profile service, user profiles, organization profiles, audiences, My Sites, social tags, and planning enterprise wikis, blogs, and personalization sites

#Business intelligence strategy.
-This objective may include but is not limited to: PerformancePoint service (dashboards and scorecards), Excel Services Service, Visio Graphics Service, SQL Reporting Services, chart Web parts, and report center


Planning SharePoint 2010 Deployment

#Service applications.
-This objective may include but is not limited to: formulating a Business Connectivity Services (BCS) strategy, planning a Microsoft Excel Services strategy, implementing a BI solution, planning service application server roles, and planning a Web server forms strategy (Plan InfoPath Forms Services)

#SharePoint component strategy.
-This objective may include but is not limited to: Web parts, Web applications, Microsoft .NET, Microsoft Silverlight, SharePoint features and solutions, workflow, site templates, site definitions, multilingual deployment, master pages and layout files, and e-mail integration

#An upgrade strategy.
-This objective may include but is not limited to: supporting hardware upgrades (for example, 32 to 64 bit), OS upgrade, in-place upgrade, MOSS upgrade, and SQL Server upgrade

#Design a migration strategy.
-This objective may include but is not limited to: database migration, custom features, read-only and detached databases, designing a test and QA implementation plan (for example, development to production), migrating content databases, moving content between farms, moving content to and from the farm, moving content within the farm, and rollback

#Design security architecture.
-This objective may include but is not limited to: planning security for WebApp site collection, designing SharePoint users and groups administration, taxonomy of SharePoint security groups, managed accounts, site security (permission levels , list permissions, site permissions, personal permissions, default and custom security groups), and planning for Secure Sockets Layer (SSL)

#Plan and deploy authentication methods.
-This objective may include but is not limited to: planning for integration of multiple authentication sources/types, planning for NTLM authentication, planning for Kerberos authentication, planning for Forms-Based Authentication (FBA), planning for Claims Authentication (Identity and Access Management), planning for Secure Store Service

Defining a SharePoint 2010 Operations Strategy and Business Continuity

#Design a maintenance strategy.
-This objective may include but is not limited to: preparing test plans for patching and maintenance, SharePoint Maintenance Manager, rebuilding SQL indexes, search maintenance

#Recommend provisioning strategies.
-This objective may include but is not limited to: managing self-service components (My Sites, service architecture administration), delegating site administration, limiting site templates and page layouts, assigning quotas, defining policy for Web application

# Establish an enterprise monitoring plan.
-This objective may include but is not limited to: developing monitoring points for performance and availability, utilizing performance monitoring, analyzing search reports, Web analytics, diagnostic logging, usage logging, analyzing health and usage data (SharePoint Health Analyzer), and validating farm topology against performance requirements

#Plan SharePoint backup and restore.
-This objective may include but is not limited to: developing and testing recovery strategy and implementation plan, server recovery, site recovery, granular backup and recovery strategy, exporting a site or list, recovering data from an unattached content database, and backup and restore of the following: farm, farm configuration, site collection, Web applications, Secure Store Service, snapshots, content database, configuration database, custom features, solutions, code, service, site, list, document library, performance site collection, and recycle bin

Resources:-

Here are a few of the resources I utilized to help prepare for the exam.

SharePoint 2010 Advanced IT Professional Training – This is a boiled down set of videos made available to those who passed the 2007 IT Pro exams. While some of the videos tend to drag on, it’s a good place to learn & understand 2010.
http://technet.microsoft.com/en-us/sharepoint/ff420396.aspx

TechNet Virtual Labs: SharePoint Products and Technologies
http://technet.microsoft.com/en-us/virtuallabs/bb512933.aspx

if you have any doubts or queries regarding the above mentioned information then please let me know, Thanks...

Exam 70-668: Microsoft SharePoint 2010, Administrator

Designing a SharePoint 2010 Farm Topology

# Design physical architecture.
-This objective may include but is not limited to: translating information architecture to physical architecture, determining capacity for a SharePoint farm (storage, number of users, bandwidth utilization, intranet/extranet, hardware), and scaling Web farm and services infrastructure

#Plan for farm deployment.
-This objective may include but is not limited to: sequential deployment, planning standalone deployment (Microsoft SQL Server Express), planning single-server farm (SQL Server), planning multi-server deployment in an N-Tier Farm, and designing a SharePoint virtual environment

# Plan for availability.
-This objective may include but is not limited to: designing SQL Server failover clustering strategy, types of availability (high-performance, acceptable downtime, Recovery Point Objective, Recovery Time Objective ), types of mirroring, high availability, high protection, whole farm as a failover cluster, and designing the Web Front-End NLB strategy

#Design SharePoint integration with network infrastructure.
-This objective may include but is not limited to: planning for internal and external farm communications, establishing network perimeter configuration, networking, Active Directory, DNS, SQL storage, IIS, and analyzing infrastructure services

# Design logical taxonomy.
-This objective may include but is not limited to: planning sites and site collections, planning for collaboration sites, planning My Site sites, planning for zones, planning for Service Applications, Web applications, content databases, sites and sub-sites vs. libraries, libraries vs. folders vs. document sets, security boundaries, site hierarchy, and content deployment path methodology

#Plan for sandbox solutions.
-This objective may include but is not limited to: content isolation, feature deployments, and trusted solutions


Planning for Search and Business Solutions

#Define search requirements.
-This objective may include but is not limited to: types of data, types of distribution (Internet, extranet), segregation of data, index file location, index size, federation requirements, content sources, search scopes, search taxonomy, server name mappings, promoting or demoting exclusions, synonyms and compound search processing, and defining facets for search

#Enterprise content management.
-This objective may include but is not limited to: records management, BPM (record deployment), document management, metadata planning, information management policies, implement data taxonomy structure, Web Content Management (WCM), and Information Rights Management (IRM)

#Social computing and collaboration.
-This objective may include but is not limited to: user profile service, user profiles, organization profiles, audiences, My Sites, social tags, and planning enterprise wikis, blogs, and personalization sites

#Business intelligence strategy.
-This objective may include but is not limited to: PerformancePoint service (dashboards and scorecards), Excel Services Service, Visio Graphics Service, SQL Reporting Services, chart Web parts, and report center


Planning SharePoint 2010 Deployment

#Service applications.
-This objective may include but is not limited to: formulating a Business Connectivity Services (BCS) strategy, planning a Microsoft Excel Services strategy, implementing a BI solution, planning service application server roles, and planning a Web server forms strategy (Plan InfoPath Forms Services)

#SharePoint component strategy.
-This objective may include but is not limited to: Web parts, Web applications, Microsoft .NET, Microsoft Silverlight, SharePoint features and solutions, workflow, site templates, site definitions, multilingual deployment, master pages and layout files, and e-mail integration

#An upgrade strategy.
-This objective may include but is not limited to: supporting hardware upgrades (for example, 32 to 64 bit), OS upgrade, in-place upgrade, MOSS upgrade, and SQL Server upgrade

#Design a migration strategy.
-This objective may include but is not limited to: database migration, custom features, read-only and detached databases, designing a test and QA implementation plan (for example, development to production), migrating content databases, moving content between farms, moving content to and from the farm, moving content within the farm, and rollback

#Design security architecture.
-This objective may include but is not limited to: planning security for WebApp site collection, designing SharePoint users and groups administration, taxonomy of SharePoint security groups, managed accounts, site security (permission levels , list permissions, site permissions, personal permissions, default and custom security groups), and planning for Secure Sockets Layer (SSL)

#Plan and deploy authentication methods.
-This objective may include but is not limited to: planning for integration of multiple authentication sources/types, planning for NTLM authentication, planning for Kerberos authentication, planning for Forms-Based Authentication (FBA), planning for Claims Authentication (Identity and Access Management), planning for Secure Store Service

Defining a SharePoint 2010 Operations Strategy and Business Continuity

#Design a maintenance strategy.
-This objective may include but is not limited to: preparing test plans for patching and maintenance, SharePoint Maintenance Manager, rebuilding SQL indexes, search maintenance

#Recommend provisioning strategies.
-This objective may include but is not limited to: managing self-service components (My Sites, service architecture administration), delegating site administration, limiting site templates and page layouts, assigning quotas, defining policy for Web application

# Establish an enterprise monitoring plan.
-This objective may include but is not limited to: developing monitoring points for performance and availability, utilizing performance monitoring, analyzing search reports, Web analytics, diagnostic logging, usage logging, analyzing health and usage data (SharePoint Health Analyzer), and validating farm topology against performance requirements

#Plan SharePoint backup and restore.
-This objective may include but is not limited to: developing and testing recovery strategy and implementation plan, server recovery, site recovery, granular backup and recovery strategy, exporting a site or list, recovering data from an unattached content database, and backup and restore of the following: farm, farm configuration, site collection, Web applications, Secure Store Service, snapshots, content database, configuration database, custom features, solutions, code, service, site, list, document library, performance site collection, and recycle bin

Exam 70-667 - Configuring Microsoft Sharepoint

This exam is intended to validate the configuration skills needed to administer a SharePoint 2010 installation.

Candidates for this exam typically have more than one year of experience configuring SharePoint and related technologies, including Internet Information Services (IIS), Windows Server 2008, and Active Directory, and networking infrastructure services.

+Is proficient with the infrastructure and security of Windows Server 2008.
+ Has experience with business operations for IT, including data backup, restoration, and high availability.
+ Has experience with Windows PowerShell 2.0 and command-line administration.

The following are the course blueprint

#Installing and Configuring a SharePoint Environment

-Deploy new installations and upgrades:

This objective may include but is not limited to: running Visual Upgrade, performing an in-place upgrade, performing a database attach upgrade, analyzing a PreUpgradeCheck report, installing language packs, and scripting installations; analyzing ULS logs, installation error logs, and event logs to identify installation problems; and repairing installation errors

#Configure SharePoint farms.

-This objective may include but is not limited to: configuring inter-server communications, server roles, high availability, InfoPath Forms Services (IPFS), Alternate Access Mappings (AAM), external sites, host headers, and applying and managing patches


#Configure service applications.

-This objective may include but is not limited to: configuring service applications such as Business Connectivity Services (BCS), Access Services, Visio Services, Microsoft Office PerformancePoint Server 2007, user profiles, Microsoft Office Excel services, Managed Metadata Services (MMS), and IPFS

#Configure indexing and search.

-This objective may include but is not limited to: configuring FAST Search for SharePoint, crawl schedules, iFilters, crawl rules, content sources, scopes, managed properties, content types, search components, index partitioning, and federated search locations


Managing a SharePoint Environment

#Manage operational settings.

-This objective may include but is not limited to: configuring logging, quotas, monitoring levels, health reports, security, and SQL Server Reporting Services (SSRS) integration

- Manage accounts and user roles.
This objective may include but is not limited to: managing user accounts, group accounts, managed accounts, computer accounts, and service accounts; and delegating site collection administration

-Manage authentication providers.
This objective may include but is not limited to: managing NTLM, Kerberos, claims-based, and forms-based authentication; and configuring Secure Store Service (SSS) and Active Directory Federation Services (AD FS).

#Deploying and Managing Applications

-Manage Web Applications.
-This objective may include but is not limited to: managing databases, Web Application settings, security, and policies.

-Manage site collections.
This objective may include but is not limited to: managing site collection policies, features, caching, and auditing; configuring site collection security; configuring multi-tenancy; and configuring site collection quotas and locks.


-Deploy and manage SharePoint solutions.
This objective may include but is not limited to: deploying and managing SharePoint solution packages, managing sandbox solutions, and managing user solutions

#Maintaining a SharePoint Environment

-Backup and restore a SharePoint environment.
This objective may include but is not limited to: configuring backup settings; backing up and restoring content, search, and service application databases; detaching and attaching databases; and exporting lists and sites

-Monitor and analyze a SharePoint environment.
This objective may include but is not limited to: generating health, administrative, and Web analytics reports; interpreting usage and trace logs; identifying and resolving health and performance issues

Please let me know in case of any queries or questions, Thanks...

Cannot connect to SQL Server - Event 3355 (SharePoint Server 2010)

Microsoft SharePoint Foundation 2010 uses Microsoft SQL Server 2008 databases to store configuration settings and most of the content for the Microsoft SharePoint Foundation Web site.

For example, all pages in the site, files in document libraries, files attached to lists, and information in lists are stored in the content database, and security and permission settings along with other configuration settings are stored in the configuration database in SQL Server. SharePoint Foundation 2010 uses a service account to communicate with the database on behalf of a user request. This service account can be either a specific user name or password (domain name and password), or a predefined system account, such as Local System or Network Service. When a SQL Server database is created, a value for the maximum database size is set. Each database has a separate database size setting. Note that a Web application might be associated with one or many databases.

This error indicates that Microsoft SharePoint Foundation could not connect to the SQL Server database.

One or more of the following symptoms might appear:
• Attempts to communicate with SQL Server fail and no content from databases hosted on the SQL Server can be accessed.
• This event appears in the event log: Event ID: 3355 Cannot connect to SQL Server. not found. Additional error information from SQL Server is included below.

One or more of the following might be the cause:
1. The SQL Server might be offline.
2. The SharePoint Foundation database access account might not have the necessary permissions to communicate with the SQL Server.
3. A firewall that runs on either the local server or on SQL Server might be blocking network communications.

Troubleshooting Steps:

Grant correct permissions to the database access account:
You must be a member of the Farm Administrators group to perform this task.

Assign the database access account:
a. On the Central Administration home page, click Security and in the General Security section click Configure service accounts.
b. On the Service Accounts page, in the Credential Management section, in the upper dropdown list click the correct Web application pool for your Web application.
c. In the Select an account for this component drop-down list, click the domain account that you want to associate with this Web application pool, or click Register new managed account to associate a new domain account with this application pool.
d. Click OK to save changes.

Verify that the account has correct permissions in SQL Server:
a. Connect to the computer that runs SQL Server by using an account that has Administrator permissions.
b. In SQL Server Management Studio, Object Explorer navigation pane, expand the Security node, and then expand the Logins node. The name of the database access account indicates that it is a SQL login.
c. If the account exists, in the Object Explorer navigation pane, expand the Databases node, expand the configuration database node, expand the Security, and then click Roles.
d. Expand the Database Roles node, right-click db_owner role and select Properties.
e. In the Database Role Properties dialog box, check whether the database access account is in the Members of this role list. If the account is not listed, click Add.

If you have any queries or questions regarding the above mentioned info then please let me know, Thanks...

ULS not enough free disk space - Event 6457(SharePoint 2010)

Alert Name: ULS not enough free disk space

Event ID: 6457

The Microsoft SharePoint Foundation Tracing (SPTracev4) service is used by Microsoft SharePoint Foundation 2010 to manage trace message output. When trace logging is turned on,administrators can specify the path that is to be used to store the trace logs. This log file is used by many applications that are built on top of SharePoint Foundation. The trace log contains information that is useful for diagnosing server problems. SharePoint Foundation 2010 could not write to the trace
log. This event occurs when not enough free space is available for logging.

The following symptoms might appear:
• The trace log shows no new data.
• This event appears in the event log: Event ID: 6457 Description: Not enough free disk space available. The tracing service has temporarily stopped outputting trace messages to the log file. Tracing will resume when more than <# of MBs needed to resume logging> MB of disk space
becomes available.

Possible Cause:
The configured log location does not have sufficient free disk space for logging.

Troubleshooting steps:

Free up disk space
1. Use Disk Cleanup to free up disk space where the trace logs are stored.
2. Verify that the trace log has enough disk space to run properly.
3. If the trace log does not have enough disk space, clean up the Temp folders on the drive.
4. If this procedure does not solve the problem, it is also possible to relocate the trace log file to a partition that has more drive space.

Relocate the log file
1. On the SharePoint Central Administration Web site, click Monitoring and in the Reporting section, click Configure diagnostic logging.
2. On the Diagnostic Logging page, in the Trace Log section, type the new location for the trace log files in the Path text box.
3. Click OK.

If you have any queries/questions regarding the above mentioned info then please let me know, Thanks..

E-mail service cannot deliver e-mail - Event6873 (SharePoint 2010)

Alert Name: E-mail service cannot deliver e-mail

Event ID: 6873

The Microsoft SharePoint 2010 Products e-mail service processes e-mail destined for insertion into SharePoint lists. The service processes mail that the Windows Simple Mail Transfer Protocol (SMTP) service added to a drop folder.

One or more of the following symptoms might appear:
• SharePoint lists do not receive e-mail.
• This event appears in the event log: Event ID: 6599 Description: an error occurred while processing incoming email

One or more of the following might be the cause:
• There is no corresponding SharePoint list for the recipient of an e-mail.
• The sender does not have sufficient permissions to add content to the SharePoint list.

Troubleshooting Steps:

Verify that the list is configured to receive e-mail:
1. In the list provided in the event details, on the List menu, click List Settings.

2. On the List Settings page, under Communications, click Incoming e-mail settings.

3. Verify the following:
• The correct e-mail address is entered in the E-mail address box.
• The Yes option is selected under Allow this document library to receive e-mail?

Grant the sender the appropriate permissions to the recipient list:
1. In the list provided in the event details, on the List menu, click List Settings.
2. On the List Settings page, under Permissions and Management, click Permissions for this list.
3. Verify that the user account provided in the event details has at least Contributor permissions to the list.

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

SharePoint 2010:Remote BLOB Cache

By default, a SharePoint farm uses content databases on SQL Server as its only data source. Farm content generally includes documents and pictures, which can each be on the order of several megabytes in size. Files and other unstructured data have historically been stored as binary large objects (BLOBs) within the database.

While there have been many improvements in the way that BLOBs are handled within a SQL Server database3, there are limitations. The VARBINARY(MAX) data type is used for native BLOB storage, and can accommodate files up to two gigabytes (2147483648 bytes) in size. In rare circumstances, this may not be adequate for all of the files that will be stored in the farm. Also, the performance of writing BLOBs to and retrieving BLOBs from the database is generally not as good as the performance offered by file systems, which can degrade users’ perception of a SharePoint solution.

Remote BLOB Storage (RBS) feature pack is available for SQL Server 2008 and SQL Server 2008 R2; it provides libraries and APIs that allow SQL Server to interact with BLOBs stored outside of the database. SQL Server 2008 and SQL Server 2008 R2 provide a data type called FILESTREAM that allows BLOBs to be stored within an NTFS volume, but managed by the database. This feature cannot be directly used by SharePoint4, but there is an RBS provider for FILESTREAM that can be used with local SharePoint databases (such as those often employed by SharePoint Foundation 2010); this local database requirement makes the FILESTREAM provider for RBS unsuitable for most farm-based architectures. For farm deployments with separate database servers, RBS providers other than FILESTREAM may still be used.

For example, a provider for a dedicated external store, such as an EMC2 Centerra system, that makes use of the SQL Server RBS API calls may be employed. These RBS providers allow third-party products to leverage RBS to store and retrieve files that reside outside of the database. Using Remote BLOB Storage requires configuration of both SQL Server 2008 (or SQL Server 2008 R2) and SharePoint Server 2010. These systems are expected to offer higher performance for reading and writing large files, but will generally require special attention when administering sites or performing backup/restore operations.

SharePoint 2010: Central Administration Improvements

Central administration has been redesigned completely with features like a ribbon interface that is similar to Office 2007 and 2010 products. The ribbon is context-aware, and makes accessing the subtasks within any selected functional area more intuitive. The central administration site looks similar to Windows control panel, where different tasks and activities are grouped into categories. The new home page also provides convenient access to most common tasks by grouping them together into categories such as application management, monitoring, security, backup, and so on.



Backup and Restore

Microsoft added a few very important enhancements to SharePoint backup and recovery. SharePoint 2010 provides several levels of granularity for performing backup and restore. This includes farm configuration, site collections, sub sites and lists.

The central administration site provides a simple interface to perform full backup and restore, perform granular backup or configure backup settings. In earlier versions of SharePoint, administrators built a secondary farm to perform granular recovery of SharePoint content. This is no longer required with SharePoint 2010. In SharePoint 2010, administrators can perform content restore from unattached content databases. Using unattached content database feature, you can connect to a content DB restored to any SQL server in the network and use SharePoint 2010 to browse the contents of the database. An administrator will be able to restore content at a very granular level.

Similar to any other administrative function within SharePoint 2010, you can automate or script your backups using Windows PowerShell. Every backup and restore activity that can be performed using central administration can also done at the command-line using PowerShell. Windows PowerShell also provides a few more additional backup/restore options such as file compression and SQL snapshots which are not available through central administration webpage.



SharePoint 2010 Health and Monitoring

SharePoint 2010 includes new tools to monitor health and track performance of a SharePoint farm. This includes features such as unified logging, developer dashboard, usage database, SharePoint maintenance engine, and out-of-box usage reports. Most of these improvements are done to provide a more proactive way of monitoring and reporting. Administrators can also use PowerShell cmdlets to monitor the health of a SharePoint farm.

The integrated Health Analyzer identifies common problems and provides prescriptive guidance to help administrators resolve them. The tool includes several default rules for Security, Performance, Configuration, and Availability. Each rule can be independently enabled and have its scope set to determine the servers that are checked. If a rule is enabled, then SharePoint 2010 will periodically check the conditions associated with the rule, based on a defined schedule. Certain rules can even be set to allow SharePoint automatically correct violations.