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:
https://cgtweb2.tech.purdue.edu/courses/cgt456/username/
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:
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):
- 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
- Click the "Add a Windows Credential" button when Windows Credentials icon is selected
- For the Internet or network address field type in:
- ecn-classmssql.ecn.purdue.edu:1433
- In the User Name field type
- BoilerAD\YOUR_USERNAME_HERE
- In the Password Field type in your BoilerAD (career account) password
- After selecting the OK button you can close Credential Manager
- You can now open Visual Studio or SSMS and follow the instructions above or below to connect to the database
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.
- Once you have downloaded and installed Server Management Studio, open the program with the shortcut in the start menu
- A connection box will pop up for the "Server Type" select "Database Engine"
- For the "Server Name" type in the following:
- ecn-classmssql.ecn.purdue.edu:1433
- Then for the "Authentication" select "Windows Authentication"
- Complete the connection by clicking on the "Connect" button
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:
- DbVisualizer - free software that has limited functionality unless upgraded to the pro version but will allow for basic uses.
- https://www.dbvis.com/download/
- Valentina - free software but requires registration, which is free, to get a serial number to take it out of trial mode.
- 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
- Knowledge Base > Web > IIS