See attached PDF for steps to install Microsoft SQL manually.

Note: If necessary, review Microsoft SQL Server documentation.

SQL install:

1. Confirm that you are logged on as a Windows user with Administrative privileges.
2. Browse to the location of your MyAssistant Installation files.
   Note: MyAssistant installation media includes a compatible version of the SQL Server Express installation media. Other installation media can be used or obtained from Microsoft, please consult the “MyAssistant Hardware and Software compatibility” file in the installation documentation for compatibility.
3. Double click on the appropriate installation file.
   • If you are on a 32 bit machine you will use SQLEXPR_x86
   • If you are on a 64 bit machine you will use SQLEXPR_x64

From the SQL Server Installation Center

1. Open the Installation section on the left side of the screen.
2. Click [New Installation or add features to an existing installation].

SQL Server Setup:

SQL Server installations steps may vary depending on the version of SQL Server being installed. The steps below can be used to determine the correct options for setting up a MyAssistant SQL Server and Database.

• Installation Type:
  • For MyAssistant purposes, select the “New...” option to install a new named instance of the SQL Server engine.
• Feature Selection:
  • MyAssistant only requires the “Database Engine Services” installed.
  • Instance Root Directory, Accept or modify the location where this instance will be stored.
• Instance Configuration:
  • Select Named Instance. Name the Instance “ISD”
    Note: Use Named Instances for SQL Express for optimize performance.
    Note: MyAssistant installation wizard uses the Instance name ISD. Using a different instance name here will require manual entry on the workstations to connect to your instance.
• Server Configuration:
  • Service Account:
    • Account Name: NT AUTHORITY\NETWORK
    • Startup Type: Automatic.
  • Collation:
    • Default Collation of “SQL_Latin1_General_CP1_CI_AS” is correct. Do Not Change the Collation.
• Database Engine Configuration:
  • Server configuration:
    • Authentication Mode: Mixed Mode
    • When installing SQL Server using Mixed Mode authentication, a SQL Server user titled SA is automatically created. You need to enter a password for this SQL user that meets your Windows polices.
    • Under Specify SQL Server Administrators, Add any Applicable User Groups or Users for the users who will Manage MyAssistant Tasks, Services, and Updates.
  • Data Directories, TempDB, User Instances, FILESTREAM:
    • Use Defaults, these settings do not need to be changed for MyAssistant to function correctly.

Enabling TCP/IP :
Note:Setting below assume instance name is ISD.

1. From Windows select Start > All Programs > Microsoft SQL Server [Version Number]> Configuration Tools > SQL Server Configuration Manager. This will open the SQL Server Configuration Manager window.
2. Expand the SQL Server Network Configuration menu.
3. Protocols for ISD will appear under SQL Server Network Configuration on the left side of the screen.
4. Click Protocols for ISD to display the following options in the right hand screen.
5. Right click on TCP/IP and select Enable.
6. Right click on TCP/IP again and select Properties.
7. In the TCP/IP Properties window, click on the IP Addresses tab.
8. Scroll to the bottom of the window until you see IPAll.
9. Change/ add the following number in the column beside TCP Port: 45812
   Note: This is the port for the MyAssistant Database, default configuration of MyAssistant uses this port number, changing this port will require manual entry when setting up workstations.
10. Make sure the TCP Dynamic Ports number is BLANK.
11. Click OK to close the TCP/IP Properties window.
    Note:You may receive a message informing you that the changes will not take effect until the SQL Server services is restarted.
12. Click on SQL Server Services on the left side of the screen (the tree menu). This will display a list of Windows Services associated with the SQL Server engine.
13. Right click on the Service named SQL SERVER (ISD) and select Restart.
14. When the service restarts, close the SQL Server Configuration Manager.