In Catalog Manager, when you perform a search for a product, category, etc. by default the maximum number of results that will be returned is 500. You can alter the maximum number or results returned by making changes in the Catalog Web Service web.config file. In the web.config file you will find the notations on values for the property to change like this.
maxSearchResults: (Optional)
Potential values include 0 (No limit) and all positive integers 1-2147483647
Disable Authorization Manager authorization.
WARNING: Removing this value could allow very large search results to consume server resources.
You will edit the value in the section below. See bolded item.
<catalogWebService siteName="AutoNation2" authorizationPolicyPath="CatalogAuthorizationStore.xml" debugLevel="Production" maxChunkSize="1024" maxUploadFileSize="2048000" timeOutHours="24" enableInventorySystem="true" disableAuthorization="false" maxSearchResults="500">
<cache enable="false" schemaTimeout="5" itemInformationCacheTimeout="5" itemHierarchyCacheTimeout="5" itemRelationshipsCacheTimeout="5" itemAssociationsCacheTimeout="5" catalogCollectionCacheTimeout="5"/>
</catalogWebService>
One note on altering the value. The notation on what value can be entered indicates that you can set the value to 0 so that all results will be returned. This is not correct for Commerce Server 2009. If you set it to 0 then the web service will fail with an exception that the property being set to a value of 0 is invalid. You will need to set a value to a positive integer as noted in the notation.
Both Commerce Server 2007 and Commerce Server 2009 have been tested on Windows Server 2008 R2 and both are fully supported on this platform. However there are a few items that I wanted to review regarding either upgrading or installing either version of Commerce Server on this platform.
For Commerce Server 2007, there are no issues with performing a new installation on Window Server 2008 R2. However, once the installation is complete and the configuration wizard has finished setting up the initial server databases you will need to install Commerce Server 2007 Service Pack 2 to be in a supported state. You will want to complete the service pack installation before you setup any Commerce sites on the server. If you are performing an operating system upgrade to an existing Commerce Server 2007 deployment, you should install Commerce Server 2007 Service Pack 2 and run the upgrade wizard against each Commerce site already deployed and verify that all site functionality prior to the operating system upgrade.
For Commerce Server 2009, there is an additional step that will need to be performed prior to the installation. With the installation of Commerce Server 2009 CD2 it performs a check for .NET Framework 3.5 SP1 and does this check by looking for a registry key stating that it has been installed. With Windows Server 2008 R2 the framework is already built-in to the operating system and therefore the registry key showing that it has been installed is not present. There is an update that you will need to obtain to resolve the installation issue which can be found in Microsoft Knowledge Base Article 975567; http://support.microsoft.com/default.aspx?scid=kb;EN-US;975567. You will want to obtain the update and run it against your server prior to the installation of either CD1 or CD2 of Commerce Server 2009. When you run the update it will perform a single check for the registry key and if present let you know that the update is not needed and do nothing, but if it is not present then it will add the registry entry and then exit. After the update is applied you can perform the installation of Commerce Server 2009 normally. If you are performing an operating system upgrade to a server that is already running Commerce Server 2009 there is no need to obtain the update as Commerce Server 2009 is already installed and the required components are already in place.
If you have deployed any of the Commerce Server 2009 sample sites or your own custom site on a Windows SharePoint Services 3.0 based deployment, and then decide to upgrade that deployment to Office SharePoint Server 2007, your Commerce sites already deployed will cease to function correctly.
This is because when you use the SharePoint Commerce Services Configuration Wizard to deploy the site, it will check to see if WSS or MOSS is deployed and based on what is deployed it will choose the appropriate WSP files to deploy for the site collection. There are different versions for WSS and MOSS.
If you wish to upgrade an existing WSS deployment to MOSS you will need to back-up all of your site databases and site content, then remove the site in SharePoint Central Administration prior to performing the upgrade. Once the upgrade is complete you can deploy the appropriate site using the SharePoint Commerce Services Configuration Wizard and then merge any site customizations previously done into the new site.
With Commerce Server 2007 and 2009, if you are using a site based on the Core API such as the Starter Site, you can set the site to share cookie domain level at 2. If you have the web application non-secure hostname (for example: NonSecName.testsite.com) set to a different name than secure host name (for example: SecName.testsite.com, same testsite.com), the cookie sharing works correctly in Internet Explorer 6 and 7 but not in Internet Explorer 8.
The symptom:
Anonymous user add items to cart, then switch the URL from the non-secure hostname to secure hostname by an action such as going to checkout, the items in the basket will disappear in Internet Explorer 8 for the same anonymous user.
Resolution:
For code based on the Starter Site, modify the Starter Site code before you set the site_identity cookie, set Cookie.Domain= “testsite.com”.
(App_Code/SiteSecurity.cs)
________________________________________________________________
public static HttpCookie CreateUserCookie()
{
…
cookie.Value = CommerceContext.Current.UserID;
if (!isAnonymousUser)
{
cookie.Value += "/" + HashValue(userProfile.EmailAddress);
}
cookie.Domain = "testsite.com";/*Jason: this is what I added*/
HttpContext.Current.Response.Cookies.Set(cookie);
…
When entering the store objects in Customer and Orders Manager for the Store Locator, you have the option to enter in the latitude and longitude of the store location. Traditionally latitude and longitude are shown in the following format of Degrees, Minutes, Seconds (35° 8' 18"). When entering the values for the store object they must be entered in what is called decimal degree format which will look something like 80.12345.
To convert the latitude and longitude from the traditional format to decimal degrees you will need to use the below formula.
Decimal Degrees = Degrees + (Minutes / 60) + (Seconds / 3600)
For example, 35° 8' 18" would work out as 35 + (8/60) + (18/3600) = 35.13833.
In Commerce Server 2009 we have a new feature as part of the new default sites. This is the Store Locator. The Store Locator provides the ability to have a user enter an address or zip code and find all of your store locations along with getting driving directions. Prior to using the Customer and Orders Manager to create your store objects and Virtual Earth configuration object you will need to update the <language>_PresentationInfo.xml files to include the needed profile object display information.
In the Commerce Server 2009 Installation Guide we include the profile information that needs to be added but it is only for the English language. As Commerce Server 2009 includes support and <language>_PresentationInfo.xml files for English, German, French and Japanese you can take one of the following approaches to updating each file.
- Use the English language profile information from the installation guide and place it in each <language>_PresentationInfo.xml file. This will permit the profile objects to be created successfully for each language supported but the text will be in English for all languages.
- Use the English language profile information from the installation guide and place it in the en_PresentationInfo.xml file. This will update the English language version of the file. For the other languages use the same profile content but manually translate and edit the displayName=”…” and description=”…” entry in each line to reflect the language of the selected _PresentationInfo.xml file.
For those that choose to use option number 2 above, I’ve attached an XML file that has the profile information already translated for each language. The translation were done using online translation tools and some input from native speakers of German and French so the translations on some items may need to be reviewed prior to use. Just wanted to offer the information to help get you up and running as quickly as possible.
Attachment(s): _PresentationInfoUpdates.xml
When you setup a new site in Commerce Server 2009 using the SharePoint Commerce Services Configuration Wizard (SCSCW), it can be used to create the new web applications in both SharePoint and IIS. When you do this there is one additional step that you may need to take if you plan to use the Commerce Server Data Warehouse Authentication Module <CommerceDataWarehouseAuthenticationModule>.
The IIS web applications that are created by the SCSCW may not have the necessary fields set to be logged in the IIS web log files. To correct this issue please verify that the following fields at a minimum are set to be recorded in the IIS web log files for both the NTLM and FBA sites.
| Date (date) | Time (time) | Client IP Address (c-ip) | User Name (cs-username) |
| Method (cs-method) | URI Stem (cs-uri-stem) | URI Query (cs-uri-query) | Cookie (cs(Cookie)) |
| Host (cs-host) | Referer (cs(Referer)) | User Agent (cs(User-Agent)) | Win32 Status (sc-win32-status) |
| | | | |
When you configure the user account for the application pool that the Default Site or the Contemporary Site will use per the product installation guide, typically referred to as the RunTimeUser account, you may see an issue where the FBA site will not open correctly but the NTLM site opens fine. This is seen by the site map provider not rendering correctly and no product category data being seen. Other content that appears in the NTLM site may not be seen as well.
There is a permission missing for ctlg_CatalogReaderRole on a stored procedure that can be corrected by running the script below on the product catalog database.
/* Grant permission to ctlg_CatalogReaderRole */
Begin
GRANT EXECUTE ON [dbo].[ctlg_GetPropertyDefinitionLanguages] TO [ctlg_CatalogReaderRole]
End
GO
Another option or workaround is to change which role permissions are granted to the RunTimeUser account on the product catalog database.
By default the role permissions on the product catalog database are setup as:
| Database | User Account | Role Permission |
| <site_name>_ProductCatalog | RunTimeUser | ctlg_catalogReaderRole Inventory_RuntimeRole |
If you use the following role permissions the issue will be resolved.
| Database | User Account | Role Permission |
| <site_name>_ProductCatalog | RunTimeUser | ctlg_catalogWriterRole Inventory_RuntimeRole |
This option will resolve the issue but is not ideal as it will grant the RunTimeUser greater permissions than it needs.
If you would like a product update on this issue so that you do not need to perform these steps every time you deploy either the Default Site or the Contemporary Site in Commerce Server 2009 please contact Microsoft Commerce Server Support.
As Commerce Server 2009 is now out and available I thought it would be a nice idea to do a post on “Where Can I learn more about Commerce Server 2009?”.
The first place to keep in your list would be the documentation that is available here.
Commerce Server 2009 Documentation
Then you can take a look at the PDC Session from last year to give you an idea of the new features available in this product.
Commerce Server “Mojave” (Mojave was the code name for this version of Commerce Server.)
There is also a really good session from Scott Cairney from the Product Group over at Tech Ed Online with a Q and A.
There’s no direct link unfortunately but you can go to Tech Talks at Tech Ed Online and search for “Commerce Server” and you’ll find this video and a choice of download formats.
One of the really nice new features in Commerce Server 2009 is the ability to integrate with Virtual Earth to build a Store Locator page.
Tom Schultz has a Web Cast that’s up on Channel 9. Channel 9 Store Locator Webcast.
If you’d like to feed back to Tom about this Webcast then he has a permalink over on his blog.
There is also a lot of sample code at Multi-Channel Foundation Samples that will show you how to use the new API’s.
Finally if you’re a Commerce Server Partner we have the following sessions over at Partner Academy Live.
The steps to setup and configure site variations in the Commerce Server 2009 Default Site and the Contemporary Site have been worked over several times here and instead of having a 10 page long post on the topic, we have published new documentation to cover the steps on setting up such a configuration. You can download the document by selecting the Download link below.
Download
Enjoy
As there have been question in the past on the terms and definitions used by Commerce Server, a while back we published a list in the Commerce Server 2002 time frame outlining the meanings to the terms and definitions. I thought it might be a good idea to re-visit this topic and update them to reflect the current product usage.
- Commerce Server Site: A Commerce Server site is a collection of site resources and ASP or ASP.NET-based applications that use these resources through the Commerce Server object model. With a Commerce Server site, you can administer the applications in the site as a group.
- Note: A Commerce Server site is not the same thing as the concept of a Web site in Microsoft Internet Information Services (IIS).
- Commerce Server Resource: A Commerce Server resource adds functionality to the applications in a Commerce Server site. You can use the Commerce Server Manager to configure properties in a Commerce Server resource. Resources are either site resources or global resources. Global resources can be shared across Commerce Server sites. Site resources cannot be shared across Commerce Server sites. For example, the Product Catalog resource is a site resource and the Data Warehouse resource is a global resource.
- Commerce Server Application: A Commerce Server application is a logical representation of an application in IIS. The Commerce Server application appears in both the Commerce Server Manager and in IIS Manager Console trees. In the IIS console tree, a Commerce Server application is either at the root directory level of the Web site or at a sub-directory or virtual directory level of the web site.
- A Commerce Server application may be one of the following:
- A web service application such as the Catalog Web Service
- A web site application
- Commerce Server deployment: A Commerce Server deployment is made up of one or more physical installations of Commerce Server that are directed to or share a single Commerce Server administrative database (MSCS_Admin Database). All Commerce Server sites that share a common MSCS_Admin database make up a single Commerce Server deployment.
- Web server: In Commerce Server, a Web server is a computer that has IIS installed. The Web server contains the virtual directories, the files, and the subfolders for a Commerce site. A Commerce deployment can have multiple Web servers that together form a Web farm.
- IIS-based Web site: An Internet Information Services-based Web site runs on a specific TCP port number. For example, by default, the "Default Web Site" or "Administration" web site.
The following quick installation instructions are for developers who already have a Commerce Server 2007 installation up and running and want to upgrade to Commerce Server 2009.
This post will walk you thru the required installation steps to get the sample Sharepoint DefaultSite working. It assumes you are running Commerce Server 2007 Standard or Enterprise editions on Windows Server 2008 and that you have a service account named servername\runtimeuser which is part of the local Administrators group, IIS_IUSRS group, and is a sysadmin on your SQL 2008/SQL 2005 machine.
The first thing that needs to be decided is whether you want to install WSS or MOSS.
If you are using WSS:
a. WSS 3.0 with SP1; for the 32-bit version see http://go.microsoft.com/fwlink/?LinkId=139486; for the 64-bit version see <http://go.microsoft.com/fwlink/?LinkId=139487>
Note
You must perform a custom installation of WSS, not a basic installation. Also choose the web frontend option when asked to.
b. WSS 3.0 December Cumulative Update
http://support.microsoft.com/kb/961755/
If using MOSS:
a. MOSS 2007 SP1 (<http://go.microsoft.com/fwlink/?LinkId=130488>)
c. Install the December Cumulative Updates for both WSS 3.0 and MOSS 2007
http://support.microsoft.com/kb/961755/
http://support.microsoft.com/kb/961756/
The Sharepoint products and technologies configuration wizard should run after each cumulative update install.
We should now be ready to run the Commerce Server 2009 setup. The setup.exe is located on CD2 of the Commerce 2009 media.

During the setup near the end of the process it will launch the Microsoft Commerce Server Configuration Wizard, same as Commerce Server 2007.

After running the Configuration wizard the Commerce Server 2009 Upgrade wizard should launch.
Be sure to migrate your site resources otherwise your old sites won't work!

Once installation is completed you may need to reboot.
Setting up your DefaultSite is as simple as running a wizard.
Go ahead and launch the Microsoft SharePoint Commerce Services Configuration Wizard
A dependency check will run and you will want to make sure everything checks out ok then click next.

Next you want to select Commerce SharePoint Default Web Site and Web Parts as your deployment option.

Now you want to select your Web Application. Go ahead and click the ... to create a new web application.
So you will now give a description and port for 2 IIS Sharepoint web sites to be created.
IIS Web Site will be a NTLM site used to edit/administer your site.
Extended IIS Web Site will be the actual web site that your customers will go to.
Go ahead and create a new application pool using servername\runtimeuser as the identity.
Once you click next the wizard will go ahead and create your 2 IIS Sharepoint sites and your application pool. It will configure all the authentication for you.

You will now be brought back to the following screen.

· Go ahead and select the web application you just created from the drop down.
· Verify that Create Commerce Site is checked.
· Modify your site name and description if you want to change it.
· Select Unpack Commerce Server Site (with sample data).
· Enter the name of your database server
Go ahead and click next, then confirm your selections on the next screen.
The wizard will go ahead and unpup the microsoftcommercedefaultsitewithsampledata.pup and create a new commerce site and setup the Commerce site.
You will now want to unpackage the web services from microsoftcommercedefaultsitewithsampledata.pup manually. This is located at \Program Files (x86)\Microsoft Commerce Server 2007\Microsoft Commerce Server 2009\Site.
Next you will want to go ahead and perform the normal post-deployment procedures.
Verify that your servername\runtimeuser has write permissions on the catalogauthorizationstore.xml
Setup your azman.msc permissions for you business user applications.

Use the following steps to create a Commerce Server user who owns the Default Site, and tie Commerce Server users to the SharePoint registered users group.
To configure permissions for authenticated users
|
1. Open Customer and Orders Manager.
2. Create a new Commerce Server user profile that you will use as an Administrator for the forms-based authentication (FBA) zone of the Default site.
3. In Internet Explorer, access the main zone of the Default Site.
4. Click Site Action, click Site Settings, and then click People and Groups.
5. Under groups, click <site_name> Owners
6. Click New.
7. In the Add Users screen, in Users/Groups, type name of commerce server user created in step 1.
8. In left menu, under Groups, click More.
9. Click Registered Users.
10. Click New.
11. In the Add Users screen, in Users/Groups, type SignedInClient as the value. |

To specify the Default Web site channel and catalog names
|
1. Log on to the operating system under a user account that has administrative privileges in SharePoint for the site collection where the Default Web site was deployed.
2. In your browser, navigate to the Default Web site. The URL is as follows:
http://<host>:<port>/Pages/default.aspx
3. Click Site Actions, and then click View All Site Content.
4. Under Lists, click Channel Configuration.
5. In the list, click Channel, and then click Edit item.
6. In the Value box, type Default, and then click OK. You must type the value exactly as it appears here.
7. In the list, click Default Catalog, and then click Edit item.
8. In the Value box, type Adventure Works Catalog, and then click OK. |

Your Commerce 2009 Sample Site should now be up and running. Go ahead to IIS and browse the site!

The Commerce Server 2009 Installation guide is a large document covering the setup and deployment of Commerce Server 2009. Although great effort went into making sure we covered all the aspects of setting up Commerce Server 2009 some things in the document may have been missed, stated incorrectly or just need a bit more clarification. In this post I will try to make clear any sections of the installation guide so that you can complete your tasks efficiently.
For the latest revision of the Commerce Server 2009 Installation Guide please download it from here:
http://download.microsoft.com/download/5/B/E/5BE19F83-EC42-41EE-8A21-B70222247DB8/CS2009Installation.doc
On page 26 you will find the following:
8. (Optional) If you plan to use the Data Warehouse in Commerce Server 2009 with SQL Server 2008, you must install the following, in the order listed:
a. Microsoft SQL Server Native Client. See http://go.microsoft.com/fwlink/?LinkId=139308.
b. Microsoft SQL Server 2005 Management Objects Collection. See http://go.microsoft.com/fwlink/?LinkId=139309.
c. Microsoft ADOMD.NET. See http://go.microsoft.com/fwlink/?LinkId=139310.
d. Microsoft SQL Server 2005 Backward Compatibility Components. See http://go.microsoft.com/fwlink/?LinkId=139311.
e. Microsoft SQL Server 2005 December 2008 Feature Pack. See http://go.microsoft.com/fwlink/?LinkId=139312
This step is better explained by the following:
8. (Optional) If you plan to use the Data Warehouse features in Commerce Server 2009 with SQL Server 2008, you must install the following items from the Microsoft SQL Server 2005 December 2008 Feature Pack, in the order listed below.
The Microsoft SQL Server 2005 December 2008 Feature Pack can be found at http://go.microsoft.com/fwlink/?LinkId=139312. Be sure to select the appropriate version for each item if you are running on an x86 platform or an x64 platform.
a. Microsoft SQL Server Native Client
b. Microsoft SQL Server 2005 Management Objects Collection
c. Microsoft ADOMD.NET
d. Microsoft SQL Server 2005 Backward Compatibility Components
==================================================================================================
On page 27 you will find the following:
13. To install WSS or MOSS, click the links below for instructions and information about the relevant updates.
If using WSS:
a. WSS 3.0 with SP1; for the 32-bit version see http://go.microsoft.com/fwlink/?LinkId=139486; for the 64-bit version see http://go.microsoft.com/fwlink/?LinkId=139487
Note
You must perform a custom installation of WSS, not a basic installation.
b. WSS 3.0 December Cumulative Update (http://go.microsoft.com/fwlink/?LinkId=139489)
If using MOSS:
a. MOSS 2007 (For information about licensing and pricing for MOSS 2007, see http://go.microsoft.com/fwlink/?LinkId=142244)
b. MOSS 2007 SP1 (http://go.microsoft.com/fwlink/?LinkId=130488)
c. December Cumulative Update for both WSS 3.0 and MOSS 2007 (http://go.microsoft.com/fwlink/?LinkId=139489)
This step is better explained by the following:
13. Determine if you will be using Windows SharePoint Services 3.0 (WSS) or Microsoft Office SharePoint Server 2007 (MOSS). If you will be using Windows SharePoint Services 3.0 follow the steps in the section "If using WSS:". If you will be using Microsoft Office SharePoint Server 2007 then follow the steps in the section "If using MOSS:".
To install WSS or MOSS, click the links below for instructions and information about the relevant updates.
If using WSS:
a. Install WSS 3.0 with SP1
For the 32-bit version see http://go.microsoft.com/fwlink/?LinkId=139486
For the 64-bit version see http://go.microsoft.com/fwlink/?LinkId=139487
Note: You must perform a custom installation of WSS, not a basic installation. After selecting to perform a custom installation you will need to select the option Web Frontend.
b. December Cumulative Update for Windows SharePoint Services 3.0. See http://go.microsoft.com/fwlink/?LinkId=139489. When selecting the download be sure to select the appropriate x86 or x64 platform for your installation.
If using MOSS:
a. Install MOSS 2007 (For information about licensing and pricing for MOSS 2007, see http://go.microsoft.com/fwlink/?LinkId=142244)
b. Install MOSS 2007 SP1. See http://go.microsoft.com/fwlink/?LinkId=130488.
Note: If you installed the slipstreamed version of MOSS 2007 with SP1 already included then this step can be skipped.
c. December Cumulative Update for Windows SharePoint Services 3.0. See http://go.microsoft.com/fwlink/?LinkId=139489. When selecting the download be sure to select the appropriate x86 or x64 platform for your installation.
d. December Cumulative Update for Microsoft Office Servers. See http://go.microsoft.com/fwlink/?LinkId=139489. When selecting the download be sure to select the appropriate x86 or x64 platform for your installation.
==================================================================================================
On page 119 you will find the following:
Specifying the Default Site Channel and Catalog Names
Use the following instructions to specify the Default Web site channel and catalog names.
To specify the Default Web site channel and catalog names
1. Log on to the operating system under a user account that has administrative privileges in SharePoint for the site collection where the Default Web site was deployed.
2. In your browser, navigate to the Default Web site. The URL is as follows:
http://<host>:<port>/Pages/default.aspx
3. Click Site Actions, and then click View All Site Content.
4. Under Lists, click Channel Configuration.
5. In the list, click Channel, and then click Edit item.
6. In the Value box, type Default, and then click OK. You must type the value exactly as it appears here.
7. In the list, click Default Catalog, and then click Edit item.
8. In the Value box, type one of the following:
· If you unpacked the Commerce Site with sample data, type Adventure Works Catalog, and then click OK. You must type the value exactly as it appears here.
· If you unpacked only the schema of the Commerce Site (no sample data), type the name of your catalog, and then click OK.
9. Go back to the URL of the Default Web site.
The site now displays the Web Parts.
10. Navigate to the Category page of the Default Site. The URL is as follows:
http://<host>:<port>/Pages/Category.aspx
1. On the page, click Site Actions, and then click Edit Page.
The page is now in edit mode.
1. In the toolbar of the Product Query Web Part, click Edit, and then click Modify Shared Web Part.
The Web Part properties pane opens.
1. Expand the Advanced (Commerce) properties. In the Catalog box, type the same catalog name as you did for step 8 above, and then click Apply.
This section should state the following:
Specifying the Default Site Channel and Catalog Names
Use the following instructions to specify the Default Web site channel and catalog names.
To specify the Default Web site channel and catalog names
1. Log on to the operating system under a user account that has administrative privileges in SharePoint for the site collection where the Default Web site was deployed.
2. In your browser, navigate to the Default Web site. The URL is as follows:
http://<host>:<port>/Pages/default.aspx
3. Click Site Actions, and then click View All Site Content.
4. Under Lists, click Channel Configuration.
5. In the list, click Channel, and then click Edit item.
6. In the Value box, type Default, and then click OK. You must type the value exactly as it appears here.
7. In the list, click Default Catalog, and then click Edit item.
8. In the Value box, type one of the following:
· If you unpacked the Commerce Site with sample data, type Adventure Works Catalog, and then click OK. You must type the value exactly as it appears here.
· If you unpacked only the schema of the Commerce Site (no sample data), type the name of your catalog, and then click OK.
9. Go back to the URL of the Default Web site.
The site now displays the Web Parts.
==================================================================================================
On page 126 you will find the following:
Setting up Site Variations for the Default Site
This topic is missing steps and data that is needed in order to complete the process correctly. As the topic is long please see the following blog post on setting this up. The information supplied in the blog post will be incorporated in to a future version of the installation guide.
http://blogs.msdn.com/commercesupport/archive/2009/03/17/how-to-setup-site-variations-for-the-default-site.aspx
==================================================================================================
We have completed all testing of both the Commerce Server 2007 Core API and the Data Warehouse functionality with SQL Server 2005 Service Pack 3. All test cases have passed with no issues and we do fully support this update to SQL Server 2005.
The MSDN support and news forum for partners and customers is now live and you can start posting your Commerce Server 2009 related questions, suggestions and feedback on the forum.
http://social.msdn.microsoft.com/Forums/en-US/commserver2009/threads/
To visit the forums for Commerce Server 2007 and earlier versions you can use the link below.
http://social.msdn.microsoft.com/Forums/en-US/category/commserver/