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:

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

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.

Add SMS/ConfigMgr Sites

Check the CentralServerName in the Registry:

CentralServerName

To start the ShoppingCentral Service and IIS run:

iisreset /start

net start shoppingcentral

Share this post

Share this post on your favourite social media platform.

Find this article useful?

If so please click here