Tuesday, July 31, 2012

E-mail service cannot deliver e-mail - Event6873 (SharePoint 2010)

The Microsoft SharePoint 2010 Products e-mail service processes e-mail destined for insertion into SharePoint lists. The service processes mail that the Windows Simple Mail Transfer Protocol (SMTP) service added to a drop folder.

One or more of the following symptoms might appear:

  • SharePoint lists do not receive e-mail.
  • This event appears in the event log: Event ID: 6599 Description: an error occurred while processing incoming email

One or more of the following might be the cause:

  • There is no corresponding SharePoint list for the recipient of an e-mail.
  •  The sender does not have sufficient permissions to add content to the SharePoint list.


  • Verify that the list is configured to receive e-mail:
  • In the list provided in the event details, on the List menu, click List Settings.
  • On the List Settings page, under Communications, click Incoming e-mail settings.
  • Verify the following:
  • The correct e-mail address is entered in the E-mail address box.
  • The Yes option is selected under Allow this document library to receive e-mail?

Grant the sender the appropriate permissions to the recipient list:

  • In the list provided in the event details, on the List menu, click List Settings.
  • On the List Settings page, under Permissions and Management, click Permissions for this list.
  • Verify that the user account provided in the event details has at least Contributor permissions to the list.

Backup and Recover SharePoint like a time traveler

Backup and recover SharePoint faster than ever!
Crash happens. When it happens to your SharePoint farm it could put your users out of commission for hours. If only you had a magic time machine capable of fast, full-farm backup and restore, and crammed full of powerful search capabilities, easy item-level recovery, and the ability to alter the space-time continuum. Say no more. Idera SharePoint backup has most of that covered (we’re still working on the space-time thing), plus tools to schedule, manage, and monitor backups farm-wide. And you can do it three times faster than out-of-the-box SharePoint backup. 

Our fast, easy, space-time altering features include:
SharePoint backup screenshot
  • Lightning-Fast Backups - With powerful compression and encryption technology
  • Full-Farm Protection Covers content databases, farm config, service applications and more!
  • Real-Time Status Alerts Measure progress for backup and restore operations
  • Self-Service Document Recovery Recovery for site users that saves time
Idera SharePoint backup saves you from spending hours restoring backups after Crash happens. It’s the next best thing to a time machine for your SharePoint farm. Try it for free for 14 days and see for yourself.
Download a free 14-day trial now
Our time-travelling customers love SharePoint backup:

“The best part of working with Idera's SharePoint backup is that it’s easy to use and configure. Compared to similar products, it offers features that are easier to use and cost less!”
–Gerald Parish, SharePoint Architect, Resurgent Capital

“I’m so impressed, I’m not even going to complain about the complete lack of ninja protection.”
–Keith, Very busy SharePoint administrator, Taxes ‘R’ Us, Possibly not real

This copy of Microsoft office is not genuine

After installing MS Office Genuine Advantage (OGA) Notifications (KB949810) from Windows Update, OGA Validation will perform genuine test on installed Microsoft Office XP, Office 2003, Office 2007 and Office 2010 software.KB949810 OGA Notifications update is designed so that end-user cannot uninstall or removed the update using “Add and Remove Programs” or “Program and Features” in the Control Panel.

Disable and Remove OGAAddin from within Office Applications
  • Run one of the Office app such as Word, Excel, PowerPoint as administrator.
  • Open Windows Explorer, go to %SystemDrive%\Program Files\Microsoft Office\Office12
  • Right click on Office app executable, e.g. winword.exe, excel.exe, powerpnt.exe to run as administrator.
  • Go to Options--> Add-Ins.
  • Select COM Add-ins under Manage drop menu list, and click Go.
  • Disable or remove the OGAAdmin.
  • Repeat above steps for each and every Office applications installed.

Reff: http://support.microsoft.com/kb/949810shshshsghs

FREE, must-have tools for SQL Server DBAs‏

Performance Essentials: Must-Have Tools for SQL Server DBAs by Michael K. Campbell

Learn how to optimize your SQL Server with a set of handy (and free) tools that are already a part of SQL Server. In this white paper, Michael K. Campbell, SQL consultant and contributing editor for SQL Server Magazine, shares some of the tools and tricks of the trade to help SQL Server DBAs detect, analyze, and correct performance problems, sometimes before they even occur.

Read Performance Essentials: Must-have tools for SQL Server DBAs.

Download the free whitepaper now!
horizontal line
These free tips can help streamline your workload. And when you’re ready to take things to the next level, try the performance-enhancing power of SQL diagnostic manager.
SQL diagnostic manager screenshotTry it FREE for 14 days and enjoy:
  • 24x7 Monitoring on hundreds of key metrics
  • Identifying worst-performing or frequently run queries
  • Monitoring and fixing issues from any web-enabled device
Download a free 14-day trial

Top 5 Free PowerShell Scripts for SharePoint‏

Top 5 Free PowerShell Scripts for SQL Server
Windows PowerShell provides an easy way to create SharePoint sites, manage services, update configuration and more. Get started with our package of over 20 free PowerShell scripts for SharePoint. Our free scripts pack includes these 5 popular scripts, plus many more -
  • IMPORT-SPSITE - Imports a site from a backup file
  • ADD-SPUSER - Adds a new user to a group in SharePoint
  • REMOVE-SPSITE - Removes a site from the site collection
  • SET-SPITEM - Modifies a list item
  • DISPLAY-SPLIST - Displays all lists
