RMS 1.3R just fine :)

it's not RMS that has the data limitation.

The database server, MSDE that is limited to 2 gig and MSDE's newest version SQL 2005 Express that is limited to 4 gig. If you want the ability to go up to 4 gig with no additional cost, you must upgrade the MSDE to SQL 2005 express.

The newest 1.3r will now support both MSDE and SQL 2005 express.

Vince, 1024 mb is one gigabyte:

Exact Conversion

1,024 Byte = 1 Kilobyte (KB) 1,024 Kilobyte (KB) = 1 Megabyte (MB) 1,073,741,824 Bytes = 1 Gigabyte (GB) 1 Gigabyte (GB) = 1,024 Megabyte (MB)

root, How do I go about upgarding to SQL 2005 Express? You mention that it's at no cost? Is that correct, I find that hard to believe...everything costs something :)

no, really, it is free.

you will want to go to

and download SQL 2005 Express with Advanced Services. You will also need the .net framework 2.0. There will be a download link there too.One nice thing with this release is it comes with a graphical user interface, management tools, and reporting.. more similar to the full version of SQL 2005. BEFORE installing, follow the instructions in the RMS 1.3r readme file, and read this:

root...the .net framework I downloaded is (Microsoft Component Installer Software Development Kit for Windows (x86) Version 2.0)...making sure this is correct first off? Next I have downloaded (SQL Server 2005 Express Edition with Advanced Services SP1)...anything else I need to download? What are the steps when installing all of this? Must I do it on all the computers? (I'm sure I must :) )...thanks for all the help.

No, you downloaded the SDK. Download the .net framework from here:

56eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en

*I have only tried this in a test non-networked environment.

-You must install the .Net 2.0 framework FIRST. Install the .net framework

2.0 on the computer running the database server. You can install the .Net framework on the other computers if you like. - REBOOT

-Then backup your existing Sore Operations database that is running on MSDE.

-Uninstall MSDE from add/remove programs in the Control Panel. - REBOOT

-Install your new SQL Express Edition with Advanced Services (default instance) - REBOOT

-Launch SQL 2005 Management tool and create an empty database with the same name as the database you backed-up from MSDE. Then, restore your backed up database to the newly created empty database. ( if you are unsure how to do this part, read the SQL 2005 express help file. We are not running SQL 2005 where I am, and I do not have a reference to assist you with. )

***I do not remember if there any settings in SQL 2005 express that need to be "turned on" in the surface configuration in order to work with RMS

That should do it. Try this in a test environment first if you are sceptical..

I think its much easier to restore the database through storeops admin. like you would do for msde, I've done this and it just works like normal. Only other thing I can think of, is remote connections are disabled by default in sql2005. Go into SQL server configuration program and then enable TCP/IP.

Cheers

I would like to try this at home first...how can I get RMS to work again? When I first installed RMS it was basically a test and the licence expired...how can I use it again? Is there a way to do this?

The license is based on the database date. Try it with a new sample database