Print this article Edit this article

Connecting to ecniisdev

Use the following instructions to connect to both IIS web sites and your MSSQL Database (if your website has one)
 
To access the servers file storage for IIS for your development or class website you will need to map a network drive to the following path:
 
\\ecniisdev.ecn.purdue.edu\sitename
 
To access the servers file storage for IIS for your production website you will need to map a network drive to the following path:
 
\\ecniisprod.ecn.purdue.edu\sitename
 
You will need to be on the Purdue network OR be on the VPN to connect to the server the instructions for how to map a network drive are located here:                  
http://eng.purdue.edu/jump/4fff24
You will map the drive with your existing ECN domain username and password.
 
The website for the webpage to access is:
Your development webpage that is hosted on ecniisdev.ecn.purdue.edu:

https://ecniisdev.ecn.purdue.edu/sitename/

Your production webpage that is hosted on ecniisprod.ecn.purdue.edu:

https://sitename.ecn.purdue.edu/

(Please note if this is a new webpage you will see a 403 - Forbidden error on the page UNTIL you put an index page in the root folder of the website)
 
You can connect to the website in Visual Studio and access the database from Visual Studio as well:

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.

 

Connecting to the Database in Visual Studio:

 
In Visual Studio go to the menu bar and select:
 
Tools->Connect to Database
 
In the dialogue box that opens use the following information:
 
Make sure that the "Data Source:" field is set to: Microsoft SQL Server (SqlClient)
 
In the "Server Name:" field type the following:
 
For the production webpage's MS-SQL DB:
 
ecnmssqlprod.ecn.purdue.edu
 
For the development (ecniisdev.ecn.purdue.edu/sitename) webpage's MS-SQL DB:
 
ecnmssqldev.ecn.purdue.edu
 
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
 
In the "Connect to a database" section select the following:
 
Select the radio button that says "Select or enter a database name:"
 
Then in the input field provide the following information as the database name:
 
For your production webpage's MS-SQL DB:
 
sitename
 
For your development webpage's MS-SQL DB:
 
dev_sitename
 
Now select the "Test Connection" button, if it passes then click the "OK" button twice.
 
If you are using an unsupported computer (like your personal computer) you will need to follow the steps below before you can connect to the database in either Visual Studio or Server Management Studio:
 
  1. Open 'Manage Windows Credentials' from the start menu (the best way is to search for it from the start menu)
  2. Click the "Add a Windows Credential" button
  3. For the Internet or network address field type in:
    • ecnmssqldev.ecn.purdue.edu:1433
  4. In the User Name field type
    • ECN\YOUR_USERNAME_HERE
  5. In the Password Field type in your ECN password
  6. After selecting the OK button you can close Credential Manager
  7. You can now open Visual Studio or Server Management Studio and follow the instructions above or below to connect to the database
 
One you have completed the steps above you will be connected to the database in Microsoft Visual Studio.
 
In the server explorer on either the way right or left hand side (depending on your Visual Studio version/configuration) there will be a box for the 'Server Explorer' in that box is a section titled 'Data Connection' 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 you can instead use Microsoft SQL Server Management Studio. 
 
 
 

Connecting to the Database Server with Microsoft SQL Server Management Studio:

This can be downloaded at the link below:
 https://goo.gl/aVwjtG (goes to msdn.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:
    • ecnmssqldev.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 unsupported computer steps above if you are on an unsupported or non-ECN-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 X:

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. http://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. http://www.valentina-db.com/en/all-downloads

 

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:   ecnmssqldev.ecn.purdue.edu or ecnmssqlprod.ecn.purdue.edu (depending on the DB you want to connect to)

Port Number: 1433

Username:      your ECN username

Password:       your ECN password

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

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

Database:       the database name that was assigned to you

 

Please email the ECN Windows Queue with any issues that you may have with either IIS or the MSSQL Database.

 

Last Modified: Nov 1, 2017 3:01 pm America/New_York
Created: Dec 9, 2015 3:01 pm US/Eastern by admin
JumpURL:


Categories