April 18, 2011
1E

How to change the SMS/ConfigMgr Provider in Shopping 3.1

Recently I was asked to document the process to change shopping to point to a different SMS/ConfigMgr server by a customer. the following details what needs to be changed.
On the Shopping Central server run:
net stop shoppingcentral
iisreset /stop
Using the SQL Management Studio open the shopping2 database and run the following T-SQL to determine the current values which need to be updated
*Note* use the values according to your specific server names and sitecodes hightlighted below

SELECT [PreferenceID], [PreferenceName], [PreferenceValue], [ValueEncrypted], [ReadOnly], [Hidden], [Category], [Description], [Type] FROM [Shopping2].[dbo].[tb_Preference] WHERE PreferenceValue like '%VMSMS1%' or PreferenceValue like '%A01%'

Output:

Then edit the following T-SQL and run it to update the above values

Update tb_Preference SET PreferenceValue = 'SERVER=SCCMCENTRALSVR;DATABASE=SMS_C00;Trusted_Connection=yes;' WHERE PreferenceName = 'SMS-ConnectionString'
Update tb_Preference SET PreferenceValue = '\\SCCMCENTRALSVR\root\sms\site_C00' WHERE PreferenceName = 'SMS-Namespace'
Open the file C:\Program Files\1E\Shopping\WebSite\ShoppingAPI\web.config
Change the following highlighted values to point to the correct SMS/ConfigMgr server
<appSettings>
<add key="AppName" value="ShoppingAPI"/>
<add key="ConnectionString" value="SERVER=SHOPDBSERVER; DATABASE=Shopping2;Trusted_Connection=yes;"/>
<add key="SMSConnectionString" value="SERVER=VMSMS1; DATABASE=SMS_A01; Trusted_Connection=yes;"/>
<add key="Shopping.Common.Components.SiteSettings" value="Templates\DefaultSettings.config"/>
<add key="EmailAttachmentLicence" value="Templates\DefaultEmailAttachment.xml"/>
<add key="EmailAttachmentNewRequest" value="Templates\DefaultEmailAttachment.xml"/>
<add key="EmailParametersTemplate" value="Templates\ShoppingParameters.xml"/>
<add key="GlobalisedResourceFolder" value="GlobalResources\"/>
<add key="ApplicationStringsFile" value="ShoppingWebStrings.resx"/>
</appSettings>

Open the file C:\Program Files\1E\Shopping\WebSite\Shopping\web.config
Change the following highlighted values to point to the correct SMS/ConfigMgr server

<appSettings>
<add key="AppName" value="Shopping Cart"/>
<add key="ConnectionString" value="SERVER=SHOPDBSERVER;DATABASE=Shopping2;Trusted_Connection=yes;"/>
<add key="SMSConnectionString" value="SERVER=VMSMS1;DATABASE=SMS_A01;Trusted_Connection=yes;"/>
<!-- Path of the configuration file for the Themes. -->
<add key="Shopping.Common.Components.SiteSettings" value="Templates\DefaultSettings.config"/>
<add key="EmailAttachmentLicence" value="Templates\DefaultEmailAttachment.xml"/>
<add key="EmailAttachmentNewRequest" value="Templates\DefaultEmailAttachment.xml"/>
<add key="EmailParametersTemplate" value="Templates\ShoppingParameters.xml"/>
<add key="GlobalisedResourceFolder" value="..\ShoppingAPI\GlobalResources\"/>
<add key="ApplicationStringsFile" value="ShoppingWebStrings.resx"/>
<add key="LogFileLocation" value="C:\Documents and Settings\All Users\Application Data\1E\Shopping\"/>
<add key="ClientProbeVersion" value="3.1.0.304"/>
</appSettings>

Open the C:\Program Files\1E\Shopping\AdminConsole\Shopping.Admin.Client.exe.config
Change the following highlighted values to point to the correct SMS/ConfigMgr server

<appSettings>
<!-- settings - updated via the Settings Dialog in the Admin Console-->
<add key="AppName" value="Shopping Admin"/>
<add key="ConnectionString" value="SERVER=SHOPDBSERVER;DATABASE=Shopping2;Trusted_Connection=yes;"/>
<add key="SMSConnectionString" value="SERVER=VMSMS1;DATABASE=SMS_A01;Trusted_Connection=yes;"/>
<add key="DatabaseVersion" value="40"/>
<add key="SMSNamespace" value="\\VMSMS1\root\sms\site_A01"/>
<add key="SMSUser" value=""/>
<add key="SMSPassword" value=""/>
<add key="SMSImpersonationLevel" value="Impersonate"/>
<!-- settings for UnhandledExceptionManager class -->
<add key="UnhandledExceptionManager/EmailTo" value=""/>
<add key="UnhandledExceptionManager/ContactInfo" value="1E Support at +44 (0) 208 326 3880"/>
<add key="UnhandledExceptionManager/IgnoreDebug" value="False"/>
<add key="UnhandledExceptionManager/LogToEventLog" value="True"/>
<add key="Shopping.Admin.Components.AppSettings" value="UserSettings.config"/>
<add key="AppURL" value="Application.soap"/>
</appSettings>

Add the new SMS/ConfigMgr site in the Shopping admin Console

Right-click the sites node (above)
Click Add SMS/ConfigMgr Sites
Add the new site C00 from the left side to the right side and click OK.

Check the CentralServerName in the Registry:

To start the ShoppingCentral Service and IIS run:
iisreset /start
net start shoppingcentral