How do I install a Microsoft SQL Server?

  • Download and run the Microsoft SQL Server 2014 Express installer

http://www.microsoft.com/en-us/download/details.aspx?id=42299

  • Choose the “ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe” option assuming you are running on a 64-bit operating system. Otherwise choose the “ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe” file for a 32-bit operating system.
  • Select the “New SQL Server stand-alone installation or add features to an existing installation.” Option.
  • Click the “I Accept the license terms.” Checkbox
  • Keep all of the default features.
    • You can change the “Instance root directory” location if you like. This is where the server be installed to.
    • Make sure the "Management Tools - Complete" checkbox is checked.
  • Choose your Named instance / Instance Id. EZAK is only a suggestion and is not a required name. The named instance will be the name of the Microsoft SQL Server on the machine that you are installing it onto. You will need to know this name when creating a new Microsoft SQL Server Bound Book in EZ Arms Keeper.

Named instance: EZAK

Instance Id: EZAK

For instance in the picture below the machine name is “DEN” and the instance name is “EZAK”

  • Change the “SQL Server Browser” startup type to “Automatic”.

This allows EZ Arms Keeper's “<Browse for more…> option to work as expected as seen below.

If the option is not enabled then EZ Arms Keeper will not be able to auto discover Microsoft SQL Server’s on the network and the information will need to be manually typed in.

  • Change the Authentication Mode to “Mixed Mode (SQL Server authentication and Windows Authentication)

DO NOT FORGET the password you are about to enter for the “sa” account. It is the key to your new database kingdom.

Enter password: ***********

Confirm password: ***********

You can “Specify SQL Server Administrators” if you choose. Just understand that any additional users that you specify can do absolutely anything they want with any database on the server.

  • Select “Install Only” – EZ Arms Keeper doesn’t use reporting services. You can configure it if you like.
  • Click the Close button

Your Microsoft SQL Server is now ready to use with EZ Arms Keeper