Preparation
|
1.
|
Ensure all Windows updates have been done. If a Windows update has been started but not completed, the installation may not be successful.
|
|
2.
|
Ensure you are signed into the computer as an administrator1. Windows computers can have multiple users and only Windows users which are designated as administrators can perform the installation of this software. An error will occur during installation if you are not signed into Windows with an administrator user.
|
|
3.
|
Ensure the computer meets the minimum requirements, which are:
Windows version: Windows 7, 8, 8.1 and 10, and Windows Server 2008, 2008R22, 2012 and 2012R2. Both 32 and 64 bit versions of Windows are supported. If you are still using Windows Server 2003 or Windows XP on the computer where the database is to be stored, you will need to download the Database3 Manager verison 3.1, which can be found at Earlier Versions Download page.
System Memory: At least 1 GB [GB = Giga bytes or billions of bytes (characters)] (4GB or more is recommended)
Free Disk space: At least 2 GB (20GB or more is recommended)
Internet Access: Required to use the Cloud Account feature. The cloud feature will not operate when computer is disconnected from the internet.
|
1. An administrator in computer terms represents the access level of the user. An administrator generally has the highest level of access and can install software, make changes to the access level of other users and perform other tasks which can affect the operation of the computer. Users without administrator access are generally limited in what changes they can make to the computer.
2. R2 stands means Release 2 and is a designation Microsoft has used for its server products when it has made major changes to the product and it releases it as a new version. When R2 is not part of the name of the server product, Release 1 is implied.
3. A Database is a computer term used to mean a file or files where data is stored in a central location for access by one or more users. A database differs from a document file in that a document generally is only accessible by one user at a time and is organized by pages. A database is generally capable of being accessed by many users at once, with each user being able to read and save information at the same time.
Part 1 – Installing the Database1
There are 2 parts to download and install, so please follow all of the instructions on this page.
|
1.
|
IMPORTANT: If you are upgrading from version 3.0 or 3.1 to 3.5, you must update Management by Statistics on each computer it is installed on. If you have multiple Management by Statistics connecting to the database, make sure you have the time to complete the installation on all the computers needing it before beginning Part 1.
You can upgrade from version 3.2 to version 3.5 without installing the new database. Simply install the 3.5 updates.
Be sure that all Windows updates have been installed and the computer restarted, if necessary, before doing this installation. There are some Windows updates which are required.
If this is not the computer where the database is installed, go to that computer and log in with a Windows user that has administrator rights to that computer, then return to this page to download the update on to the server. You must have administrator rights to install or run the Database Manager. The Database Manager only needs to be installed on one computer.
Download the Database Manager update by clicking the Download button below.
Depending on the browser you use, the installer may run automatically or may be saved in your Downloads folder. Follow the instructions and run the installer to install the Database Manager.
DOWNLOAD – PART 1
Please read all of the instructions on this page before installing part 2.
|
|
2.
|
Complete the installation and the Database Manager will start when you click on the Finish.
You will be asked to create a database. Click No as you already have a database with your data in it. The database just needs to be moved.
|
|
3.
|
Next, select the previous SQL Server, MBSDATAEXPRESS, as shown below.
|
|
4.
|
Go the Database tab and click the Detach Database button. This disconnects your database files from SQL Server and allows us to attach it the new version you just installed.
|
|
5.
|
Copy your database files from their previous location to their new location.
There are two files to copy: MBSData.mdf and MBSData_log.ldf
The new location will be a folder called MSSQL11.MBSEXPRESS2012\DATA. The full folder location is shown in the screen shot below.
|
|
6.
|
Select the MBSEXPRESS2012 Sql Server, as shown below.
Once again answer No when asked to create a new database.
|
|
7.
|
Next you will attach your database to SQL Server by clicking the Attach a Database File button.
Once again answer No when asked to create a new database.
Select the correct file, which will be in a folder called MSSQL11.MBSEXPRESS2012\DATA.
If the database file attaches to SQL Server correctly, the Database Manager will look like the following screen shot. The database is automatically upgraded to include the newest features and the version number will be displayed on this screen.
|
|
8.
|
Next you should set the backup schedule as the old backup schedule is not retained when moving from an earlier version to version 3.2.
|
|
9.
|
At this point you are ready for the Part 2 of the installation.
|
1. A Database is a computer term used to mean a file or files where data is stored in a central location for access by one or more users. A database differs from a document file in that a document generally is only accessible by one user at a time and is organized by pages. A database is generally capable of being accessed by many users at once, with each user being able to read and save information at the same time.
2. SQL stands for Structured Query Language which is a programming language used to query (ask for) information from a database.
Part 2 – Installing the Management by Statistics Software
|
1.
|
Depending on the browser you use, the installer may run automatically or may be saved in your Downloads folder. Just follow the instructions and run the installer to install Management by Statistics.
|
|
2.
|
When you first run the Management by Statistics it will display the Database1 Connections Settings window. Select Windows Integrated Authentication, then click the "Test Connection" button to verify the program is connecting to the database.
|
|
3.
|
Next select Database Authentication, then click the "Test Connection" button to verify the program is connecting to the database.
|
|
4.
|
You will be prompted to enter a user name and password. Enter your user name and password. The default user name is "admin" and the default password is "password". If you are still using the default password, you will be asked to change the password, which you should do. A new password will only be accepted if the password strength meter measures medium or higher. This is for your own protection, particularly if you decide to use the Cloud feature.
|
|
5.
|
Next you will see the Company Setup Wizard.
|
|
6.
|
Click here for instructions to install Management by Statistics on other computers on your network.
|
1. A Database is a computer term used to mean a file or files where data is stored in a central location for access by one or more users. A database differs from a document file in that a document generally is only accessible by one user at a time and is organized by pages. A database is generally capable of being accessed by many users at once, with each user being able to read and save information at the same time.