300104 Database Design and Development

[Pages:4]300104 Database Design and Development

Instructions for accessing Microsoft SQL Server (MSSQL)

General Notes: It is important for you to understand that you MUST have a current School (SCEM) account; you will not be able to use MSSQL without a current SCEM account.

You can tell whether you have a current SCEM account by logging in to a computer in any of the School's computer labs. The SCEM labs are in the following rooms:

Campbelltown Campus:

Parramatta Campus:

Penrith Campus:

6.G.01 6.G.19

EB.1.48 EB.1.30 EB.1.50

Y2-27 Y2-28 Y2-41 Y2-42

For those students who CAN NOT login to the School's computers, you will need to do the following first: 1. Register for a SCEM account a. Go to any SCEM lab (see above) and boot one of the workstations b. At the login screen, follow the directions on the bottom left of the screen to register for an account

For those students who CAN login to the School's computers, read on: 1. Each student has been allocated their own database which has the same name as their SCEM login. For example, if your SCEM login is `fsmith' then the database you have access to is also called `fsmith'. Each student `owns' their database and has full rights to create tables, indexes, triggers etc. This database is also your default database, when you access MSSQL using a tool such as SQLCMD.EXE, you will automatically connect to your database. Your database is created for you at the start of semester. Under certain conditions (eg. Late enrolment), your database will not be created and you will need to notify technical staff to have your database created. 2. Checking your database. Read the section: `Here are two ways to work with databases in MSSQL'. The server for this unit is called: 300104.scem.uws.edu.au. You will use this name whenever prompted for a server name. If you can connect to your database using one of these tools, then your database has been correctly created. 3. If you CANNOT connect to your database using the tools in section 2: a. Once you have a valid SCEM account and can login to a computer from any of the SCEM labs: i. Email me at b.kneale@uws.edu.au with `MSSQL registration' as the subject 1. Make sure that you include your SCEM username in the contents of the email (I do not want your password) ii. When I receive your email I will create your database and reply to you when it is done.

Accessing MSSQL from a SCEM computer lab: MSSQL is setup to use `Windows Authentication'. This means that you MUST have the same account details (username and password) on your local workstation as your SCEM username and password. To meet this criteria in the SCEM computer labs we need to use a `front end'. Please see the accompanying document titled: 300104 Database front end usage instructions.pdf which will explain what to do.

Accessing MSSQL from outside a SCEM computer lab: MSSQL is setup to use `Windows Authentication'. This means that you MUST have the same account details (username and password) on your local workstation as your SCEM username and password. If your local account details match your SCEM account then you will not be prompted for authentication. If your local account details do not match your SCEM account then authentication will fail and you will not be able to access MSSQL. This means that you will not be able to access MSSQL from ITD (UWS) computer labs. ITD computers use your `MyUWS' account credentials to login. These credentials are different from your SCEM credentials so authentication to MSSQL will fail.

Accessing MSSQL from home: Please note: SCEM technical staff DO NOT support access from home or work computers. It is up to you to talk to your peers, read the documentation and search the web in order to get your home connection running. Having said that, here are some steps that may get your home computer connected:

1. Install the MSSQL Client Tools a. You can download an installation package from the Microsoft Download Centre called Microsoft? SQL Server? 2008 Management Studio Express. Download URL: b. Windows 7 users will also need to install Microsoft SQL Server 2008 Service Pack 2. Download URL:

2. Vista / Windows 7 users. Those who are using Vista or Windows 7 should use MSSQL 2008. You may also need to make a change to the computer's Group Policy. a. Run the following file: gpedit.msc (Local Group Policy Editor) b. Edit the section: Local Computer Policy > Computer Configuration > Windows Settings > Security Settings > Local Policies > Security Options > Network Security: LAN Manager authentication level and change the value to ' Send LM & NTLM - use NTLMv2 session if negotiated' (see image).

3. Create a Windows account that matches your SCEM username and password a. Right click on `My Computer' and select `Manage' from the menu b. In the Computer Management window, select `Local Users and Groups'. Right click on `Users' and select `New User ...' c. Create a new account using your SCEM username and password d. Use this account to access MSSQL

4. Create a Virtual Private Network (VPN) to the School a. See this URL for information on connecting to the School via VPN:

5. Once you have the previous components running then the following steps should gain access to MSSQL: a. Make sure you login to your computer using the SCEM account you created in point 3 above b. Connect to the School using the VPN you created c. Run the tool you want to use to access MSSQL. See below for two tools that are installed with MSSQL Client Tools

Here are two ways to work with databases in MSSQL: There are many ways to work with MSSQL, these two tools are installed when you install Microsoft Client tools for SQL Server.

1. SQL Server Management Studio a. This is a GUI application that allows users to create and populate databases 1. This tool is usually started from: Start > Programs > Microsoft SQL Server xxxx > SQL Server Management Studio. Although you may need to search through the Start > Programs menu to find the correct location b. Run SQL Server Management Studio and when prompted to login, type `300104.scem.uws.edu.au' into the `Server name:' field. (see image).

Type the server name in here

2. SQLCMD.EXE a. This is a command line tool that accepts SQL statements in order to create and populate databases

b. This program is usually in the following directory: C:\Program Files\Microsoft SQL Server\xx\Tools\Binn (where xx is the MSSQL version number)

c. Open a `Command Prompt' and change directory (cd) to the directory in point b (see image). d. At the prompt, type the following: SQLCMD -S 300104.SCEM.uws.edu.au (see

image).

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download