80
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"
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.
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.
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'
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.
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.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
