1. Home
  2. Point-Of-Sale Software
  3. Very new to MS RMS...

Very new to MS RMS...

I'm a software developer by training and trade. I'm very familiar with SQL Server and computers. I've been heavily using both for 10 years.

I recently installed Microsoft RMS on Windows and am completely at a loss for what to do next. I followed the directions. I imported the RMSample from the DB's folder.

When I go into the Adminstration tool I'm told to connect then I am asked for a username/password. I can use Windows Authentication or I can use "SA". Having come from SQL Server 2000 I'm used to being able to open the Enterprise Manager and create accounts, view tables, databases, etc... MSDE is a very different animal or is it? I tried connecting to the RMSSample data but when I do nothing happens. I don't get errors. I try setting up the connection in the connection dialog and then I get ODBC errors. Knowing ODBC very well I realize that it might not have a connection defined. But again I don't know the SA user and password since the install does not prompt you to set it.

Has anyone written a getting started guide that covers this stuff in a real way not the usual abstract Microsoft way? Can anyone tell me what to do next? What I've done wrong? Offer me some pointers... I'm stumped.

Thanks,

Rex Winn

Reply to
Rex Winn
Loading thread data ...

Rex,

If you connect fine from the Connect window in Administrator, it's supposed to go blank. You may also notice that buttons and options light up, and that the DB and server names show up in the bottom left corner of Administrator. Use the Configuration screen to connect RMS to the DB. Click "Test Database Connection" to be sure. If it all works press OK. At this point you should be able to run Store Ops Manager.

The ODBC must be done as a system DSN. In the ODBC settings:

-Connect with Windows Authentication

-Check "Connect to SQL to obtain defaut settings..."

-All of the other buttons and such should be deaults

Hope this helps, Matt

Reply to
Matt

Rex,

When you installed RMS, it asked for a password. Go into Administrator | File | Connect | the server name should be (local) | check Use SQL Server | SA for the user name | type in your password.

Then go to File | Configuration | make sure you have the server set to (local) | put in your password | put in the database name you created | test database connection

When you're connected properly, on the bottom left of the screen, it should say Sever: (your machine name). More to the middle it says Database: (whatever you named the database)

Then your good to go.

Reply to
Jeff

Man, you guys are good!

That all worked. Now how about setting up the lanes? Do I just take the CD install it on the other PC's create a DSN for the server and away I go right?

- Rex

Reply to
Rex Winn

Perfect! I replied to the post above yours and figured we could just merge there. My next question is about setting up the clients.

Reply to
Rex Winn

Rex,

  1. At Register 1, so into Administrator and create as many registers as there are machines running RMS, including back office machines. If you have three machines running RMS, regardless of whether it's at the POS or not, make three registers.
  2. For every register (except #1, unless you want to change it) go to the machine and assign each their unique register number. Go to Administrator, then Configuration, then the Register tab. Change the register number there.

Good luck, Matt

Reply to
Matt

Rex,

In addition to Matt's comments, create a permanent IP address for the server machine. When setting up your additional registers, change the server name in SO Administrator to the IP of the server machine.

Also remember that the register #1 has be the first machine that you run SO Manager or SO POS in the morning and has to have the security dongle on it. The program needs to see the security dongle first, every morning.

Reply to
Jeff

MSDE is a very similar animal to SQL Server - it just doesn't include any of the visual tools that are installed along with the full versions of SQL Server. If you have those tools (and of course a license) available on another system, you can still use them to connect to, query and manage an MSDE database. The only query tool that installs with MSDE is OSQL - the old school command line interface - you can learn about it in SQL Server books online if you like...

If you didn't enter a password during the MSDE instaall, the password is blank - just like SQL Server...

If you can't connect using SQL Authentication, because you don't know the password, log into Windows as a local administrator, open Store Ops Administrator and go to File/Connect. Connect using Windows Authentication. Go to Query/New and enter the following in the query window: EXEC sp_password null, 'MyNewPassword', 'sa' then select Query/Run

This will reset the sa password

Your major problem was addressed in a previous post - once you've created your database, you don't really need to use File/Connect again (except for occasional db maintenance tasks). What you want to do is use File/Configuration and setup the Database Tab. You can't use Windows Authentication here - this is where you need to know a password...

I haven't looked for a while, but IIRC the Getting Started Guide covers these basic setup & configuration steps. Of course, once you open up manager, the real work begins...

Reply to
Glenn Adams [MVP - Retail Mgmt]

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.