Introduction
The page consists primarily of screen snapshots
that will show the steps for connecting to the
Microsoft SQL 2005 Server installed at CCIS using
the program SQL Server Management Studio.
The server is located at the following internet
address:
MSSQL2005.development.ccs.neu.edu
How you access the server depends on whether you
are inside the firewall, that is, in the lab, or if
you are using an external system such as your own
machine.
These notes assume that you have already registered
for a SQL account and received the auto-generated
password. If you have not done this, then first go to:
ASP.Net Registration
Connecting to SQL 2005 Server In Lab
If you are working in the lab on a Windows machine,
you can launch SQL Server Management Studio
and click Connect in the lower left of the menu bars.
You will then see a connection dialog which should be
filled in as follows:
So the Server Type is Database Engine,
the Server Name is the internet address listed above,
the Authentication is SQL Server Authentication,
the Login name is your usual username,
and the Password is your special SQL password.
I strongly urge you not to click the
Remember password check box on a lab machine.
Go to What You See After Connection
to see approximately what a successful connection will
look like.
Setting Up the SHH Tunnel
If you are working remotely, you must use a
Secure Shell (SSH) tunnel to access the SQL 2005 Server.
This tunnel should be added to the tunnel list in the
settings you use to get to denali or any similar
UNIX machine. Do not use the development server for
the tunnel since it will not work.
In SSH, pick the profile you use for standard logins.
This is either “Quick Connect” or some
profile you have defined and named.
In the Profiles menu, pick
Edit Profile, then select your profile, and click
on the Tunneling tab on the right.
You will see a dialog similar to the one below except
that since I have already created the tunnel so it appears
in the snapshot.
Click the Add button. You will then get a
second dialog which should be filled in as follows:
The Display Name can be anything you want but
“SQL” makes sense. The type should be
TCP and both ports should be 1433.
The Destination Host should be the internet address
of the SQL 2005 Server given above.
Check “Allow Local Connections Only”
to prevent evil hackers from tunneling through your
machine to the server.
Click OK each time to exit from the pair of dialog
boxes. You then must select Save Settings
from the SSH File menu or SSH will forget what you
have just done! After this, close SSH and reopen it to
make the settings effective.
Connecting to SQL 2005 Server Remotely
If you are working remotely on a Windows machine,
you can launch SQL Server Management Studio
and click Connect in the lower left of the menu bars.
You will then see a connection dialog which should be
filled in as follows:
So the Server Type is Database Engine,
the Server Name must be 127.0.0.1,
the Authentication is SQL Server Authentication,
the Login name is your usual username,
and the Password is your special SQL password.
Warning: For some inexplicable reason, you may
not use localhost in place of
127.0.0.1. The connection will
fail with a useless error message.
Comment: I clicked Remember password here since I
was working from my own laptop.
What You See After Connection
Below is a snapshot of approximately what a successful
connection will look like. Notice that you
will see a list of all databases. You will however
only have access to your own database.
