Software Installation

Step 1

Visit the Virtual CloneDrive website and select Download.

Step 2

Navigate to the folder where you downloaded the file. Locate the SetupVCD file and open it.

Step 3

Select I Agree to accept the Virtual CloneDrive License Agreement.

Step 4

Select Next to continue.

Step 5

Select Install.

Step 6

Select Install to add Elaborate Bytes AG storage controllers.

Step 7

When the Virtual CloneDrive installation is complete, you will need to restart your computer.

Step 8

Now you will need to install SQL Management Studio. Navigate to the SQL Server file you downloaded and open it.

Step 9

In the Windows navigation pane, locate BD_ROM Drive (D:) and open it.

Step 10

Open the setup executable file.

Note: You will need administrator priveleges to open this file.

Step 11

In the SQL Installation Center window, click on the Installation tab.

Step 12

Select Install SQL Server Management Tools.

Note: Advanced users may repeat these steps to Install SQL Server Data Tools for more functionality

Step 13

The Download SQL Server Management Studio (SSMS) link will automatically open in your browser. On this page, select the most up to date Download SQL Server Management Studio file. Then open the downloaded file on your computer. It may prompt you to allow the download to open a file on your computer.

Step 14

Select Install to begin the installation. This process may take up to 30 minutes to complete.

Now that you have installed SQL Server Management Studio, proceed to Create Server Instance.

Step 1

Locate the SQL Server file you downloaded.

Step 2

Right-click the SQL Server file and select Mount from the menu.

Step 3

Your DVD Drive will open. Open the setup executable file.

Note: You will need administrator priveleges to open this file.

Step 4

In the SQL Installation Center window, click on the Installation tab.

Step 5

Select Install SQL Server Management Tools.

Note: Advanced users may repeat these steps to Install SQL Server Data Tools for more functionality

Step 6

The Download SQL Server Management Studio (SSMS) link will automatically open in your browser. On this page, select the most up to date Download SQL Server Management Studio file. Then open the downloaded file on your computer. It may prompt you to allow the download to open a file on your computer.

Step 1

Return to the SQL Installation Center window. Then click on the Installation tab.

Step 2

Select New SQL Server stand-alone installation or add features to existing installation. It may take a few moments for the set-up software to process.

Step 3

You will be prompted to enter a Product key. Instead, check the bullet for "Specify a free edition" and set the drop down to "Developer". Then click Next >.

Step 4

Note: You may be prompted to do a Microsoft Update before the next sections. If so, please complete the prompts on the screen. This step will not appear if you have Microsoft up to date prior to installation.

1. The installation will automatically check for Global Rules and move forward.
2. Then it will complete Product Updates. Select Next when it is complete.
3. It wil automatically complete Install Setup Files and move forward.
4. Then it will prompt to Install Rules. Select Next to install these rules.

Note: Windows Firewall will give a warning if your computer has a firewall installed. This is normal.

Step 5

In Feature Selection, select Database Engine Services, then select Next.

Step 6

Name your instance 'LASTNAMECLASSNUMBER'. For example, 'DOEMMIS503'. You cannot have spaces in the name. It will automatically populate an Instance ID and a SQL Server directory for you.

Select Next.

Note: Any additional SQL Server instances you have on the computer will appear in the installed instances box.

Step 7

Make sure the Server Configuration shows the new instance as Automatic and select Next.

Step 8

1. You will be prompted to allow access via a password or Windows authentication. Your options are:
• Windows Authentication Mode: It will allows you to access it automatically if you are already authenticated.
• Mixed Mode: This is a mix of using Windows authentication mode and having an additional secure password that must be inputted before accessing server.
2. Then click Add Current User to add the current login credentials you are using as a Specific SQL Server Admin. It will add in the following format:
   COMPUTERNAME/USERID (USERID)

Select Next when complete.

Step 9

1. The installation will automatically complete Feature Configuration Rules.
2. You will be prompted to review the settings in Ready to Install. Select Install when you have reviewed the details.
3. The installation will happen automatially and will display a completed screen when it is finished.

Step 10

Now that you have the SQL stand-alone server instance on your computer, you need to connect to it using the Server Management Studio. Proceed to Connect to SQL Server.

Step 1

To find and open SQL Server on your computer:

1. Select the Start button.
2. Type "Microsoft SQL Server Management" in the search box.
3. Select the Microsoft SQL Server Management Studio app.

Step 2

The instance you created will not appear in the Server name option immediately. However, if you have other instances already installed on your computer, they will appear here. Do not connect to these instances.

Open the drop down and select Browse for more...

Step 3

Under Database Engine, select the instance you created and select OK.

Step 4

Depending on your authentication setup in previous steps, provide any necessary passwords for the instance. Then select Connect.