Summary
"Parallel Migration Wizard - InstallShield Wizard: Error execute: Select ServerProperty('ProductVersion') As ProductVersion" message followed by:
"SQL Server version are not compatible, Migration Wizard cannot continue" when migrating in Sage 100 Premium
"SQL Server version are not compatible"
Description
Use the link below to confirm SQL Version. You can find the build number by going to Help, About SQL Server.
http://sqlserverbuilds.blogspot.com/
Cause
- The Source and Target SQL Instance (Database) are not the same version
NOTE: In most cases the Source SQL Instance is a higher build - Selecting (Local\SQL instance) rather than (Server\SQL instance) when prompted for SQL instance (possibly also related to running Migration.exe vs Migrate.exe in the \MAS90\Migration\ folder and choosing Local server)
- Wrong password for the SA user (SQL) was entered in Migration information screen(s).
Resolution


- Check the Version of both SQL Instances using the steps belwo
- Log into the Source and Target SQL Instance using Micrsoft SQL Server Managment Studio
- In the Object Explorer section view the SQL Build Number for each SQL Instance
- Update the Target Instance, if the Source Instance is a higher version (See Addtional Information section below, for links to SQL Service Packs)
- If you're migrating from one server to another and using the same base version of SQL Server (e.g. SQL Server 2008 is installed on both servers), verify that both versions are on the same Service Pack.
- Add Inbound Firewall Rule for Source and Target SQL Instances (see Article: How to configure Windows Firewall for Sage 100 Advanced and Premium (video) )
DocLink: Supported Platform Matrices (SPM) for Sage 100; System requirements and specifications