Steps to install SQL Server 2017

First, you need to create a student account on:

http://www.portal.azure.com/

If you do not already have an account, you need to create one. MS will send a confirmation link on

you CSU email to complete account creation. Once the account is created, follow the steps below:

1. In the box on top, where it says, "Search resources, services and docs", type

"Education".

2. Select "Education (preview)" from the list.

3. Select "Software" from the list in the upper left corner.

4. You should now be able to select from a variety of software, including Windows 10,

Windows Server, Visio, Visual Studio, SQL Server, Project, Access, etc.

5. Select SQL Server 2017 Developer:

6. Click Download.

7. RMB and click Mount

8. On the setup.exe, RMB and run as administrator on the downloaded file.

9. You will see this window:

Select installation option from left side

Select new sql server stand-alone installation

If you downloaded the SQL server from Microsoft it will automatically take product key

Click next and click next again on ‘installation type’ page

Accept the License T&C

You can create a named instance. I rather choose default instance. Go to Instance configuration:

Go next up to server feature selection screen:

Select the features as shown. Go to server configuration. Change account name to you

system(laptop) login account user name using Browse option under username column:

Go to Database engine configuration:

When you add analysis services (required for graduate level courses), specify the admin and server

mode as multidimensional and data mining mode. Next to install all the installation configuration

and finish setup.

Next, let’s install SQL Server Management Studio (SSMS)

Install SQL Server Management Studio (SSMS):

Below page will open in your browser when you search SQL Server Management Studio and click the

1st link:

When you click on ‘Download SQL Server Management Studio 18.2’ link, exe file will be downloaded.

RMB on the file and run as administrator

Once the installation is complete, system will restart. After restarting the system, open SQL Server

Management Studio from start menu options.

Fill in the server details on the SQL Server Management Studio:

RMB on Server name and create new database:

Give it any name:

Let us test these steps by creating a new table and inserting a record into it. RMB on new DB and

select ‘New Query’

A new query window will open. Type the following command in it:

create table test1 (name1 varchar(50))

select this command and click execute.

Then, type

insert into test1 values ('Success')

select this command and click execute.

RMB on the DB name and click refresh. You should get the below screen:

Now let’s query the table and see if we have the new data available:

RMB on dbo.test1 and choose ‘Select top 1000 rows’ or type the following in the query box:

SELECT TOP (1000) [name1] FROM [CIS430].[dbo].[test1]

OR

SELECT * FROM test1

You’re all set to attempt Lab 1 now!