Untitled Document
Microsoft Dynamics RMS Experts
  Register   Login
 Search
RMS Experts
 
  You are Here: Dynamics RMS Community ... Dynamics RMS and POS Forums
 
RMS and POS Forums
Subject: Change db connection properties

You are not authorized to post a reply.   
Author Messages
olie04
Posts:33

04/26/2010 8:51 AM Alert 
Hello all. Can anyone give me insight how I can change the connection settings to connect to a different database, or where those settings are stored so that I may make a batch file to switch to whatever store we would want to connect to? My manager wants to be able to edit certain settings for each store, and instead of me always having to change the database settings in RMS Admin, I would just like to create a batch file that would change the properties automatically. Any help would be greatly appreciated! Thanks!
Mixer
Posts:69

04/26/2010 9:44 AM Alert 
The db connection settings are kept in system registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Server\Database

(or, on 64-bit Windows Vista-7 machines:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Retail Management System\Store Operations\Server\Database

The problem is though since RMS 2.0 SP2 those have been encrypted, as mandated by the PCI-DSS standards. So then, you still have to use RMS Administrator at least to set those settings for the first time. After that you can try to export the registry key and import it on the target machine using regedit.
olie04
Posts:33

04/27/2010 8:07 AM Alert 
Which is probably why doing a registry search for one of the settings did not come up with anything. lol. Thanks for the support mixer!
You are not authorized to post a reply.
Forums > Microsoft RMS and POS > General RMS and POS Discussion > Change db connection properties



ActiveForums 3.6
Sponsor
(c) 2006-2012 Retail Hero ®