How to access the MS SQL

(Thanks Rui Wang for his great help)

 

Note: Please replace the http://www.development.ccs.neu.edu with the sql2005.development.ccs.neu.edu in the followings.

 

  1. First of all, you should have a CCS account (if not, please visit System office and get an account).
  2. Activate your Windows account for yourself by following the instruction at https://sql2005.development.ccs.neu.edu/Public/GettingStarted.aspx

3.      Login in with your Windows account at https://sql2005.development.ccs.neu.edu/FrontDesk/login.aspx?ReturnUrl=%2fFrontDesk%2fRegisterForm.aspx

4.      Activate your SQL server account by following the instructions.

  1. Use your Windows account to login into any Windows machine in our college. Then login into SQL server (“Query Analyzer”) with your SQL account. The name of SQL Server is “sql2005.development.ccs.neu.edu”.

 

 

If you want to access MS SQL off-campus and you use Windows, you should do following steps:

  1. Get your MSDNAA account by following the instruction at http://www.ccs.neu.edu/howto/howto-msdnaa-signup.html
  2. Download MS SQL server to your own computer with your MSDNAA account by visiting

https://msdn01.e-academy.com/elms/Security/Login.aspx?campus=neu_cs  (If you do not have MS Windows on your computer, you can also download Windows XP from the web site).

  1. Install MS SQL on your computer (Client software is good enough. But you also install a stand alone MS SQL server on your computer. In later case, please see the Note at the end of this document).
  2. Download “SSH Communications' Windows SSH client” at http://www.ccs.neu.edu/welcome/

10. For the SSH connection part. You can use any Solaris machine in the college (you can find their names by typing command “computers” after you login into any Solaris machine) as the “Host name”. You should replace the “***” in the following figure with the name of a Solaris machine. Then type in your own CCS username. The “Port number” should always be 22.

  1. Create SSH tunnel for SQL server (the general HOWTO document of creating tunneling can be found at http://www.ccs.neu.edu/howto/howto-windows-sshtunneling.html). For SQL tunnel, “Destination Host” is “sql2005.development.ccs.neu.edu”. The port number is “1433”.

  1. Use MS SQL “Client Network Utility”. Create an alias “SQL-server”.

 

  1. Use MS SQL “Query Analyzer”. The server name should be the same as that configured in the previous step (e.g., “SQL-server”).

 

If you want to access MS SQL off-campus and you DO NOT use Windows, you should do following steps (skip steps 6-12 listed above):

  1. Download “SSH Communications' Windows SSH client” at http://www.ccs.neu.edu/welcome/
  2. Create SSH tunnel for SQL server (the general HOWTO document of creating tunneling can be found at http://www.ccs.neu.edu/howto/howto-windows-sshtunneling.html). For SQL tunnel, “Destination Host” is “sql2005.development.ccs.neu.edu”. The port number is “1433”.

  1. Download  the suitable version “Aqua Data Studio” (e.g., For MAC, Linux, etc) from http://www.aquafold.com/downloads.html
  2. Install “Aqua Data Studio”.
  3. Create a new server group. Then register a server as it is illustrated in the figure below.

 

Note: you should shutdown your local MS SQL server (if you installed MS SQL server on your computer) before you connect to sql2005.development.ccs.neu.edu. Otherwise, you will get error message.