20 August, 2012

The file is corrupt cannot be opened


Excel 2010 is spreadsheet software in the new Microsoft 2010 Office Suite. Excel allows you to store manipulate and analyze data in organized workbooks for home and business tasks. New innovations in Excel 2010 include the enhanced data viewing features of Sparklines and Slicers.

Problem Description:
After you install Microsoft Office 2010, you cannot open .xls files, and you may receive the following message:

The file is corrupt cannot be opened.

In addition, you may experience a problem in which any Microsoft Office programs, such as Word or Outlook, crashes when you open .xls files. 

Resolution:
1)   Follow these steps:
2)   Click Start
3)   Control Panel
4)   Programs
5)   Uninstall a program under Programs and Features. 
6)   Select Microsoft Office. 
7)   Click Change, and then wait while the change and repair is carried out.  
8)   Exit after the process is completed. 
9)   Double-click the Excel file that you want to open or open the file through an HTML link as you could by using previous versions of the program.

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 J Thank you

SharePoint 2010 Service Applications

SharePoint 2010 includes a fundamental architectural change from the previous version with the introduction of “Service Applications”. This new architecture has extremely broad and deep consequences for SharePoint practitioners. Unfortunately Service Applications thus far have been poorly explained and documented, and already there are many myths surrounding them. This “In a Nutshell” article is an attempt to distil the core elements down to brass tacks. It is intended primarily for architects and administrators planning their farm topologies, but will also be useful for anyone working with SharePoint 2010.


Introduction.


SharePoint 2010 includes a fundamental architectural change from the previous version with the introduction of “Service Applications”. This new architecture has extremely broad and deep consequences for SharePoint practitioners, touching on nearly every aspect of SharePoint implementation from development approaches, topology design, service federation, authentication, governance and operational service management. Service Applications, rather than any particular service or feature in SharePoint 2010, is the single most important area for the field to adequately understand. At the very least service applications represent a fundamental change to the functional decomposition of services within a farm, the single biggest factor in delivering platform hygiene for distributed application platforms. Unfortunately service applications thus far have been very poorly explained and documented. There are already, just a few weeks after RTM, many myths around service applications. You’ve probably heard them. A couple of my favourites are “Service applications give you scalability and load balancing for free” and “Service applications avoid authentication delegation problems”, which of course are both total hogwash.


This “In a Nutshell” article is an attempt to distil the core elements of service applications down to brass tacks. I will not be covering any particular service application in detail but rather focus on the core infrastructure plumbing. It is intended primarily for architects and administrators planning their farm topologies, but will also be useful for anyone working with SharePoint 2010.


Benefits (and drawbacks) of the Service Applications model.


The service applications model addresses some key limitations with the “old” Shared Service Provider (SSP) model in SharePoint 2007. First and foremost service applications allow for truly flexible deployment and granular delegation of control. You will have seen this referred to as “Services a-la-carte” – a particularly heinous marketing phrase. Service Federation is also now greatly refined because of amongst other things the adoption of Claims Based Identity in SharePoint 2010. Service applications also enable multi-tenant scenarios. We can also have true service isolation and each service application can now be autonomous in terms of it’s external resources such as configuration and data stores.


All very nice things, and all very much needed. But hold on a second, you have to take this stuff with a pinch of salt. It’s early days. Think back to the release of SharePoint Server 2007. Shared Service Providers (SSPs) were the solution to the scaling issues inherent in SharePoint Portal Server 2003 and a bunch of other things. They were wonderful! Now we are being told that they sucked, and service applications are the solution!


Having said that there can be no doubt that the service application model provides a suitable approach to addressing the scalability and delegation issues with SSPs and also are a fundamental enabler for a much wider feature capability (think Managed Metadata, Office Web Apps) in SharePoint 2010. Indeed the service application model pushes Microsoft’s most “service orientated” product vastly further ahead in the realm of distributed application platform hygiene. And that’s not a little deal at all. The service application model allows SharePoint 2010 to scale further than ever before, way further. It also introduces a flexibility with respect to deployment that is unmatched in the marketplace. Just what big ass enterprises and SharePoint Online needs. Great!


But wait a minute! Enterprise software is about one thing, compromise. With all that goodness comes a fair dollop of complexity. Think of all those messed up SharePoint 2007 farms, “medium” ones, “large” ones, it doesn’t matter, I’ve never once done a health check and not had to identify farm topology issues. Whacky topologies are a very common thing, and they will get more common with SharePoint 2010. Aside from poor SQL Server implementation and insecure platform configuration, dodgy topologies are perhaps the most common reason for failed deployments or poor performance in production.


Therefore it is more important than ever to fully understand the functional decomposition of SharePoint. How can one choose the appropriate deployment topology if you don’t know which bits do what?


What is a Service Application?


Service Applications are actually nothing more than a logical concept. There is actually no such thing as a “Service Application”. The term is chucked around all over the shop and is destined to become as ubiquitous and misleading as “Web Front End”. You can’t just blame marketing. In the lead up to RTM, many SharePoint “experts” have been playing buzzword bingo with the term and giving false information about them, and even more worryingly, how to build them.


