19 March, 2012

What is Central Management Store (CMS) on Microsoft Lync Server 2010?

What is Central Management Store (CMS) on Microsoft Lync Server 2010?

Central Management Store (CMS), which holds information about all the roles and settings in the deployment and it, is newly introduced in Lync Server 2010

CMS replaces the various data stores that were used in OCS. The benefit of this Central Management
Store is that once the topology is defined and published, every installation simply pulls from the defined configuration.

Advantages of CMS:-
Server management centralized, No need to connect server remotely.
 CMS replaced OCS Console. This minimizes administrator input and allows automated deployment.

Certificates are requested and deployed and the fact that the Edge server role can now be centrally managed.
The administrator no longer has to connect remotely to that server to manage it locally.

Available flavour of Lync Server 2010
1.       Lync  2010 Standard Edition (Runs on single server)
2.      Lync 2010 Enterprise Edition.

Like many Microsoft server applications, Lync has a Standard and an Enterprise Edition.

The Standard Edition is fully functional but runs on a single server, using a SQL Express back-end database. It is still supported by other roles, such as the Edge, Monitoring, and Archiving roles, which would still run on other physical server hardware. The supporting roles don’t have a definition of Standard or Enterprise; they simply support the deployed front-end servers. The Enterprise Edition allows for higher availability and more scalability of the roles to support organizations with hundreds of thousands of users. Both versions of the software can be installed only on a Windows Server 2008 or 2008 R2 64-bit operating system (OS) and must be installed on the full GUI version of those operating systems rather than the Server Core version.

How Lync Server 2010 Central Management Store (CMS) look like?

Unable to Load Workbook + The workbook that you selected cannot be opened + The workbook may be in an unsupported file format, or it may be corrupt

Excel services work with Excel 2007 and allows you to share, load, calculate Excel workbooks on Microsoft SharePoint Server 2007 portals and dashboards. You can share an entire Workbook or just few parts of it like charts, tables etc. By using a Web browser, end users can view and interact with the workbooks.

However, at times, when you publish a workbook to Excel Services and try to load it in a browser, you might run into an error message

Unable to Load Workbook
The workbook that you selected cannot be opened.
The workbook may be in an unsupported file format, or it may be corrupt.
Would you like to try and open this file in Excel?

How I resolved this issue:
1)   Remove the space character that is in front of the caret operator in the formula.
2)   Save the workbook in the non-XML binary workbook format (.xlsb). Then, publish the workbook to the server

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 u.

For more information about Excel Services, visit the following Microsoft Web sites:

18 March, 2012

You do not have permissions to open this file on Excel Services


If you are troubled with the above errors in SharePoint while publishing and viewing the excel services forms in browser then I believe you are in the right place. I am not sure if my guidelines will solve your problem but at least it solved my issues.

Resolution:
1. In SharePoint Central Administration, go to 'Manage this farm's shared services'

2. Select your shared service. (Default is SharedServices1)

3. In 'Excel Services Settings' select Edit Excel Services settings.

4. Ensure that File Access method is Process Account. Click OK.

5. Back in 'Excel Services Settings' select 'Trusted File Locations'

6. Add a new Trusted file Location:
 > URL: Specify the report library or the entire portal

 > Location Type: Windows SharePoint Services

 > Children: Trusted

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 u

Office documents prompting for credentials

Multiple users are suddenly facing problems while accessing sharepoint site.

SYMPTOMS:
Users are prompted for credentials when accessing Office documents via ISA. 

Customer is using Forms-Based Authentication [FBA] to authenticate external users.

ERROR MESSAGE:
None

ENVIRONMENT:
Office SharePoint Server 2007

CAUSE:
ISA defaults to a settings "Never use persistent cookies"

Resolution:
On the SharePoint site - 

On the properties of the SharePoint publishing rule on ISA, 
go to the following location - Listener - Forms - Advanced Form Options - Cookie Settings - Use 
Persistent Cookies - set this to “On All Computers” (the default setting is “Never use persistent cookies”)

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.

Excel 2010 articles, fixes and updates - Year 2011


This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Excel 2010 that have been released in Year 2011


2555016 Excel 2010 may crash when using HP Printers Q2555016 KB2555016 June 13, 2011











2528533 Office 2010 Cumulative Update for April 2011 Q2528533 KB2528533 April 28, 2011



























2493730 Office 2010 Cumulative Update for February 2011 Q2493730 KB2493730 February 28, 2011




2273257 Office Application Custom Code Solutions Q2273257 KB2273257 February 21, 2011



2276904 Office Deployment Q2276904 KB2276904 January 12, 2011

2479673 Office 2010 Cumulative Update for December 2010 Q2479673 KB2479673 January 6, 2011