DCA and SQL login KB913400

When configuring an MCMS in the production environment I did not have access to an Active Directory. I therefore used an SQL logon to access the database with the DCA. Unfortunately I received the following message regardless of granting the SQL login DBO access to the database.

Error verifying rights: Using a SQL Login to access the database requires that this Login have DBO rights because it is used by this application to configure the database. Using Trusted Authentication to access the database only requires that the previously defined MCMS system account have the following database privileges: db_datareader, db_datawriter and db_ddladmin.

I found that Microsoft have release a hotfix KB913400 on 26 July, 2006 that resolves this issue. You will need to log a support call with Microsoft.

TechEd 2006 – I’ll be there

I am going to TechEd 2006 in Sydney. See you there.

Reusing MCMS dialogs

Have you have written a custom placeholder and wanted to allow the user to select an image from the resource gallery? Well, the AuthFormClient.js has several Javascript methods that allow you to do just this.

WBC_launchImageGallery(strPostingQueryString, strPhName, strPhType, bAllowUpload)

There are lots methods in the MCMS framework files that do all sorts of cool things (and even some mysterious things), so check them out.

Disable the Warning before leaving page message

I recently had a requirement to remove the warning message that is displayed when a user tries to leave a MCMS posting while editing it.

I found a javascript method in the C:\Program Files\Microsoft Content Management Server\Server\IIS_CMS\WebAuthor\Client\AuthFormClient.js file.

WBC_offWarningBeforeLeave();

This did the trick.

Helicon ISAPI Rewrite

I have been developing an MCMS site for a customer that consists of an Authoring and Presentation server in Production. The servers have Map Host Headers enabled. The server are mapped as MCMSAUTHOR for the authoring server and the presentation server as mcms.customer.com.au.

In order to allow content to be migrated between the two environments using the SDAPI without getting a new top level channel in presentation called “MCMSAUTHOR”, install this tool (Helicon ISAPI Reweite Lite) http://www.isapirewrite.com/. This tool enables you to rename the top level channel in the authoring environment to be mcms.customer.com.au. Thus migration occurs correctly.

The rules for this transformation would be:

RewriteCond Host: mcmsauthor
RewriteHeader Host: .* mcms\.customer\.com\.au

What Service Pack do I have installed?

A simple way to determine the service pack level installed in your MCMS 2002, is to open Site Manager and go into Help About from the menu. Check the reported Server Version against the following list:

5.0.1581.0 = RTM
5.0.2284.0 = SP1
5.0.4484.0 = SP1a
5.0.5054.0 = SP2

Update: AVG email scanning and Outlook 2007

Previously I posted about AVG email scanning stripping out the content of emails when using Office Outlook 2007. Upon further investigations I have found that you don’t need to disable the email scanner entirely. Just go into the configuration section of the plugin and take off the Certify mail of both incoming and outgoing mail. That is what is causing the problem.

MOSSIG Meeting 26th July 2006

Last month we launched the Microsoft Office Special Interest Group of Victoria.NET (MOSSIG).  The event was met with much enthusiasm!

We’re happy to announce that we have now organised our regular monthly meeting to run every 4^th Wednesday of the month, starting next week, 26 July. Thanks to the support of Microsoft and Steve Iatropoulos in particular, we will meet in the Microsoft Theatre at Como Plaza.  As usual pizza will arrive at 5:30 pm and we’ll start the presentations at 6 pm.

For the 26^th we have scheduled a presentation on how to create documents using XML and XSL, deep diving into the XML features of Word and Excel and also a development overview of Web Content Management in Microsoft Office SharePoint Server (MOSS) – the new MCMS replacement.  Both presentations will be of value for developers and end-users and cover the current version as well as the upcoming 2007 features. We will also reserve some time for discussions, questions and other networking opportunities. The meeting will finish around 8:30 pm.

Please RSVP to Ed Richard (ed@wss-ed.nl) by end of business on the 25^th so that he can arrange the right amount of food and drinks.

See you next week!