Wiki Page

Using MS SQL Server on ECST-CSPROJ2

We have an MS SQL Server 2017 Developer Edition running on an Ubuntu Server 16.04 virtual machine hosted at ecst-csproj2.calstatela.edu. The server can be accessed directly on campus network (both wired and wireless), but due to campus firewall restrictions, to access the server from off-campus locations, you must use VPN.

Connection Information

Server Type	Database Engine
Host Name	ecst-csproj2.calstatela.edu
Port Number	6301
Authentication Type	SQL Server Authentication
Username, Password, and Database	<assigned in class>

You should receive an account and a database on the server for your class. Note that the name of your database is the same as the name of your account username. For example, if the username is cs4540stu31, the database name is also cs4540stu31.

Client Tools

SQL Server documentation lists a number of client tools you may choose from. Here are three standalone tools with some pros and cons:

	UI	Pros	Cons
MS SQL Server Management Studio (SSMS)	GUI	THE SQL Server management tool used by most DBA and developers	Windows only, and takes lots of disk space (in the GB range)
Azure Data Studio (ADS)	GUI	Cross-platform (Windows, MacOS, and Linux)	Not as feature-rich as SSMS
sqlcmd	Command Line	Suitable for resource-limited/non-GUI environments and running SQL scripts.

Connection Using MS SQL Server Management Studio (SSMS)

(SSMS Connection)

As shown in the screenshot above, when connecting using SSMS, the host name and the port number are specified in the Server Name field separated by a comma. And your should replace cs4540stu31 and the password with your own username and password.

Connection Using Azure Data Studio (ADS)

Again, notice that the host name and the port number are specified together and separated by a comma.

Connection Using sqlcmd

> sqlcmd -S ecst-csproj2.calstatela.edu,6301 -U <username> -d <database>

You can see the list of command line options by typing sqlcmd -?

This page has been viewed 3601 times.