Note: If necessary, review Microsoft SQL Server documentation.

Having the full version of Microsoft SQL Server requires someone at your company to have some knowledge in implementing and managing SQL Server. You will be required to create your SQL Server instance used for MyAssistant.

Use the pointers below as your guideline when creating your SQL Server instance:

• The default SQL Server instance name is ISD, but you may call it what you wish. You can use an existing instance, as long as it meets the rest of the criteria for the MyAssistant database. Pre-existing Instances can be used such as the Defualt SQL Instance, if the instance is unnamed leave the instance name blank when configurating MyAssistant Database.
• The SQL Server instance must be in mixed mode authentication. (When logging into SQL Management Studio, use Windows authentication)
• The TCP/IP protocol must be enabled and assigned a fixed port. This port must be open on any firewall. The default port used by MyAssistant is 45812.
• Ensure that the Shared Memory protocol is enabled for the instance that will contain the MyAssistant Notification database. Notification is the name of the SQL database that MyAssistant creates.
• MyAssistant will attempt to create a SQL user called MyAssistant using Windows Authentication and thus requires you to have appropriate Windows permissions on the SQL Server box (i.e. to be logged in as an administrator). If this were to fail, you will need to manually create a SQL user with sysadmin level role permissions.

After creating your SQL instance, perform the following MyAssistant steps:

1. Begin the MyAssistant installation by clicking autorun.hta. Choose the Server Setup install option.
2. During the Install Prerequisites of the Server Setup, check the box Do not install SQL Server Express.
3. Click Next.
4. Click Next to install MyAssistant.
5. Click Finish.
6. Click Yes to run the MyAssistant Configuration Manager.
7. Check the box for Show Advanced Options.
8. Click Next.
9. Enter your Customer Number and Server Product Key, define Web Proxy server information if applicable, then click Activate to complete the Product Activation.
10. Click Next.
11. In the MyAssistant Database Connection window:
    1. Enter the Server Name of the SQL server.
    2. The MyAssistant installation automatically creates a SQL user called MyAssistant, with a prefilled password. Do not change this login or password unless you know why you are changing it. If you change these two values, you will need to know them for future use on the server and workstations.
    3. Enter the SQL Server instance name that will be used to store the Notification database. The default SQL instance name is ISD, unless you've chosen a different name.
       Note: The SQL instance must already exist (and should have been created in the very first step noted above even before attempting to install MyAssistant).
    4. Change the Port Number to the value that your SQL server is configured for. The default port is 45812, If you have changed this port, you will need to type the correct port. To review port assigned to your instance check your client TCP/IP protocal properties in SQL Server Configuration Manager.
12. Click Next. MyAssistant will create the SQL user and the Notification database. This SQL Server database name cannot be changed and must be called Notification for MyAssistant to function properly.
13. Complete the subsequent steps to complete the configuration wizard and Exit the installation.