DO I NEED A SANDBOX?

To run TimeXtender and complete this training you need a set of target data storage components.

To learn how to build a sandbox environment by configuring the free SQL Server developer edition on an existing windows machine, continue with this module.

However, if you already have the necessary data storage resources available, you may skip this module. If you are interested in building a more production-ready architecture, one of the below reference architectures may work for you:

Azure SQL Database

​​

On-Prem SQL Server

​​

Azure Synapse Dedicated SQL Pool

​​

START ON YOUR WINDOWS MACHINE

You can configure a Sandbox on nearly any existing windows machine. Either physical or virtual with windows personal or server OS editions.

You'll want to have at least the following minimum specs:

• CPU: 2.0 GHz
• RAM: 4 GB
• Storage: 15 GB of available disk space

DOWNLOAD SQL SERVER

1. Go to SQL Server Downloads
2. Scroll down to Developer edition
3. Click Download now
4. Run the Installer

UNPACK SQL INSTALLER

1. Run the SQL Server Installation
2. Click Custom
3. Click Install

SELECT NEW STAND-ALONE SQL INSTANCE

1. SQL Server Installation Center will open
2. Click Installation
3. Click New SQL Server stand-alone Installation
4. Click Next

SELECT SQL SERVER FEATURES

1. Under Feature Selection
   1. Select Database Engine Services
   2. Select Analysis Services
   3. Click Next

DATABASE CONFIGURATION

1. Under Instance Configuration section
   1. Select Default Instance
   2. Click Next
2. Under Database Engine Configuration
   1. Select Mixed Mode
   2. Create a Password
   3. Note down the user name (sa) and password for later use
   4. Click Add Current User
   5. Click Next
3. Click Next

SSAS CONFIGURATION

1. Under Analysis Services Configuration
   1. Select Tabular Mode
   2. Click Add Current User
   3. Click Next
2. Ready to Install
   1. Click Install

INSTALL MANAGEMENT STUDIO

1. Go To SQL Server Management Studio Download Page
2. Click Free Download SQL Server Management Studio
3. Run the Installer
4. Click Install
5. Restart Computer

LOG-IN TO MANAGEMENT STUDIO

1. Launch Management Studio
2. Select SQL Server Authentication
3. Type the User Name (sa) and Password you created during the SQL Server installation.
4. Click Connect

Congratulations! You've completed the training module

CREATE A SANDBOX

Return to the Course Overview to continue with your training.