Student Development Server - Databases

Connecting externally

Note: If you are attempting to access the server externally, you will need to VPN into the network. Code you execute on the development web servers will have no problems accessing either database. For instructions on setting up the VPN for a variety of operating systems click here (ignore any information about connecting your wireless, the settings are the same).

MySQL Connection Information

All teams have databases with the following format:

• Server: linux.dev.scis.ecu.edu.au
• Database name: teamxxx
• Login details: ADS username and password
• Port: 3306 (default)

To test this connection:

• mysql -h lnx.dev.scis.ecu.edu.au -u username -p

View the database via the PHPMyAdmin web interface:

• http://linux.dev.scis.ecu.edu.au/phpmyadmin/

Microsoft SQL Server Connection

Using Microsoft SQL Server Management Express, enter the following details

• Server: win.dev.scis.ecu.edu.au
• Authentication: Windows Authentication

Note: If you need to use a different username, you need to run the software under different credentials. Right-click the shortcut and select 'Run as...'

Warning: A bug in the software prevents you from being able to create your first table. If you receive an error that the software cannot find the default schema, run this command in a query window:

use [teamxxx]
go
CREATE TABLE [temptable] ( data varchar(10) )
go

You can delete the table after this is done and future tables will be created without errors.