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

"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"

Cause :By default the files are designed to open in browser. So it will check for trusted location   

solution :Follow the below steps.

1.    Go to the Library

2.    On the top click on Library and go to Library settings .

3.    Under General settings you will find Advanced settings

4.    Over there you will find the option which by default is set to open in Browser

5.    You need to set it to Open in Client and there you go .

6.    Click OK to apply the settings.

 Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

How to Import and Export SSL Certificates in IIS 7

Exporting/Backing Up to a .pfx File from Another server

1.    On the Start menu click Run and then type mmc.

2.    Click File > Add/Remove Snap-in.

3.    Click Certificates > Add.

4.    Select Computer Account and then click Next. Select Local Computer and then click Finish. Then close the add standalone snap-in window and the add/remove snap-in window.

5.    Click the + to expand the certificates (local computer) console tree and look for the personal directory/folder. Expand the certificates folder.

6.    Right-click on the certificate you want to backup and select ALL TASKS > Export.

7.    Choose Yes, export the private key and include all certificates in certificate path if possible.
Warning: Do not select the delete private key option.

8.    Leave the default settings and then enter your password if required.

9.    Choose to save the file and then click Finish. You should receive an "export successful" message. The .pfx file is now saved to the location you selected.

Importing from a .pfx File

1.    On the Start menu click Run and then type mmc.

2.    Click File > Add/Remove Snap-in.

3.    Click Certificates > Add.

4.    Select Computer Account and then click Next. Select Local Computer and then click Finish. Then close the add standalone snap-in window and the add/remove snap-in window.

5.    Click the + to expand the certificates (local computer) console tree and look for the personal directory/folder. Expand the certificates folder.

6.    Right-click on the certificate you want to backup and select ALL TASKS > Import.

7.    Follow the certificate import wizard to import your primary certificate from the .pfx file. When prompted, choose to automatically place the certificates in the certificate stores based on the type of the certificate.

Enabling a New Certificate on a Server

1.    On the Start menu, click Administrative Tools > Internet Information Services (IIS) Manager.

2.    In the IIS Manager, click the server name.

3.    Expand the sites folder.

4.    Select the site that you want to secure (usually the default website).

5.    On the actions menu in the edit site section, click Bindings.

6.    In the site bindings window, click Add. If a binding for https already exists, select the https binding and click Edit.                     

7.    Fill out the information in the add site binding window. In the type drop-down choose https. Set the IP address to the IP address of the site or choose all unassigned. The port for SSL traffic is usually 443. Enter the recently imported certificate in the SSL Certificate field.                           

8.    Click OK. Your SSL Certificate is now installed and the website is configured to accept secure connections. You may have to restart IIS or the server for it to recognize the new certificate.     

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

How to Change SharePoint authentication from classic mode to claims based

Recently, I was in a situation to enable form authentication for our satellite farms. A SharePoint web application that was configured Mistakenly by using classic mode authentication. So the solution for me is to change the authentication mode to claims based.

Note: Be noted that once you migrated the authentication provider to claims based, you cannot revert it back.

From the central administration, I checked the authentication provider and it is showing my current authentication provider as windows. Now I am going to change my authentication provider, to do this, you need to use windows power shell.

From the start menu, go to

All Programs -> SharePoint 2010 products -> SharePoint 2010 Management Shell

The power shell window is opened as follows.

Execute the following commands In order.

$WebAppName = http://aniish.com (Application name that you want to change the authentication)

$account = "Cosima\Administrator" (Account configured for Web APP)

$wa = get-SPWebApplication $WebAppName

Set-SPwebApplication $wa –AuthenticationProvider (New-SPAuthenticationProvider) –Zone Default

When you execute this command, a confirmation message will appear on the screen as follows.

Type Y for confirmation

After the command executed successfully, check the authentication provider from the central Administration, it will show “claims based authentication”

Now execute the following commands.

• set the user as an administrator for the site

$wa = get-SPWebApplication $WebAppName

$account = (New-SPClaimsPrincipal -identity $account -identitytype 1).ToEncodedString()

• configure the policy to enable the user to have full access

$zp = $wa.ZonePolicies("Default")

$p = $zp.Add($account,"PSPolicy")

$fc=$wa.PolicyRoles.GetSpecialRole("FullControl")

$p.PolicyRoleBindings.Add($fc)

$wa.Update()

• perform user migration

$wa = get-SPWebApplication $WebAppName

$wa.MigrateUsers($true)

Reference: http://technet.microsoft.com/en-us/library/gg251985.aspx

If All the above Commands Executed, Authentication will be change successfully.

Please Comment if you need Any Help. Your Feed back is always Welcome. I Am Happy to Help !!!!!

Call Stack And Custom Errors Mode Changes to get the Exact Error in SharePoint

Call Stack And Custom Errors Mode Changes to get the Exact Error in SharePoint

Please look the below Changes and apply to get the Details of Error In SharePoint Site while accessing:

The below modifications need to done on WEB.Config file of the Specific Site.

Path : C:\inetpub\wwwroot\wss\VirtualDirectories\Site Specified.

Note: Take Backup Of WEB.CONFIG before doing changes.

Step Need to Change1:

SafeMode MaxControls="200" CallStack="false"

DirectFileDependencies="10" TotalFileDependencies="50"

        AllowPageLevelTrace="false">

           to

 <SafeMode MaxControls="200" CallStack="true"

DirectFileDependencies="10" TotalFileDependencies="50" 

   AllowPageLevelTrace="false">

  

Step Need to Change2:

            <customErrors mode="On" /> 

                         to

             <customErrors mode="Off" />

Do IIS reset if necessary and access the Site, You see the Error Details!!

Please Comment if you need Any Help. Your Feed back is always Welcome. I Am Happy to Help !!!!!