November 2005 - Posts

SQL Server 2000 error 7391 on Windows Server 2003 SP1

Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.

The default MS DTC configuration under Windows Server 2003 is to have network access disabled. This stops the ability to run transactions across linked servers from MS SQL Server 2000.

Microsoft refers to this error in KB329332 and has a procedure to enable MS DTC network access for Windows Server 2003, however it seems that the dialog box referred to has changed in Service Pack 1.

Another article, KB899191 explains the new functionality in the Distributed Transaction Coordinator fo Windows 2003 SP1 and Windows XP SP2. You now have the ability to enable both inbound and outbound network access as well as the authentication level. If the linked servers you are trying to access are not Windows 2003 SP1 also, the only authentication level that will work is the "No Authentication Required" option.

In summary, the steps to enable MS DTC network access in Windows 2003 are:

  1. Click Start, point to All Programs, point to Administrative Tools, and then click Component Services.
  2. In the Component Services Wizard, expand Component Services, and then double-click Computers.
  3. Right-click My Computer, and then click Properties.
  4. Click the MS DTC tab, and then click Security Configuration.
  5. In the Security Configuration dialog box, click to select the Network DTC Access check box.
  6. (Windows 2003 only) Under Network DTC Access, click Network Transactions.
    (Windows 2003 SP1 only) Under Network DTC Access, select Allow Inbound and/or Allow Outbound depending on whether the server is initiating or receiving the request. Select No Authentication Required if the linked servers are not also running Windows 2003 SP1.
  7. Make sure that DTC Logon Account is set to NT Authority\NetworkService.
  8. Click OK.
  9. In the message box, click Yes to continue.
  10. In the DTC Console Message dialog box, click OK.
  11. In the System Properties dialog box, click OK.
  12. Reboot the computer for these changes to take effect.
posted Tuesday, November 22, 2005 9:31 AM by dgadamson with 11 Comments

MCMS 2002 SP2 Upgrade Guide

Stefan Goßner has posted the availability of Microsoft Content Management Server 2002 SP2 with support for .Net Framework 2.0.

It looks like there are some very specific steps that need to be taken to do perform this upgrade, especially on a developer's machine and for SQL 2005.
Stefan has since posted some follow up links to guide you through the process here:

Knowledge Base articles for MCMS 2002 SP2

  • 906142 - How to obtain the latest Microsoft Content Management Server 2002 service pack
  • 906145 - Content Management Server 2002 Service Pack 2 installation information
  • 894691 - A list of the bugs that are fixed in Content Management Server 2002 Service Pack 2

Glitches with MCMS 2002 Service Pack 2

 

posted Saturday, November 12, 2005 4:16 PM by dgadamson with 0 Comments

IE Developer Toolbar Beta Refresh

The awesome Internet Explorer Developer toolbar has had a refresh (October 31, 2005) with a few bugs ironed out. Thanks Renaud for pointing out the update.

(via Microsoft Downloads)

Overview

The Internet Explorer Developer Toolbar provides several features for exploring and understanding Web pages. These features enable you to:

-- Explore and modify the document object model (DOM) of a Web page.
-- Locate and select specific elements on a Web page through a variety of techniques.
-- Selectively disable Internet Explorer settings.
-- View HTML object class names, ID's, and details such as link paths, tab index values, and access keys.
-- Outline tables, table cells, images, or selected tags.
-- Validate HTML, CSS, WAI, and RSS Web feed links.
-- Display image dimensions, file sizes, path information, and alternate (ALT) text.
-- Immediately resize the browser window to a new resolution.
-- Selectively clear the browser cache and saved cookies. Choose from all objects or those associated with a given domain.
-- Choose direct links to W3C specification references, the Internet Explorer team weblog (blog), and other resources.
-- Display a fully featured design ruler to help accurately align objects on your pages.


The Developer Toolbar can be pinned to the Internet Explorer browser window or floated separately.

This version of the Developer Toolbar is an updated version of Beta 1; it was updated on October 31, 2005. Several issues are resolved and some feedback has been incorporated.

-- Element bounding box calculations are more accurate.
-- Outlining of elements is now significantly faster.
-- The image report no longer crashes.
-- Installation no longer requires a reboot. (Beta 1 users will still be prompted to reboot because the current installer invokes the original uninstaller).
-- The minimize and maximize buttons now refresh after the "Resize" command.
-- The "Select element by click" bounding box is now more visible on pages with blue backgrounds.
-- The attributes editor (middle pane) now has variable width fields (for example, you can type beyond the width of the box).
-- Fixes for some pages that do not trigger OnDocumentComplete events.
-- Fixed the continuity of using "element" rather than "tag" in the menus.
-- The ruler is easier to use and to scroll.
-- Enabling/disabling images no longer restarts Internet Explorer.
-- The Resize menu now contains more resolutions.
-- Editing a property is now much less likely to let keystrokes "leak" back to IE and navigate without the user expecting it.
-- Trying to use the ruler while IE is in "folder mode" should no longer crash the browser.

New features and functionality have also been added.

-- Default styles (in the third pane) now appear in gray, separating them from explicit styles.
-- The ruler dialog is always populated with the ruler information if there is just one ruler.
-- The ruler dialog now describes advanced features.
-- "Undo all" reverts the page to the initial state.
-- You can now remove all outlines.
posted Sunday, November 06, 2005 10:05 AM by dgadamson with 1 Comments