Install SQL Server engine

            To setup BaccS in network mode, it is necessary to install database server first. In this article you'll know how to install and setup Microsoft SQL Server database engine. Another option is to rent database in the cloud (for example, Azure or Amazon Web Services). In this case, you will simply get server name, user name and password for your database, which may be specified in the program settings.

            But if you have local network with access from all workstations, an option with installing SQL Server Express will be preferred in most cases (take a note on database file size limit in this section description). Installation process isn't complex, and will require just a few steps.

            First of all, go to the Microsoft website and download SQL Server 2014 Express installation file. Here is a link to download page (works at the moment of writing of this manual):


            Installer file size is just only 196 Mb. When you click Download button on this page, you will be offered to select which package to download. Select the smallest one (Express 64BIT\SQLEXPR_x64_ENU.exe orExpress 32BIT\SQLEXPR_x86_ENU.exe, depending on your platform).

            Run installer, and select New SQL Server stand-alone installation or add features to an existing installation.

            On the Installation type page, select Perform a new installation of SQL Server 2014. If no SQL Server instances are installed on your computer, this step will be automatically skipped.
            On the Feature selection step it is enough to select just Database Engine Services option. You can safely deselect other options.

            On the Instance configuration step specify instance name or leave default (SQLEXPRESS):

            Continue to Database configuration step. Here we must change Authentication type. Instead of Windows authentication mode select Mixed mode and specify password for the instance being created.

            Then click Next and installation process will start. Wait until it finishes and then close installer.

            Done! SQL Server is installed and ready to be used. If you're experienced user and have some knowledge about SQL Server, you can run sqlcmd utility and create empty database (in the desired location). Otherwise, it will be created automatically by BaccS in the next step.

            Updated: 20 Mar 2018 08:44 AM
            Help us to make this article better
            0 0