Of course SharePoint wouldn’t be SharePoint if it didn’t have totally confusing administrative interfaces and inconsistency in terminology. Central Administration (a.k.a. SharePoint Control Panel :)) is perhaps the worst culprit here. The bottom line is forget about “Service Applications” other than as a term to describe the model of deployment for shared services in SharePoint 2010. Again, it’s a logical concept or container, nothing more.


There are a number of components within a “Service Application”. They are


Service Instance, This is the meat of the thing, it’s the implementation of the functionality provided. Application binaries. It could include Windows Services, configuration, registry settings etc. SharePoint assets could include timer jobs, services, management pages etc. These bits are deployed to every server in the farm when the install is performed. When PSConfig(UI).exe is run you will see the status: “Successfully installed Service Instance: name of service”. Different service applications of course will have a different variety of bits.


Service Machine Instance, This is the machine or machines in the farm that run the “service”. It is often referred to as a “SharePoint Service”. You configure this using Services on Server. More than one machine can run the Service Machine Instance and by default, software round robin load balancing is provided. You do not need to implement Network Load Balancing of any incarnation. Certain services will also provide their own software load balancing scheme (e.g. Excel Calculation Services). Not all service applications have an associated service machine instance. Some service machine instances can only be started on one server in the farm unless there are multiple service applications.


Some Service Machine Instances have additional configuration. Some “legacy” service machine instances exist, such as the Document Conversions Services, for which there is not an associated Service Application. In addition services such as the Claims to Windows Token Service and the Sandbox Code Service are just SharePoint wrappers for a Windows Service.


Service Application Endpoint, When you start a service machine instance for which there is an associated Service Application, an IIS Virtual Application will be created within the SharePoint Web Services IIS Web site. This will include the Service Application Endpoint (a WCF or ASMX). Each service application must expose a service application endpoint. The service application endpoint is only created on the machine(s) hosting the service machine instance.


Service Application, This is the logical container of the service, what is exposed through Manage Service Applications. It includes the management aspects of the service and configuration. When created the associated databases (if any) and configuration will also be created. The service application endpoint is not created until an associated service machine instance is started. There can be more than one instance of a particular service application. Pages for managing the Service Application are hosted in Central Administration and are called using a GUID in the query string. Service Applications are global to the farm.


Service Connection (aka Service Application Proxy) This is a virtual link between consumers (e.g. Web Applications) and the service. This is an interface for consuming applications and services that understands the load balancing scheme for a service and how to speak to the service machine instance(s). This is not a WCF proxy. The Service Connection also enables inter-farm services. Some Service Connections include settings which are specific to a given connection. The UI calls them Service Connections, but they are more commonly known as Service Application proxies – the term used by PowerShell.


Consumers, are any component that uses the service. Examples include Web Applications, a page, another service application, etc. All the consumer needs is a reference to the service connection.


How do we set these things up? Not all service applications are equal. This is SharePoint after all


“Core” Service applications which are provisioned by PSConfig(UI).exe: Topology and STS, for which there is no or little configuration.


“General Purpose” Service applications for which no associated service machine instance is exposed for configuration, such as the State Service.


“Simple” Service applications that have relatively little configuration or moving parts, for example the Access Database Service or the Subscription Settings Service.


“Medium” Service applications that have a relatively small amount of moving parts, such as the Managed Metadata Service.


“Complex” Service applications that have a relatively complex amount of configuration and moving parts, such as SharePoint Server Search Service or User Profile Service (which have multiple Service Machine Instances).


Not all service applications are created, configured or managed in the same way. There is a ways to go in striving for this consistency and in some cases it is not prudent anyway.


As a general recommendation, the order of creation should be:


- Create the Service Application and Proxy


- Configure the Service Machine Instance In some cases this order is enforced, in others it doesn’t matter.


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.


In Next Artcile I will try to publish the list of SharePoint 2010 Service Applications and thier use.

Unable to search users profile in people picker.

Issue: Unable to search users profile in people picker. You may see.



Troubleshooting done:
- You have validated the user has a valid domain account in Active directory.
- You tried to type the first name and the last name of the user, but no results.
- You tried to resolve the user Alias in Active directory, no results found.


Resolution:
In active directory console, check the account information console for the account and is must be set to disable state.


If the user account is set to disable, It will not appear in the SharePoint people picker and you will get no match found also you will not be able to resolve the name of the user in the outlook.


Mark the user account to active in Active directory, will have it appear in the SharePoint people picker.


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.


18 August, 2012

Error: 0xE0000021 OneNote needs a password to sync some of your notebooks. Click here to see the list of sections and notebooks that require passwords.

Problem Description:
You can’t sync from an OneNote 2010 notebook to SkyDrive, and you receive the following 0xE0000021 error message:

Error Message:
Error: 0xE0000021
OneNote needs a password to sync some of your notebooks. Click here to see the list of sections and notebooks that require passwords.

