Setup

In order to access the database server "CSCMSSQL1"  using ASP you need to follow these steps:

1) Each project should have a private directory on the server, where you store all your html and asp files. (If you still don't have a directory please email Omprakash Eleti at o_eleti@uncg.edu )

2) To access your directory from the UNCG-FacultyStaffStudent wireless network, go to START, click on RUN and paste \\cscmssql1\FolderName , or paste the path directly in your web browser, FolderName is the name of the folder created by the Database Administrator. This folder is usually the same as your username.

3) If you are asked to enter a username and a password type it in using this format ISP\USERNAME where USERNAME and PASSWORD are usually your standard UNCG login credentials. If your password does not work, you can set it using UNCG's password reset tool at this address: http://reset.uncg.edu. When using the password reset tool you will be asked to reset several different account types, make sure the "ISP domain" checkbox is checked, as this is the account type the cscmssql1 server uses.

4) Drag and Drop your project files to the directory.

5) To browse your website, type the following link in your browser http://cscmssql1.uncg.edu/FolderName/filename.asp , FolderName is the same as above, and filename.asp is the file you've uploaded, the default homepage for ASP is Default.asp, so if you go to this link http://cscmssql1.uncg.edu/FolderName it will direct you to the Default.asp file you have created as your homepage.

To see some examples on how to write and connect to the database using ASP and HTML click here.