Regular Installation and Upgrade

Overview

  • Application installation, application upgrade, and database installation packages are combined into a single installer. 
  • The application installer handles both 32 and 64 bit O/S, installing the appropriate pre-required software, such as: MSI, .NET Frameworks, and XML parsers. 
  • The MVE installation package has a web-deploy and single file format. 
    • Web-Deploy: Small install package without any pre-requisite software bundled into the installer. The installer will download the needed software from the MVE web server as needed. This includes the Microsoft SQL Server Express 2008
      • Filename: MVE_Application.exe - ~67.9 MB
    • Single-File: Larger install package with all pre-requisite software bundled into a single executable. The installer contains all pre-requisite software for both 32 and 64 bit operating systems as well as the Microsoft SQL Server Express 2008
      • Filename: MVE_Application_Full.exe - ~1.83GB
  • The MVE installation package comes bundled with the 32-bit and 64-bit version of Microsoft SQL Server, 2008 edition including SQL Engine, Reporting Services and SQL Server Management Studio.


MVE Application Installer

·    Opening the My Vision Express Application Installer will prompt the user with the "Type of installation" dialog screen. The user may select one of two options:
 

  • Client / Upgrade Install : This option will install / upgrade the My Vision Express application, and not install a database nor SQL Server. 
  • Full Install :  This option is preferred to first time users for My Vision Express. It will install the the MVE application as well as the MVE Database.  


·    Selecting the 'Full Install' will prompt the user with "Type of Database installation" dialog window.

 This window allows the user to select between the 'Simple' and 'Advanced User' install choices.

  •  Simple Install : For the simple choice, the Microsoft SQL Express 2008 will be installed on the local machine. The installer will create a <localhost>\MVE_INSTANCE SQL instance if one does not exist on the local computer. The My Vision Express databases will be installed in the program folder and attached to a default 'myvisionexpress' database.

  • Advanced User Install :  For the advanced user choice, the user is assumed to have knowledge on how to create, attach and setup the My Vision Express database. The installer will simply install the necessary files required for the MVE database and extract the Microsoft SQL Express 2008 installer package in the recommended program folder. 



·    After the installation options have been selected, the installer will check the local system for all the necessary prerequisite software packages and for a previous installation of My Vision Express. The "Confirm system updates" dialog will now appear listing all the required software that will be needed for the rest of the installation as well as for the use of the My Vision Express application and/or database.


·    The web-deploy version of the installer will download and install all the necessary system updates.


·    For the "Full Install" users, the 'SQL Check' dialog which will scan the local machine for any SQL instance with the name 'MVE_INSTANCE'. In the event that there exists a My Vision Express SQL instance, the user will be asked to add a new database to that particular instance. If not, a 'MVE_INSTANCE' will be installed with the SQL server.




·    After the system has been updated with all the necessary software, the user will be prompted with the "My Visiopn Express" (current version) installation wizard.


·    Clicking 'Next' will lead to the prerequisite software check/install dialog screen. Once the installer verifies all the necessary software has been installed, the user will be prompted with the "End-User-License Agreement" 


·    Accepting the License Agreement and clicking 'Next' will prompt the 'Select destination folder' dialog. The user will select the parent directory where 'My Vision Express' software folder will be installed.  


·    Clicking 'Next' will lead the user to the 'Ready to Install' dialog. Once the user is ready for the My Vision Express install, the progress dialog will indicate the different stages of the software installation.

·    For the "Full Install" users,  the installer will install the database files and create the default 'myvisionexpress' database. If the user is prompted to add a database to an existing SQL instance, the 'Add a New Database' dialog will open and ask for a new database name.


·    Once the installer has finished installing the necessary files and registering the appropriate libraries/assemblies, the 'Finished' dialog will be prompted. On a successful install, the user will have the option to directly open the My Vision Express program by clicking the 'Run My Vision Express now' radial button.

 
 

Troubleshoot : 


Application installation :

Common solutions:

·         Restart OS

·         Update OS

Windows 7

·         Installation should have no issues

Windows Vista

·         Installation should have no issues

Windows XP

·         Needed all pre-req and needed updates
·         After updates software installs without any issues

Windows Server 2008 and 2003
·         Make sure the user has administrative rights

 

 

"Full Install" : SQL Database installation 

Common solutions:

·      Restart OS
·         Update OS
·         Open the SQL installation summary file located in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log. This file will specify the error and the recommended actions to solve the issue. 

Windows 7
·         Installation should have no issues

Windows Server 2008
·         Set the Account Policy --> Password Policy -->>Policy: "Password must meet complexity requirements" to 'Disabled'
·         Server 2008 has a built in 3.0 and 3.5 framework that will need to be updated directly from the OS if an error in installing the SQL server is detected
·         Make sure the user has administrative rights
·         Worst Scenario: the .NET framework machine.config file must be reverted to the default file under C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG    machine.config.default


Windows Vista
·         Some cases: Needs Powershell 1.0 


Windows Server 2003
·         Set the Account Policy --> Password Policy -->>Policy: "Password must meet complexity requirements" to 'Disabled'
·         Needs Powershell 1.0
·         Make sure the user has administrative rights
·         Worst Scenario: the .NET framework machine.config file must be reverted to the default file under C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG    machine.config.default 


Windows XP
·         Needs all pre-requisites

·       In a few cases, window 4.5 installer will have to be installed manually

·         After updates software should install without issues

 

SQL Database Attachment 

·         Restart OS
·         Verify login of myvisionexpress is setup up in the master database
·         Verify the myvisionexpress database has been attanched correctly
·         Verify ownership of the database is set to login user: myvisionexpress


SQL Code for Attaching MVE Database

The location of the MDF and LDF Database files may be different depending on the location of the installation directory.

Begin script: 
>>>>>>>>>>>>>>>>>>

USE [master]
GO

CREATE LOGIN [myvisionexpress] WITH PASSWORD=N'<MVE Password>', CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

EXEC sp_attach_db @dbname = 'myvisionexpress',
     @filename1 = 'C:\Program Files (x86)\My Vision Express\database\myvisionexpress_Data.MDF',
     @filename2 = 'C:\Program Files (x86)\My Vision Express\database\myvisionexpress_log.LDF'
GO

USE  [myvisionexpress]
GO

EXEC sp_addlogin 'myvisionexpress', '<MVE Password>', 'myvisionexpress'

GO

EXEC sp_changedbowner 'myvisionexpress'

GO

EXEC sp_grantdbaccess 'myvisionexpress' 

GO

EXEC sp_addrolemember N'db_owner', N'myvisionexpress'

GO

<<<<<<<<<<<
End Script

Comments