Category Archives: Work

My SharePoint 2007 site spontaneously got into read-only mode

Just a short post this time: if you experience symptoms like: no one able to edit anything on a MOSS site weird permission denied errors for admins buttons in the GUI disappearing then maybe your MOSS site got into read-only … Continue reading

Posted in Work | Tagged , | Leave a comment

Restoring Sharepoint content database from backup

A small script to quickly restore a Sharepoint 2007 content database from backup: USE master GO ALTER DATABASE SITE_WSS_Content SET SINGLE_USER WITH ROLLBACK AFTER 5 GO RESTORE DATABASE SITE_WSS_Content FROM DISK = 'path_to_backup\SITE_WSS_Content_backup_201201122000.bak' WITH REPLACE GO ALTER DATABASE SITE_WSS_Content SET … Continue reading

Posted in Work | Tagged , , , , | Leave a comment

Get back your Sharepoint 2007 site manager context menu!

Today my customer’s site manager on their Sharepoint 2007 site went bananas. The context menu used to configure list items shrunk to four items from eight. Apparently this is a known bug in MOSS that’s supposedly been fixed in a … Continue reading

Posted in Work | Tagged , , , | Leave a comment

Deleting TFS 2010 work items

This is how to do this: Open a command prompt, change to your Visual Studio 2010 dir (usually “c:\Program Files\Microsoft Visual Studio 10.0\Common 7\IDE”). Execute this command replacing 123 with your work item id and the http://tfs01:8080/tfs/DefaultCollection with your TFS … Continue reading

Posted in Work | Tagged | Leave a comment

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER when executing a SSIS package

The DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER ierror can sometimes be resolved by verifying that the called stored procedure exists and that the executing user account has access to it. Thank you Microsoft for inventing world’s longest constant name and thus screwing up my WordPress … Continue reading

Posted in Uncategorized, Work | Tagged , | Leave a comment

When IIS 6 doesn’t want to let you in – 401 Access Denied

Had a little fight with my local IIS 6 running on a local user account using integrated authentication. It just wouldn’t let me in, no matter what rights I assigned to the user and to the directory. Apparently this is … Continue reading

Posted in Work | Tagged , | Leave a comment

P/Invoke and LoadLibrary / GetProcAddress

A little snippet I wrote while trying to use LoadLibrary/GetProcAddress to call functions and get variable values that are exported by an unmanaged dll with P/Invoke.

Posted in Work | Tagged , , , , | Leave a comment

Real-time CRL validation for X.509 certificates in .NET

This is a continuation of my post on Avoiding X.509 chain policy caching when using WCF with certificate security. I wrote the code below to implement certificate validation against a published CRL in real-time. The default mechanism uses a cache … Continue reading

Posted in Work | Tagged , , , , | Leave a comment

Fixing “Value does not fall within the expected range” error in MOSS page settings

I wrote this script to correct the error I got from MOSS when trying to edit page settings. Our site uses an internal url (wwwint.mysite.com) and an external one (www.mysite.com). The page layout seemed to have been reset to use … Continue reading

Posted in Work | Tagged | Leave a comment

Avoiding X.509 chain policy caching when using WCF with certificate security

A while ago my customer came to me with an issue that was a bit tricky to find a solution to. Their system uses a Windows forms client and a WCF service running on IIS7 on a Windows 2008 R2 … Continue reading

Posted in Work | Tagged , , , | 3 Comments