Seriously? Administrator access is required? C'mon M$...

hi Anthony, I have very excellent solution and this is the case which I used to connect to my stores, work well and no problem at all. No need to go to administrator program to connect to dbserver. Convoluated given you one solution which has something missing so let me add this: Action1: go to regedit, then HKEY_LOCAL_MACHINE> Software> Microsoft > Retail Management then click the below SERVER. Right click on this and Export Name it to the server or Location identifier. Remember this will save the settings to registry to file.

Now go again to Administrator program connect to another server with credenital, userid, password and db name. Perform again Action1 above and export to the file name it differently. This task you have to do for all RMS Db for other location. I saved all these files to folder so this allow me to just play with it, whenever I wanted to connect to other db. and naming of these files are location.reg i.e. Austin.reg, Dallas.reg etc.

Now time to play, whenever you wanted to connect to any server no need to go to admin program just go to the register file and double click on this. this task only need to do you can distribute these files to other store managers. one more thing it encrypt all the paramaters so no need to worry that password will be availble for others.

Rate me if you like this Solution.

"anth> So we have several stores with several databases, and we have managers who

Anthony:

Use Akber's suggestion of exporting the registry keys and then create this batch file (code below).

You'll have to save the registry keys in this directory: C:\SO Config Files\SOconfig_STORE1.reg

Or simply change the code to fit your directory. You can replace 'STORE1' with store names or whatever.

Batch File: (copy/paste/modify in Notepad, save as SO Launch.bat (file type = 'all files').

------------------------------------------ @echo off set server_1_reg_file="C:\SO Config Files\SOconfig_STORE1.reg" set server_2_reg_file="C:\SO Config Files\SOconfig_STORE2.reg" set server_3_reg_file="C:\SO Config Files\SOconfig_STORE3.reg" set server_4_reg_file="C:\SO Config Files\SOconfig_STORE4.reg" echo MS RMS Store Operations Manager Database Chooser echo.

:server1 if exist %server_1_reg_file% goto server2 echo Please enter #1 server information in OPOS Administration Utility and Save echo Press Any Key When Done pause regedit.exe /e %server_1_reg_file% "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Server\Database\"

:server2 if exist %server_2_reg_file% goto server3 echo Please enter #2 server information in OPOS Administration Utility and Save echo Press Any Key When Done pause regedit.exe /e %server_2_reg_file% "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Server\Database\"

:server3 if exist %server_3_reg_file% goto server4 echo Please enter #2 server information in OPOS Administration Utility and Save echo Press Any Key When Done pause regedit.exe /e %server_3_reg_file% "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Server\Database\"

:server4 if exist %server_4_reg_file% goto filesexist echo Please enter #2 server information in OPOS Administration Utility and Save echo Press Any Key When Done pause regedit.exe /e %server_4_reg_file% "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Server\Database\"

:filesexist echo Please select the database you'd like to use. echo. echo Enter "1" for STORE 1. echo. echo Enter "2" for STORE 2. echo. echo Enter "3" for STORE 3. echo. echo Enter "4" for STORE 4. echo. SET /P server_var="Set Server To #: " if %server_var% EQU 1 ( regedit /s %server_1_reg_file% goto startpos ) if %server_var% EQU 2 ( regedit /s %server_2_reg_file% goto startpos ) if %server_var% EQU 3 ( regedit /s %server_3_reg_file% goto startpos ) if %server_var% EQU 4 ( regedit /s %server_4_reg_file% goto startpos ) echo Please Select a Store. echo. goto filesexist

:startpos START /d "C:\Program Files\Microsoft Retail Management System\Store Operations\" SOMANAGER.exe

------------------------------------------------------

Good luck, Tom

non-administrator?