02 January, 2013

We cannot locate a server to load the workbook Data Model.


Problem Description:
Assume that you use an Analysis Services source to create a PivotTable in Microsoft Excel 2013. You upload the Excel Workbook to a Microsoft SharePoint site.

When you try to either refresh the PivotTable or filter the data in the PivotTable, you receive the following error message:
We cannot locate a server to load the workbook Data Model.

Probable cause:
This issue occurs because the Analysis Services instance has not been configured in the Central Administration site.

Workaround/Resolution:
1.    To work around this issue, configure the Excel Services service application on the SharePoint server. To do this, follow these steps:
2.    In the Application Management section of the Central Administration home page, click Manage service applications.
3.    On the Manage Service Applications page, click the Excel Services service application that you want to configure.
4.    On the Manage Excel Services page, click Data Model.
5.    Click Add Server.
6.    In the Server Name box, type the name of the Analysis Services instance that you want to add.
7.    Click Ok.

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

01 January, 2013

SharePoint 2013 free ebooks

Thanks allot to Mr. Jeremy Taylor as he states

There are a lot of resources (blog posts / worksheets / scripts / screenshots on random SharePoint things) on the internet on SharePoint 2013 which could be classified as an ‘ebook’ if you print it to pdf. However, I am interested in capturing “ebooks” that are in pdf, doc or xps format, with a table of contents and some thought to its presentation. The reason for this post is something you can download, print or save and read when you are offline. I will check for its source too and ensure its from an authoritative & well known source.

Here is a list of SharePoint 2013 free ebooks available on the internet:
Microsoft: Explore SharePoint 2013
Microsoft: Deployment guide for SharePoint 2013
Microsoft: IT Professional Reviewer’s Guide for SharePoint Server 2013
Microsoft: Plan and use the Distributed Cache service in SharePoint Server 2013

31 December, 2012

Happy New Year 2013.

It’s my pleasure to wish my all reader and viewers a very happy new year 2013….!
May GOD fulfill this year with all the happiness, warmth, and prosperity and keep you family and near being in a wealth state.  
I hope, I can bring you more of SharePoint learning from my experience and experience of experts across the world.
Happy Reading……!

27 December, 2012

InfoPath cannot save the following form: Form Name


Use InfoPath 2013 to design sophisticated electronic forms to gather information quickly and easily.





InfoPath Forms Services, which is available in SharePoint Server 2013, enables you to deploy an InfoPath form template to a SharePoint Server so that users without the InfoPath rich client can open and fill out InfoPath forms in a Web browser.

Let’s assume- when you try to publish and save the form, you receive the following error message:
InfoPath cannot save the following form: Form Name. This Document Library was either renamed or deleted, or network problems are preventing the file from being saved. Contact your network administrator

For Resolution, I would like convey Million thanks to Microsoft for publishing a KB article for this issue so that everybody can refer and resolve it quickly.

Clipboard Hack Problem using CTRL+C

*Ctrl+C may be the most important work we do everyday.. But it’s not a very safe thing to do. Read on to know why.

What happens when you press Ctrl+C while you are online.

We do copy various data by Ctrl + C for pasting elsewhere. This copied data is stored in clipboard and is accessible from the net by a combination of Javascripts and ASP.

This is called clipboard hack problem.

*Just try this:*

1. Copy any text by Ctrl + C
3. You will see the text you copied was accessed by this web page.

*Surprised!* I know you are because i was also surprised to see it.

Do not keep sensitive data (like passwords, credit card numbers, PIN etc.) in the clipboard while surfing the web. It is extremely easy to extract the text stored in the clipboard to steal your sensitive information.

Spread this information to as many friends as you can, to save them from online frauds!

It is true, text you last copied for pasting (copy & paste) can be stolen when you visit web sites using a combination of JavaScript and ASP (or PHP, or CGI) to write your possible sensitive data to a database on another server.

*How Cipboard Hack is done?*

The Clipboard hack is done by the following Source Code:

*

How to safeguard yourself from Clipboard Hack Problem?*

To avoid clipboard hack problem, do the following:

1. Go to internet options->security.
2. Press custom level.
3. In the security settings, select disable under Allow paste operations via script/Allow programmatic clipboard access. (Scripting sub heading)


(I think the settings are taken care by system admin so you can change it in your personal pc)

Now the contents of your clipboard are safe.

Interestingly, this hack works only on internet explorer, and not on Mozilla Firefox browser. Please share this article to as many friends as you can to make them aware of this issue with CTRL+C

But its not complex to implement on famous Browsers with Open source in place.