21 August, 2012

Error message when you open a Web page that uses Excel Web Access in SharePoint Server 2007: "You do not have permissions to open this file on Excel Services" or "Excel cannot load the workbook that you requested"


An Excel Access Web Part is a SharePoint technology that displays an Excel workbook from a document library. You can connect an Excel Web Access Web Part to any workbook in a SharePoint document library, and then use it on a dashboard or other SharePoint page. For example, you might want to display selected elements of a quarterly report on a dashboard.

Problem description:
You open a Web page that uses Excel Web Access in Microsoft Office SharePoint Server 2007. If Excel Web Access uses a file from a UNC path that is in a trusted location, the file does not open.

Additionally, you receive one of the following error messages:
You do not have permissions to open this file on Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file.
Excel Services cannot load the workbook that you requested.

Workarounds:
To work around this issue, use one or more of the following methods, as appropriate for your situation:
• Make sure that the location type for the trusted location is in UNC format. 
• Make sure that the file access method on the server is set to process account. 
• Make sure that the account that is running Excel Services has permissions to access the UNC share. 

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

20 August, 2012

The Excel Services Application for SharePoint 2010 does not load or display workbooks

Problem Description:
The Excel Services application for Microsoft SharePoint 2010 does not load or display workbooks.

This problem may occur in one of the following scenarios:
• In a custom-security configuration. 
• When you add a new Web application to a farm. 
• When you do not perform a default installation. 

Probable causes:
This problem occurs because the service account that runs the Excel Services Application does not have access to the SharePoint content databases.

Resolution:
To resolve this problem, the administrator must grant access to the account to run the Excel Services Application. To do this, follow these steps for each Web application:
·         Click Start
·         click All Programs . 
·         Click Microsoft SharePoint 2010 Products
·         Click SharePoint 2010 Management Shell

At the Windows PowerShell command prompt (PS C:\>), type the following command, and then press ENTER:

PS> $w = Get-SPWebApplication –Identity < URL of the Web application >

PS> $w.GrantAccessToProcessIdentity("< insert service account >")

Note: The placeholder <insert service account> represents the service account that you use to run the Excel Services Application. 
After you do this, the service account is granted db_owner access to the SharePoint content databases.

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.

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.