I've just spent the last few days in a Commerce Server 2007 training course, which was surprisingly interesting. One of the things that leapt out at me was that there are a couple of partners who have worked with Commerce Server 2002 and EPiServer together. It's something that has interested me too and I see even more possibilities with Commerce Server 2007. Hmm... As soon as I got back I got busy getting EPiCloud release ready (and thinking of a nice name for it). In doing that I came across this old error again: "The trust relationship between the primary domain and the trusted domain faile... [More]

Overview Sometimes, old code doesn't seem to work with the new Data Execution Prevention feature in Microsoft Windows.  It's easy to turn it off for non-system applications and services, but how do you do it for system components, and why would you? Warning: Data Execution Prevention is a security feature.  Disabling DEP reduces the security of your system. Context On our Microsoft Commerce Server 2002 system, running on Windows Server 2003, we were getting "COM Surrogate" errors, which relate to DEP errors with the dllhost.exe system program.  Adding it to the exception list didn't solve ... [More]

Read the article... Excerpt The above error was occurring on both staging and live environments for a Microsoft Commerce Server 2002 system.  It took us a while to track down the cause, but eventually I fixed it. References Microsoft KB Article 811306 Versions Microsoft Windows Server 2003 Microsoft Commerce Server 2002 Metadata Technorati Tags: IT Management, Windows, Windows 2003, problem, Commerce Server

Overview How can you make your Commerce Server reports easy to maintain, and how can you make it work with long SQL queries?  Did you even know that long SQL queries won't always work?! The problem The query is stored in the Report table in SQL Server as an nvarchar(2000) field.  This means you've only got 2000 characters to work with.  In fact, the limit is smaller than this because of processing that Commerce Server is doing itself.  I noticed problems around 900 characters, which seems a bit small! The solution The best solution I found was to reference a SQL view that was created for ... [More]