I have a client that is running HQ RMS 1.3 with the full version of SQL2000 Workgroups. He wants to install RMS 2.0, but 2.0 uses SQL 2005 Express and he is already over the 4 gig limit on the HQ database. How can you use existing SQL2000 database with RMS 2.0? Does he have to buy the full version of SQL2005?
Thanks Dave
I'm running SBS 2K3 (with SQL 2000) on my server and SQL 2K5E on the workstations. No problems at all.
Tom
You're probably using the SQL 2005 as the database. I've tried skipping the SQL 2005 Express during the RMS 2.0 installation process and keeping the SQL
2000 full workgroup versi> I'm running SBS 2K3 (with SQL 2000) on my server and SQL 2K5E on the
First Make a backup of customer database...
Open SO Administrator Connect to SQL 2000 instance, open your database and on database menu select property..
You can upgrade your 1.3 DB to 2.0 db, and after try to open with SO Manager
I'm creating on my pc a VM with sql 2000 and sql 2005 to try rms 1.3 and rms 2.0 databases in different versions.. I have problems with a customer database today!
cod
The upgrade is for the RMS database. Not the server you are running it on. Doesn't matter what server version you are running, you still need to upgrade your database to 2.0 for RMS 2.0 to run on it. Craig
I assure you that my systems are configured precisely as I described.
As others have stated, upgrading the RMS DB has nothing to do with which SQL Server you are running.
I am certain that you could have the database on a server running SQL Server
2000 and have clients running a mix of SQL 2K5E and MSDE and still have everything work out just fine. The database engine has nothing to do with the database version.RMS 2.0 does not require SQL 2005 (Express or otherwise).
Tom
"DCR" wrote:
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.