From: "Johnny Zhang via RT" <helpdesk@cs.sfu.ca>
Subject: [fas.sfu.ca #189248] Microsoft SQL Database in CSIL, for CMPT-354
Date: 17 January, 2013 15:07:16 PST
Cc: cmpt-354-d1@sfu.ca, cmpt-354-e1@sfu.ca
Reply-To: helpdesk@cs.sfu.ca

Dear cmpt-354 students,

A SQL database has now been set up for each of you on the Microsoft SQL Server
2008 R2 on CYPRESS.csil.sfu.ca - the CSIL SQL Server. Your database is named:

<username>354

Where "username" is your SFU computing ID.

The maximum size of your database is set to 20MB and the transaction log is set
to 80MB.

You may connect to CSIL SQL Server by using "Windows Authentication" while you
logon to a CSIL Windows computer. For any other scenarios, you should use "SQL
Server Authentication" to make the connection.

You can use "SQL Server Management Studio" to manipulate database on cypress
from any CSIL Windows system. Select "Database Engine" as the server type, use
CYPRESS.csil.sfu.ca as the server name and select "Windows Authentication" to
connect.

In your own program, you may use "Windows Authentication".

To use "SQL Server authentication", a SQL Server standard login is required.
There is a SQL Server standard login created for you. This login is formatted
like:

s_<username>

Each SQL Server standard login has an associated password. To find the
passwords for your SQL Server standard login, please check your course database
(e.g. <username>354) with SQL Server Management Studio. There is a table named
"helpdesk" and the password is in this table.

Please do not share your SQL Server standard login with any one.

Also, please note: you cannot change this login name nor the password. Thus,
please do not change the record in the table 'helpdesk'.

For more information, please read through this page:

http://www.cs.sfu.ca/about/school-facilities/csil/windows/how-to-use-sql.html

Should you need further assistance, please feel free to contact
helpdesk@cs.sfu.ca

Regards,

-helpdesk
http://www.cs.sfu.ca