Installing SQL Server Directly

Please Note: The ROBOTILL Wizard can install SQL Server for you. These instructions are only needed if you decide to install SQL Server yourself.

You can download the latest 'Microsfoft SQL Server Express' install file directly from the Microsoft website.

Select 'Custom Install'

You can select the default media location - just click 'Install'.

Select 'New SQL Server stand-alone installation ...'.

Choose the default selected features and click Next.

Important Step:
Change the Instance Name to 'ROBOTILL' and click on Next.

On the next Server Configuration Screen you can just accept the defaults and click on Next.

Important Step:
On the Database Engine Configuration screen change the Authentication Mode to Mixed Mode.

Type in a password that is at least 8 characters long and contain uppercase and lowercase and at least one number. Make sure to write down and save the password. You will need it later.

Click on Next to complete the install.

Allowing other computers to connect

Add SQL Port

If you will not be adding more computers to your system, you can skip this step and go to ' Setting up the connection and creating the database'.

You need top open port 1433 for SQL Server in Windows Firewall to allow other computers to connect remotely. If you don't know how to do this you can just run the OpenSQLPort file in the ROBOTILL program folder. You need to run it as administrator.

Enable TCP/IP

You also need to enable TCP/IP on the Server.
Go to All Apps > Microsoft SQL Server > 'Sql Server Configuration Manager'.
If you do not have that option under 'Microsoft SQL Server' open the following file directly: C:\Windows\SysWOW64\SQLServerManager12.msc

Expand 'SQL Server Network Configuration' and select 'Protocols for ROBOTILL'.

Right Click on TCP/IP and click on Enable.

Select 'SQL Server Services' and then select 'SQL Server (ROBOTILL)'. Click on the Restart button - or you could just restart the computer.

Setting up the connection and creating the database

Start the ROBOTILL Database Setup Wizard (All Apps > ROBOTILL > ROBOTILL Database Setup).

Click 'Start Setup'. Select Main Computer (Server) and click Next.

On the next screen select 'I have installed SQL Server directly' and click on Next.

Leave the user name as 'sa' and change the Password to the password you used when installing SQL Server.

Click on Next. The Wizard will create the database.