I have a Small Biz Server with the RMS database on an instance of SQL Server. I want to occasionally open Store Ops Manager on that pc to run some reports and accept some store transfers.
Q1) Is it o.k. to install the RMS Store Ops programs on this box?
Q2) Is it o.k. to install HQ Client on this box?
Running SO Mgr on the server isn't an issue.
Running HQ Server and HQ Client on a box that hosts both databases is a performance disaster.
If the HQ Server is on another box, running HQ client is OK.
BEWARE: According to MS, SBS 2003 is a UNSUPPORTED OS for hosting RMS HQ or Store Ops. When we bought RMS (v1.2) SBS 2003 was a *recommended* OS. I had some transaction weirdness (transaction had the wrong total), called my partner, partner referred the issue to MS. MS replied: RMS database hosted on SBS 2003 not supported. For more assistance, buy a supported OS, stop using SBS 2003 to host RMS, re-create the issue and call us back. We'll be glad to help. Worthless support, IMO.
I've been running it with no problems for close to two years. However I use SQL2000 not MSDE. (Sql2000 is included with sbs2003) there may be some issue with 64bit or 2003r2 though.
sbs2003 32bit, SO 1.3, HQ client. works for me...
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.