18 March, 2012

You are attempting to open a file that is blocked by your registry policy setting.

Number of error messages that will be fixed when you will apply the resolution:

You are attempting to open a file that is blocked by your registry policy setting.

You are attempting to open a file type <<File Type>> that has been blocked by your File Block settings in the Trust Center.

You are attempting to open a file that was created in an earlier version of Microsoft Office. This file type is blocked from opening in this version by your registry policy setting.

You are attempting to save a file that is blocked by your registry policy setting.

You are attempting to save a file type <<File Type>> that has been blocked by your File Block settings in the Trust Center.

Your error message will be anyone which are mentioned above. but don't worry Microsoft has already published a KB for this and your issue will be resolved when you will apply the mentioned resolution.

Resolution:
To resolve this issue, click the following article number under the name of the Office program that you are using to view the article in the Microsoft Knowledge Base: 

Word 2010, Word 2007, or Word 2003
Excel 2010, Excel 2007, or Excel 2003
PowerPoint 2010, PowerPoint 2007, or PowerPoint 2003
I receive an error message when I try to open or save a file in PowerPoint


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

The provided Secure Store target application is either incorrectly configured or does not exist


Yesterday, i was configuring Schedule PowerPivot Data Refresh as per this microsoft article: 
What i did exactly ?
-Open a SharePoint 2010 site
-Uploads Powerpivot
-selects schedule a data refresh for the workbook
-at step 7, i have selected third option i.e. The user enters a known existing Secure Store Target application ID in the Credentials section inside the "Connect using the credentials saved in Secure Store Service" field.
-Clicks OK to save the schedule and got the following error message:
"The provided Secure Store target application is either incorrectly configured or does not exist"

I have successfully resolved this issue by following the below mentioned steps:
Note: I am still debugging this issue to find out the root cause. Will share the details asap.

Resolution Steps:
1.       In Central Administration browse to Application Management 
2.       Click Manage Service Applications
3.       Click to the right of the Secure Store Application link so the row appears highlighted. The objective is to activate the Administrators button in the menu ribbon.  
4.       Click on the Administrators button and add the user (or an appropriate security group including user) to the field.  
5.       Click Add, and then check the "Manage target applications" check box.

If you have any queries/questions then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you

17 March, 2012

When opening an excel file I get the following error "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.

If you are working on Office Web apps in SharePoint 2010 then you may come across this error…
“This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.
To create an Excel Services Application trusted location, contact your system administrator.”

its very simple to resolve this error and start working on excel again :-)
there are 2 methods to resolve this issue:

Option 1: Configure to open in Client Application
At the site collection level activate the "Open Documents in Client Applications by default Feature"

Option2: At the Document Library set the "Opening Documents in the Browser" setting to "Open in client application"

OR
  1. open central admin 
  2. go to Manage service applications
  3. Click on Excel services Application.
  4. Then click on “Trusted file locations”
  5. You can see that http:// is already there, so you could just add https:// or put in a url to a specific location
  6. Fill in the boxes, I also ticked the trust children box.
  7. Once you have done this go back to your Excel document and it will open up in the browser. 
If you have any queries/questions regarding the above mentioned information then please let me know, thank you

System error 5 has occurred. Access is denied.

This issue occurs if you use a connection method that uses Windows shell components or Explorer View. For example, you may experience one or more of the following symptoms:

1-if you try to map a drive to a document library by using the net use command, you are prompted to type your user name and password. After you type your user name and password, you receive the following error message:

System error 5 has occurred.
Access is denied.

2-If you try to view a document library by using Explorer View, you are prompted several times to type your user name and password. If you click Cancel, Explorer View displays Web folders. 
To have us enable Basic authentication on the client computer for you, go to the "Fix it for me" section. If you prefer to fix this problem yourself, go to the "Let me fix it myself" section.
Fix it for me
To fix this problem automatically, click the Fix it button or link. In the File Download dialog box, click Run, and then follow the steps in the Fix it Wizard.


Fix this problem
Microsoft Fix it 50623

13 March, 2012

How to check-Forms Server is installed on a server or not ?

Problem Description:
Forms Server was installed on a server and you need to verify its installation.


What excatly we need to check for this?
Check whether the Microsoft.Office.InfoPath.Server.dll is installed on the server.

Resolution:To verify the installation of Forms Server you need to check whether the DLL is properly installed on the server and whether the ASP.NET page is present. You can do this as follows:
1.Go to C:\Program Files\Microsoft Office Servers\12.0\Bin\ and check whether Microsoft.Office.InfoPath.Server.dll is present in this folder.
2.Go to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\ and check whether FormServer.aspx is present in this folder.
3.Open the .NET Framework 2.0 Configuration tool by going to Start > Settings > Control Panel, opening the Administrative Tools and then the Microsoft .NET Framework 2.0 Configuration.
4.Click on Manage the Assembly Cache listed under Tasks in the right panel of the .NET Framework 2.0 Configuration dialog box.
5.Click on View List of Assemblies in the Assembly Cache under Tasks in the right panel of the .NET Framework 2.0 Configuration dialog box.
6.Look whether Microsoft.Office.InfoPath.Server is listed among the DLLs that are registered in the Global Assembly Cache (GAC).


Please let me know in case of any queries/questions. I would be more than happy to help you as well as resolves your issues, Thank you