“Invalid SQL Server version specified in your pro.ini file” Message Appears During Login After Performing Microsoft SQL Express Conversion

  • Created:
  • / Author: tombucci
Issue

 

The following message appears during login:

Invalid SQL Server version specified in your pro.ini file.

Solution or Workaround

Introduction

Sage Pro ERP 2010 now includes support for both Microsoft SQL Server Express 2005 and 2008. The ODBC driver names of both Microsoft SQL Server and Express editions for 2005 and 2008 versions will use the following values for the “SQLMajorVersion” entry in the PRO.INI file instead of “SQLEXPRESS”:

  • “SQL2008” for both SQL Express 2008 and SQL Server 2008
  • “SQL2005” for both SQL Express 2005 and SQL Server 2005

How does this affect Sage Pro ERP 2010?

Performing a conversion to Sage Pro 2010 using SQL Express from a prior version of Sage Pro also using SQL Express will not be successfull. The reason is in versions prior to Sage Pro 2010, the SQLMajorVersion value for a SQL Express 2005 would be “SQLEXPRESS”. This value is no longer valid for Sage Pro 2010 SQL Server database connection process. The following login error appears during the upgrade process after entering the logon information. As a result the database conversion cannot be completed and will display the following:

Invalid SQL Server version specified in your pro.ini file.

Which versions of Microsoft SQL Server will affect Sage Pro 2010 upgrade?

This will occur when converting from any versions of Sage Pro prior to Sage Pro 2010 using SQL Express 2005.

How to perform the upgrade to Sage Pro 2010 from an earlier version using SQL Express 2005?

To perform the upgrade successfully to Sage Pro 2010 using Microsoft SQL Express you will need to edit the SQLMajorVersion value from “SQLEXPRESS” to “SQL2005”  PRO.INI file of the preconverted Sage Pro installation before proceeding to upgrade to Sage Pro 2010 SQLEXPRESS 2005.

Example

Provided below is a sample PRO.INI file from Sage Pro 7.5:

==============================================

[profiles] Available=SQLSERVER
Current=SQLSERVER

[Pro] LoginID=ADMN
BuildNo=3500.00
Product type=Sage Pro 200 ERP
LicensedTo=Sage Pro Customer Support

[profile SQLSERVER] DBMS=SQL Server
ServerName=SAGEPROTEST
SysDatabase=PROSYSB75
Dsn=Sage Pro ERP
SQLMajorVersion=SQLEXPRESS

*Edit the highlighted value to SQLMajorVersion=SQL2005

© Copyright Sage Software

Leave A Comment?