Probable causes:
Problems syncing OneNote notebooks with your SkyDrive may occur for one or more of the following reasons:
1)   This issue can occur if you have not installed the latest updates.
2)   You may not have the latest version of Windows Live Sign-in Assistant.
3)   This issue can be caused by a conflict with multiple Live IDs.

Resolution:

Method 1: Install the latest updates

Installing any important, recommended, and optional updates can often correct problems by replacing out-of-date files and fixing vulnerabilities. To install the latest updates, click the link specific to your version of Windows and follow the steps in that article:

Note: For Microsoft Office 2010 users, installing the latest updates will include Service Pack 1 (SP1). SP1 includes updates to OneNote 2010 that may resolve issues syncing OneNote notebooks with your SkyDrive account. OneNote 2010 SP1 uses Windows Live Essentials to log onto Windows Live SkyDrive and improves how OneNote synchronizes with SkyDrive.

For an overview of Office SP1 improvements, see Description of Office 2010 SP1 .

Install Windows updates in Windows 7

Install Windows updates in Windows Vista

Install Windows updates in Windows XP

If installing the latest updates did not resolve your issue, continue to method 2.

Method 2: Install the latest version of Windows Live Sign-in Assistant

Issues syncing OneNote notebooks with your SkyDrive account can be resolved by updating to the latest version of Windows Live Sign-in Assistant. Windows Live Sign-in Assistant is part of Windows Live Essentials which also includes Windows Live Messenger, Photo Gallery, Movie Maker, Mail, and more. To resolve this issue, Windows 7 and Windows Vista users can install the latest version of Windows Live Essentials or to install only the Windows Live Sign-in Assistant, click the link specific to your version of Windows:

Windows 7 and Windows Vista

Windows XP

Note: If you need to uninstall and then reinstall Windows Live Essentials, see How to remove and reinstall Windows Live Essentials .

If installing the latest version of Windows Live Sign-in Assistant did not resolve your issue, continue to method 3.

Method 3: Remove Windows Live IDs from Credential Manager

This step applies to Windows 7, and Windows Vista

Credential Manager allows you to store credentials such as user names, and passwords that you use to log on to websites. Sometimes Credential Manager may not be able to acquire log on credentials, and removing your Windows Live IDs may resolve the issue.

Here’s how to remove your Windows Live IDs from Credential Manager:

This step applies to Windows 7, and Windows Vista

For Windows 7
1)   Close OneNote.
2)   Open User Accounts by clicking the Start button, clicking Control Panel , clicking User Accounts and Family Safety (or clicking User Accounts , if you are connected to a network domain), and then clicking User Accounts .
3)   In the left pane, click Manage your credentials.
4)   Click the vault that contains the Live ID credential that you want to remove.
5)   Click the Live ID credential that you want to remove, and then click Remove from vault .
6)   Repeat step 5 until you have removed all of your Live ID credentials from the vault.
7)   Open the OneNote notebook you want to sync.
8)   Click Web.
9)   Sign in with your Windows Live ID and password, and try to sync your OneNote notebook with SkyDrive.

For Windows Vista
1)   Close OneNote.
2)   Open User Accounts by clicking the Start button, clicking Control Panel, clicking User Accounts, and then clicking User Accounts.
3)   On the Advanced Tab, click Manage Passwords.
4)   Click the name of the credential that you want to remove, and then click Remove
5)   Repeat step 4 until you have removed all of your Live ID credentials.
6)   Open the OneNote notebook you want to sync.
7)   Click Web.
8)   Sign in with your Windows Live ID and password and try to sync your OneNote notebook with SkyDrive.

17 August, 2012

'New Document' requires a Microsoft SharePoint Foundation-compatible application and web browser. To add a document to this document library, click the 'Upload Document' button.

In Microsoft OneNote 2010, you can share a notebook so that you can access it on other computers or on the Web, or so that you can work in it together with other people. Taking notes as a group is a collaborative process. As a collaborative tool, OneNote offers far more than the ability to send static notebook pages via e-mail.

When you share a notebook on a SharePoint site, you can use the features of a library to manage and share your notebooks. You can manage who has permission to view the notebook or contribute notes. You can store additional information about the notebook or its pages, such as the department name or project number. You can also track versions of the notebook, so that people can view or restore an earlier version if needed and receive updates when the content changes by using alerts or RSS Feeds.

Problem Description:

Consider the following scenario:
• You have a server that is running Microsoft SharePoint Foundation 2010. 
• You create a document library that uses the Microsoft OneNote 2010 template. 
• In the new document library, you click New Document. 

In this scenario, you receive the following error message:
'New Document' requires a Microsoft SharePoint Foundation-compatible application and web browser. To add a document to this document library, click the 'Upload Document' button.



Resolution:
To work around this issue, follow these steps:
1.  Start OneNote 2010. 
2.  On the File tab, click New. 
3.  Under Store Notebook On, click Network. 
4.  Type a name for the notebook in the Name field. 
5.  Under Network Location, select the SharePoint location where you want to add the OneNote notebook. 
6.  Click Create Notebook.

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.