How to sign an InfoPath form template with VeriSign certificate?

VeriSign code-signing certificate comes as 2 files including 1 certificate file (.spc) and 1 private key file (.pvk). The following describes what we had to go through at my customer to digitally sign the InfoPath form template which has the Full Trust level set. 1. Download pvk2pfx.exe tool and run the tool to generate pfx…

5

How to exclude a site collection from being indexed for a global search but not for local search?

Customer creates a Records Center site collection as a centralized place for archived documents and they don’t want to include archived documents in the global search results (All Sites search) even when the user has the right permission to access these documents, but the content should still be available if user goes to the site and…

2

How to create a custom timer job in SharePoint 2007 (MOSS)

Came across Andrew’s post about how to create a custom timer job in MOSS. I’m working on a Lotus Notes application migration project and I’m planning to recreate some Lotus Notes application Agents (scheduled jobs and notifications) in MOSS using custom timer job. Will post follow-ups on this later… http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx  Issues found this Andrew’s timer job: I used…

2

How to display current user’s full name, email and other info in InfoPath?

Itay has blogged the exact steps and screenshots on how to display current user info (email, full name, manager, etc) in InfoPath form by calling UserProfileService.asmx in MOSS 2007, most importantly without writing any code! http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/04/05/InfoPath-_2D00_-Get-the-current-user-without-writing-code.aspx Note:  I was getting the following error during my first try: The query cannot be run for the following DataObject: GetUserProfileByNameInfoPath…

10

How to create your own custom 404 error page and handle redirect in SharePoint 2007 (MOSS)?

People alway ask how to use their own 404 file not found error page vs. the generic one from IE in MOSS environment. The following example catches the 404 error and sends users to a redirect page.   Here’s the steps:   1. In your MOSS server, make a copy of %systemdrive%\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\LAYOUTS\1033\sps404.html and call…

16

Evaluate partner solutions that support migration from SPS 2003 to MOSS 2007

 A customer is looking to migrate their SPS 2003 content to MOSS 2007 and also restructure their sites during the migration process. None of the standard upgrade approach from Microsoft would accomplish that and I’ve been evaluating some partner solutions that support content migration from WSS V2/SPS 2003 to WSS V3/MOSS 2007. The following 2…

4

How to restore a portal site from SQL database backups in SPS 2003

Right before the scheduled time for production upgrade from SPS 2003 to MOSS 2007, my customer’s SPS 2003 production environment was down. The database server was running on SQL Server 2000. The DBA told us ALL the SharePoint datababases just disappeared overnight and they didn’t have any script to track who deleted them or it’s…

1

How to migrate SPS 2003 My Sites to MOSS 2007 using the same web app hosting the Portal site

During my customer’s migration from SPS 2003 to MOSS 2007 testing environment, we encountered some challenges while migrating My Sites. With Bill’s help, I was able to fix the My Sites in testing environment. During the actual production upgrade, My Sites were sucessfully migrated. Here’s a recap of the fix I did in the MOSS testing environment: 1.      …

16

SQL Server 2005 Maintenance Plans and MOSS 2007 Databases

Earlier I saw one crawling error in my customer’s new MOSS environment after upgraded from SPS 2003. It’s not necessary related to the upgrade though.   I saw the following error in the crawl log:  sps3://domain.company.comException from HRESULT: 0x80040E2F (Exception from HRESULT: 0x80040E2F) From the event viewer on the index server: The start address <sps3://domain.company.com>…

2

Common security related errors in MOSS 2007

Access denied error when clicking Edit Schedule in Content Sources and Crawl Schedules within Search Settings. It’s a known issue. Here’s the fix http://support.microsoft.com/default.aspx?scid=kb;en-us;926959&sd=rss&spid=11373 Event Error with ID 6482 on Search query server(s) Error description: Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (1a646aac-52e4-4742-8bea-fd2dc3d87249).   The error may be a result of Group Policy setting and…

1