Print this article Edit this article

Connecting to IIS for CGT 456 Class

Use the following instructions to connect to your CGT456 IIS web sites and space:

To access the servers file storage for IIS for your class website you will need to map a network drive to the following path:
 
\\ecniisdev.ecn.purdue.edu\cgt456 OR \\ecn-classiis.ecn.purdue.edu\cgt456
Note that you can also map a drive directly to your individual webpage by using the path:
\\ecniisdev.ecn.purdue.edu\cgt456\username OR \\ecn-classiis.ecn.purdue.edu\cgt456\username
 
When you connect to this drive you will only see the folders that you have access to (which will generally be only your own folder).
 
You will need to be on the Purdue network OR be on the VPN to connect to the servers file share the instructions for how to map a network drive on Windows are located here:                  https://eng.purdue.edu/jump/b3761d
Instructions for mapping a network drive on Mac OS are here:                  http://eng.purdue.edu/jump/1a343
 
You will map the drive with your existing BoilerAD domain username and password (the password will be the same as your career account password).
Your login information will be 'Use another account' and then 'BoilerAD\username'
 
Your individual website URL for the CGT456 class is:
https://cgtweb2.tech.purdue.edu/courses/cgt456/username/
(Please note if this is a new webpage you will see a 403 - Forbidden error on the page UNTIL you put a default document in the root folder of the website)
While the class website for CGT456 is the same address without your username added to the end of the URL.
 
You can connect to the website in Visual Studio or through a standard mapped network drive.

Opening the Website in Visual Studio:

Open Visual Studio from the start menu and then go to:

File->Open Web Site

When the new folder browser window opens select the network drive that you just mapped to open the website.

Once the website is open you can edit it and make new files through Visual Studio, if you would like to make sub-folders you can make them either through Visual Studio or through Windows Explorer by opening the mapped network drive.

Note: If you use your personal non-domain computer or device, make sure the computer or device has Visual Studio installed. There is a full version of Visual Studio available for faculty and students at https://azureforeducation.microsoft.com/devtools through Azure Dev Tools for Teaching license. There is also the free Visual Studio Community edition available at https://visualstudio.microsoft.com/vs/community/ for everyone.  If you need help, send a Trouble Report at https://engineering.purdue.edu/ECN/AboutUs/ContactUs 

Connecting to the Database in Visual Studio:

1) In Visual Studio go to the menu bar and select:
Tools->Connect to Database
 
2) In the dialogue box that opens use the following information:
Make sure that the "Data Source:" field is set to: Microsoft SQL Server (SqlClient)
 
3) In the "Server Name:" field type the following:
ecn-classmssql.ecn.purdue.edu
 
4) In the "Log on to the Server" box select the following if you are on an ECN supported computer:
Select the "Use Windows Authentication" radio button
 
5) In the "Encrypt" section select the following:
Select the radio button that says "False or Disable"
6) In the "Connect to a database" section select the following:
Select the radio button that says "Select or enter a database name:"
 
7) Then in the input field provide the following information as the database name:
zCGT456_username
 
Now select the "Test Connection" button, if it passes then click the "OK" button twice.

If you are using a computer not on the BoilerAD Domain (like your personal computer) you will need to follow the steps below before you can connect to the database using windows authentication in either Visual Studio or SQL Server Management Studio (SSMS):

  1. Open 'Manage Windows Credentials' from the start menu (the best way is to search for it from the start menu) to open Credential Manager in your computer
  2. Click the "Add a Windows Credential" button when Windows Credentials icon is selected
  3. For the Internet or network address field type in:
    • ecn-classmssql.ecn.purdue.edu:1433
  4. In the User Name field type
    • BoilerAD\YOUR_USERNAME_HERE
  5. In the Password Field type in your BoilerAD (career account) password
  6. After selecting the OK button you can close Credential Manager
  7. You can now open Visual Studio or SSMS and follow the instructions above or below to connect to the database
Once you have completed the steps above you will be connected to the database in Microsoft Visual Studio using windows authentication even when you opened the Visual Studio IDE as a local user account of your non-domain computer due to the windows credentials that you have added to your computer’s Credential Manager.

In an opened Visual Studio window/IDE (integrated development environment), on either right or left hand side (depending on your Visual Studio version/configuration) there will be a box for the 'Server Explorer' . In that box there is a section titled 'Data Connections' where the connection that you just made will be listed. Open that section with the carat (^) and you will see your MS-SQL Database. Then right click on the tables section to create new tables or anything else needing to be done. 

If you do not want to or cannot use Microsoft Visual Studio IDE to modify or view your database directly, you can instead use Microsoft SQL Server Management Studio to do so. But you always need the database connection created within Visual Studio for your programs to interact with your CGT 456 class database programmatically.  

 Connecting to the Database Server with Microsoft SQL Server Management Studio:
SSMS can be downloaded at the links below:
 https://goo.gl/aVwjtG (goes to docs.microsoft.com for download link)
  1. Once you have downloaded and installed Server Management Studio, open the program with the shortcut in the start menu
  2. A connection box will pop up for the "Server Type" select "Database Engine"
  3. For the "Server Name" type in the following:
    • ecn-classmssql.ecn.purdue.edu:1433
  4. Then for the "Authentication" select "Windows Authentication"
  5. Complete the connection by clicking on the "Connect" button
NOTE that you will need to STILL complete the above-mentioned steps of adding windows credentials in the Credential Manager if you are on a non-BoilerAD-domain PC. 
Once connected open the Database folder and double click on the database that you wish to modify.
 

Connecting to the Database Server on Mac OS:

There are two options for software on the Mac to connect to the Microsoft SQL Server sequel:

  1. DbVisualizer - free software that has limited functionality unless upgraded to the pro version but will allow for basic uses.
    1. https://www.dbvis.com/download/
  2. Valentina - free software but requires registration, which is free, to get a serial number to take it out of trial mode.
    1. https://www.valentina-db.com/en/studio/download

Once you have selected your software for use open it and connect using the information below:

Database Driver:   SQL Server (jTDS) (or just select the MSSQL option for Valentina Studio)

Server/Host:         ecn-classmssql.ecn.purdue.edu

Port Number:        1433

Username:            your BoilerAD (career account) username

Password:             your BoilerAD (career account) password

Domain:                BoilerAD (if there is no Domain section append your username with "BoilerAD\")

Authentication Method:  Windows (if available - used maily for DbVisualizer)

Database:             the database name that was assigned to you

If you have any issues with connecting to your site please email techsite@ecn.purdue.edu

All websites are set up to use generic HTML and PHP, if anything else is needed for your website please email windows@ecn.purdue.edu

Last Modified: Mar 1, 2024 11:48 am US/Eastern
Created: Jan 11, 2022 2:43 pm US/Eastern by admin
JumpURL:


Categories