Small and medium business | Business Central, N...

Runtime Error: Class not Registered in RMS Administrator

(0) Share

Report

Posted on by seminolebs

I have updated the SQL Server Express 2005 to 2014. Both the POS and MANAGER both work fine on Server and Client. But now I can not open the Store Administrator on the Server.

The response is 'Runtime Error: Class Not Registered -2147221164 (80040154). Tried uninstalling RMS and reinstalling but get the same problem. The client computer Configuration Test Database is OK, but Connect to Database responds "Failed to connect to database RMSDATA"

I have the same question (0)

All responses (6)

Answers (0)

Kevin Antosh 1,649 on at

Like (0)

Report
Copy link

Link copied!

Hi! We had that happen and the tech "Ran a registerdllSO.bat" to fix the issue. I don't have any more details so proceed with caution if you try it. Be sure to make a backup of everything before trying this and/or contact a RMS support tech for assistance.

Was this reply helpful? Yes No
ToddB Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi seminolebs,

Are you able to Connect to SQL, within Store Operations Administrator, on other computers connected to the same database?

______________________________________________

Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:

https://community.dynamics.com/rms/b/rmssupport/archive/2015/10/22/microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016

Dynamics Retail Management System 2.0 - Microsoft Lifecycle | Microsoft Docs

This is less than 30 days from now; and you can continue using RMS after this date, but technical support will not be available.

I would recommend checking with your partner regarding what they may recommend as a replacement system after the extended support end date.

Was this reply helpful? Yes No
seminolebs 80 on at

Like (0)

Report
Copy link

Link copied!

I can not connect to the database on either computer through the RMS Store Administrator.

The server computer gives the 'Class Not Registered' error and Store Administrator drops.

The Client computer will open the Administrator and I can TEST DATABASE only. It "Fails to connect to Database'

Was this reply helpful? Yes No
ToddB Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi seminolebs,

If you need assistance with this issue I would suggest you open an incident with Microsoft.

Was this reply helpful? Yes No
seminolebs 80 on at

Like (0)

Report
Copy link

Link copied!

Let me update the full scenario. Originally installed RMS 2.0 and everything was fine. Recently upgraded SQL Server 2005 Express to 2014 Express. All was still fine until Office 365 was uninstalled. The 'Class not registered' error began.

I tried to uninstall and re-install RMS but SQL Server 2005 Express is blocked by the the instance MSSQLSERVER already exists.

Now neither this computer gets the 'Class not Registered' error, and the other computer gets the error 'failed to connect to server servername'

Please advise if a complete remove of SQL Server Express 2008, 2014 and the MSSQLSERVER instance is required.

Was this reply helpful? Yes No
Suggested answer

seminolebs 80 on at

Like (0)

Report
Copy link

Link copied!

The solution to this issue was provided by New West Technologies. The upgrade to SQL Server 2008 Express and SQL Server 2014 Express requires 2005 backward compatibility. They provided 2 links which downloaded either the x86 or the x64 version of 2005BC

Thanks for the help.

Was this reply helpful? Yes No