¶ Warning Message
When installing Office Medic on a Windows 11 PC that is up to date, the following warning message may appear on the screen at the stage where the Microsoft SQL instance is installed:
Title: Program Compatibility Assistant
This app may not work correctly
SQL Server Installer
Microsoft
This app requires Powershell 2.0, which has been deprecated.
Click "Learn More" to download the Powershell 2.0 replacement scripts from Microsoft.
The Learn More links to a Microsoft article about the removal of Powershell 2.0 from Windows as follows:
¶ Solution
Install a newer version of Microsoft SQL Server in place of the older version included with Office Medic. The following steps will guide you through the process:
1. Download and run Microsoft® SQL Server® 2019 Express (SQL2019-SSEI-Expr.exe) from https://www.microsoft.com/en-us/download/details.aspx?id=101064
2. Choose Custom
3. Choose a temporary location to unpack the SQL 2019 Express install media then click Install
4. A new window will appear; click on New SQL Server Stand-alone Installation
5. Tick I accept the license terms and Privacy Statement and click Next
6. Tick Use Microsoft Update to check for updates (recommended) then click Next
7. Once the Install Rules have passed, click Next; if there are any failed rules, this will need to be resolved before installation can be completed
8. Ensure that Database Engine Services is ticked, the remainder of items in the Instance Features section are unticked, leaving all items untouched in the Shared Features section as they are, then click Next
9. Click the dot next to Named instance and enter OFFICEMEDIC
Then click Next
10. On the Server Configuration window click Next
11. On the Database Engine Configuration window, click the dot next to Mixed Mode, then enter the sa password required for your version of Office Medic in both fields, then click Next
For Office Medic 6.x:
For Office Medic 5.x:
The installation will then proceed:
12. Once the installation is completed, click the Close button
13. Now close the SQL Server Installation Center window with the X
14. Run the installation of Office Medic choosing Local Database and International (Office Medic 6.x) / Europe (Office Medic 5.x)
15. Depending on your version of Office Medic, please do one of the following things:
Office Medic 6.x:
Open a UAC elevated command prompt window then run the following command to attach the database to the new instance:
sqlcmd -S localhost\OFFICEMEDIC -E -Q "CREATE DATABASE VectraplexECG ON (FILENAME = 'C:\Vectraplex\Database\VectraplexECG.mdf'), (FILENAME = 'C:\Vectraplex\Database\VectraplexECG_log.ldf') FOR ATTACH;"
Office Medic 5.x:
Run the Office Medic program UAC elevated as a once-off; this should create/attach the database files to the new instance automatically.
Now everything should work as expected!
Need Help?
LEMR customers can get help by contacting LEMR Support.