Installing SQL Express 2012 for LobbyCentral

These instructions will assist you with installing Microsoft SQL Server Express 2012 for use with LobbyCentral. 

Note:  SQL Server 2012 is recommended.

Downloading the Software

You can download SQL Express 2012 directly from Microsoft’s web site or from this URL:  

https://www.microsoft.com/en-us/download/details.aspx?id=29062

Be sure to download the appropriate file for your server.

Installing SQL Express

1. Double-click the installer to start the installation process.
2. In Installation Center, click Installation from the menu on the  left.
3. Click New SQL Server stand-alone installation …
4. After the check-list operation completes, click Install.
5. After the 2nd check-list operation completes, click Next.
6. For installation type, select Perform a new installation of SQL Server 2012.
7. Click Next on the Product Key screen (options are disabled).
8. Read and accept the terms of the license agreement.
9. In Features, check Database Engine Services, click Next.
10. In Instance Configuration, select Default Instance.   Write down the Instance ID.  You will need this when installing LobbyCentral.   
11. Click Next
12. Click Next on Disk Space Requirements.
13. Click Next on Server Configuration.
14. On Database Engine Configuration, choose Mixed-Mode  IMPORTANT!
15. Enter a password for the administrator account.   Write down this password which you will need when installing LobbyCentral.  
16. Click Add Current User.
17. Click Next.
18. Click Next.
19. Click Next on Installation Rules.
20. Finally, click Install.

Information for Installing LobbyCentral

When you install LobbyCentral, you will be prompted for the database Server name and SA Password.

The database server name format is:  <server name>\<instance ID>

For example:  SERVER01\SQLEXPRESS

My servername is SERVER01 and the Instance ID is SQLEXPRESS  from step 10.

The SA Password is the password you created in step 15.