From: "Johnny Zhang via RT" <helpdesk@cs.sfu.ca>
Subject: [eSupport #273966] Microsoft SQL Database in CSIL, for CMPT-354
Date: January 12, 2017 at 11:02:50 PST
To: undisclosed-recipients:;
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 50MB and the transaction log
is set to 200MB.

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/support/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/about/support/how-to-contact-helpdesk.html