Please follow the steps in MS SQL & ASP.NET to create a CCIS-WINDOWS account and a MS SQL account. Both accounts will have the same user name, which is your UNIX user name.
Your UNIX account and CCIS-WINDOWS account have the same password. Your MS SQL account will be given a temporary password. Pleas remember this password. Later you can change your MS SQL password.
When your CCIS-WINDOWS account is created, a virtual directory uner the web server (IIS) is created for you to hold your web files. When your MS SQL account is created, a database named as your user name is created for you to hold your data tables.
Please read FAQ to understand how to use your user name to connect to MS SQL Server, and how to upload your web files to the web server.
To access MS SQL Server, on any CCIS windows workstation, run Query Analyzer of MS SQL Server. The SQL Server name is www.development.ccs.neu.edu, the user name is your-user-name, and the password is your-MSSQL-password. Notice that you should use SQL Server authetication.
Due to the security setting by CCIS network, we are unable to connect to MS SQL Server directly in Query Analyzer from outside of the CCIS network. I tried SSH tunneling, but it doesn't work.
After the SQL Server is connected, inside the Query window, type the command sp_password 'old-mssql-password', 'new-mssql-password', then click the button with green button in the tool bar to execute the command, that is, change the password.
You can type the command select * from sysobjects to know all system objects inside your database.
To upload files to the web server, on any CCIS windows workstation, go to "Run ...", type in \\Development\net\home\your-username. The user name should be like ccis-windows\your-username, and the password is your-cciswindows-password. Then your directory under the web server is opened, you could drag your files to that directory.
To upload files to the web server from outside the CCIS network, run SSH Secure File Transfer. The host name is www.development.ccs.neu.edu, the user name should be like ccis-windows\your-username, and the password is your-cciswindows-password.