Download free tool now!
Get fast, easy and reliable backups with SharePoint backup
SharePoint backup provides fast, full-farm backup and restore, powerful search capabilities and easy item-level recovery, plus tools to schedule, manage and monitor backups farm-wide.
SharePoint backup 
Download now to get fast, easy, and reliable backups with these features:
Lightning-Fast Backups
Full-Farm Protection
Real-Time Status Alerts
Self-Service Document Recovery
Download a free trial now!

Tuesday, July 17, 2012

This web site has been configured to disallow editing with FrontPage. Contact your web site administrator for more information

To prevent users from changing a Windows SharePoint Services 3.0 site or a SharePoint Server 2007 site, disable the authoring feature in SharePoint Designer 2007 by editing the Onet.xml file. By default, the Onet.xml file for Windows SharePoint Services 3.0 and for SharePoint Server 2007 is in the following folder:

Drive:\Program Files\Common Files\Microsoft Shared\Web Server extensions\12\TEMPLATE\Site Templates\xml

Note: Replace the placeholder with the name of the Windows SharePoint Service that is installed on the server.

For example, if the English (United States) version of Windows SharePoint Services is installed on the server, the SharePoint Team Site template is located in the following folder:

Drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\Site Templates\XML

  • On the server that is running Windows SharePoint Services 3.0 or SharePoint Server 2007, locate the site template that you want to modify.
  • Site templates are located in the following folders on the server:
  • i.e. SharePoint Team Site:
Drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Site Templates\XML
  • i.e. Meeting Workspaces:
Drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Site Templates\MPS\XML

Note Replace the Drive placeholder with the drive where Windows is installed.
  • Right-click the Onet.xml file > Open With, and then click Notepad.
  • Locate the Project Title tag, and then add the following line:
  • Then, click Save.
  • The complete Project Title tag is as follows:

<Project Title="Team Web Site" ListDir="Lists" xmlns:ows="Microsoft SharePoint" DisableWebDesignFeatures=wdfopensite>

  • Restart Internet Information Services (IIS). To do this, follow these steps:
Note: Replace the computer_name placeholder with the name of the computer that is running IIS.

After you follow these steps, users who try to open a site that is based on the site template that has the DisableWebDesignFeatures=wdfopensite attribute will receive the following message:
This web site has been configured to disallow editing with FrontPage. Contact your web site administrator for more information.

Warning: Do not edit a Windows SharePoint Services 3.0 site or a SharePoint Server 2007 site by using Microsoft Office FrontPage 2003. If you do this, you run a major risk of corrupting the site. Instead, always use SharePoint Designer 2007 to edit the site.

Access Denied when attempting to create a new page

User received an error message “Access Denied” when trying to create a new page even if he / she is a member of Site Owner group with Full Control permission

The access denied was a result of the user not being a part of the Style Resource Readers group. According to TechNet, this group allows a user to read the Master Page Gallery and Restricted Read the Style Library. By default  this group contains only the NT AUTHORITY\Authenticated Users group. This will allow all users who have authenticated to the site to read the Master Page gallery and Style Library.

  • Open the site > Site Actions > Site Settings
  • In the Users and Permissions section > People and Groups
  • Click on Groups and select Style Resource Readers
  • Click New > Add User
  • In the Add Users section, click the Add all authenticated users link
  • Click OK

Monday, July 16, 2012

Summary Links Web Part (Error 0x80070002)

After site replication (export-import) we got following error in summary link web part

Unable to add selected web part(s). Could not load XSL file. The system cannot find the file specified.(Exception from HRESULT: 0x80070002).

  • This error basically related to site publishing feature
  • When we try to add a publishing-related web part (such as Summary Links) into a non-publishing site. You have to either add it into a site built with a publishing template (Collaboration Portal or Publishing Portal), or to activate the publishing features manually
  • Activate Office SharePoint Server Publishing Infrastructure feature in site collection features, in Site Collection Administration section of Site Settings page
  • Activate Office SharePoint Server Publishing feature in destination site features, located on Site Administration section of Site Settings page

Monday, July 2, 2012

Solve your top 5 SQL Server performance issues with SQL doctor‏

Performancef problems? Call the SQL doctor!
Do your SQL Servers need a check-up? Call the SQL doctor! SQL doctor analyzes your SQL Servers to give you an instant list of recommendations to solve your top performance issues. Plus, SQL doctor provides the T-SQL to implement the fixes, all in a matter of minutes.
Learn more
SQL doctor can help you cure problems related to:
bulletWait stats like cxpacket, pageiolatch, async_network_io
bulletIndex and query optimization
bulletBlocking, deadlocking and process usage
bulletLong running jobs and transactions
bulletMemory and disk usage
...and more, all for only $495 per user.
Download a free trial now
Point. Click. Cure. with SQL doctor

SQL check is FREE

Try SQL check today!
Every DBA knows the importance of monitoring SQL Server performance to proactively find and fix performance issues. But, did you know you can do this for FREE with Idera SQL check? SQL check is a free tool and provides real-time performance information for a single SQL Server. SQL check gives you:
Real-time monitoring of ~20 key performance metrics
SQL Server sessions monitoring, including locked sessions
No objects installed
Download free tool today!
horizontal line
Need to monitor more than one SQL Server?
SQL diagnostic manager screenshotSQL diagnostic manager helps you quickly identify and resolve SQL Server problems BEFORE they impact performance.
 bulletMonitor and manage SQL Servers enterprise-wide
 bulletFind and fix performance bottlenecks
 bulletAnalyze performance over time
 bulletMonitor and fix issues from any web-enabled device
 bullet24x7 monitoring with intelligent alerts - no agents required
Download free 14-day trial!