In order to specify an alternate SA account initial password, SQL Express must be
installed separately from ProMax. If the SQL instance is installed with the setup.exe
application, the default BryanRes1 password will be set in the SQL instance.
SQL Express Installation
To install SQL express, obtain the install package from the ProMax DVD in the
ISSetupPrerequisites
folder, or from the Microsoft® download site,
http://download.microsoft.com. ProMax is compatible with
SQL Express 2005, 2008, and 2008 R2. If downloading from Microsoft, you should
get the latest service pack release of the software. All x86 versions of ProMax
should be installed with an x86 version of SQL Express regardless of the
operating system architecture. (ProMax 4.0 allows 32-bit SQL with 64-bit ProMax or 64-bit SQL with 32-bit ProMax).
To install SQL Express 2005 (SP4 recommended), use the following command line:
SQLEXPR.exe /qb ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity
INSTANCENAME=BRYANRES SECURITYMODE=SQL SAPWD=BryanRes1 DISABLENETWORKPROTOCOLS=1 ENABLERANU=0
To install SQL Express 2008 (SP3 recommended), use the following command line:
SQLEXPR_x86_ENU.exe /QS /ACTION=Install /FEATURES=SQLEngine,Conn /INSTANCENAME=BRYANRES /SECURITYMODE=SQL /SAPWD=BryanRes1
/SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSYSADMINACCOUNTS="NT AUTHORITY\Network Service" /ENABLERANU=0
To install SQL Express 2008 R2 (SP2 recommended), use the following command line:
SQLEXPR_x86_ENU.exe /QS /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS=1 /FEATURES=SQLEngine,Conn /INSTANCENAME=BRYANRES
/SECURITYMODE=SQL /SAPWD=BryanRes1 /SQLSVCACCOUNT="NT AUTHORITY\Network Service"
/SQLSYSADMINACCOUNTS="NT AUTHORITY\Network Service" /ENABLERANU=0
To install SQL Express 2012 (SP1 recommended), use the following command line
(SQL Express 2012 is only compatible with ProMax 3.2.13116 and later):
SQLEXPR_x86_ENU.exe /QS /HIDECONSOLE /UPDATEENABLED=FALSE /SkipRules=RebootRequiredCheck
/ACTION=Install /IACCEPTSQLSERVERLICENSETERMS=1 /FEATURES=SQLEngine,Conn /INSTANCENAME=BRYANRES
/SECURITYMODE=SQL /SAPWD=BryanRes1 /ENABLERANU=0
To install SQL Express 2014, use the following command line
(Note that the SQLEXPR_x86_ENU.exe has been replaced by SETUP.exe since extraction is performed separately from installation):
SETUP.exe /QS /HIDECONSOLE /UPDATEENABLED=FALSE
/SkipRules=RebootRequiredCheck /ACTION=Install
/IACCEPTSQLSERVERLICENSETERMS=1 /FEATURES=SQLEngine,Conn
/INSTANCENAME=BRYANRES /SECURITYMODE=SQL /SAPWD=BryanRes1 /ENABLERANU=0
In the above commands, you should replace the BryanRes1 value for the SAPWD parameter
with the password required by your specific requirements. Additionally, you should
select the language of SQL Express that is appropriate for your locale based on
recommendations by Microsoft®. In the above examples, ENU stands for English.
The SQL Express instance can be installed using the GUI rather than the command
line if desired. The GUI is invoked by simply double clicking the installation
package in Windows Explorer. However, if the GUI is selected, you must be certain
that the options selected in the installation process match those specified in the
command lines above. For further assistance on SQL installation, please contact
our support group.
ProMax Installation
Once SQL Express is installed with the required password, ProMax must be installed.
The ProMax installation package contains a public Windows Installer property called
SAPWD
. The alternate password is specified through this public property.
To install ProMax using the setup.exe
program on the DVD, issue the
following command (replacing the password with your password):
d:\setup.exe /V"SAPWD=BryanRes1"
assuming the installer is present in drive D:
. This command does not
install SQL Express with the indicated password. It only indicates to the ProMax installer
what the SA password is for SQL Express. If you do not first install SQL Express
with one of the above methods, the ProMax installation will fail due to an
unexpected password.
If all prerequisite software has been installed, you can install ProMax directly
from the Windows Installer database (msi). To install from the MSI file, use the
following command (again replacing the password with your value):
msiexec /i d:\ProMax.msi SAPWD=BryanRes1
The above command assumes the ProMax database file is on drive D:
.
Other more complicated installation scenarios are possible depending on your requirement
and environment. If the installation package is installed through
Active Directory Group Policy Objects (GPO) or some other similar technique, a
Windows Installer transform may need to be created to set this property. Please
contact our support group if you need assistance in these environments.
First, try rebooting the system, even if you have just rebooted (common Windows Updates can cause a need for a second reboot). If the error persists after reboot:
If you have a Lenovo computer with RapidBoot enabled, please uninstall RapidBoot from the ProgramFiles\Lenovo\RapidBoot
folder and running the uninstall executable. After uninstalling Rapidboot, uninstall ProMax and the BRYANRES SQL Express instance, reboot,
and reinstall ProMax.
If you are running ProMax 3.2 or earlier, you may try the following. Do not follow these steps for ProMax 4.0.
-
Run Services.msc (type
services.msc
in the Search box in Windows).
-
Find SQL Server (BRYANRES) in the list and right-click, select Stop from the menu.
-
Get a new
secservr.exe
file from here.
-
In the Services (step 2) right-click on SQL Server (BRYANRES) and select Properties. In the dialog, look at the
Path to executable: which is where the file will be located, usually something like:
C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\secservr.exe
(You may need to supply admin password to access this location).
- Replace secservr.exe with the one you obtained in item 3.
- In the Services, right-click on SQL Server (BRYANRES) and select Start from the menu.
- Try ProMax again.
If you have ProMax 4.0, or if the above steps did not correct the issue for ProMax 3.2, please uninstall ProMax and the BRYANRES SQL Express Instance. Reboot, and reinstall ProMax.