reset password

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.

Connection Information

Server Type Database Engine
Host Name ecst-csproj2.calstatela.edu
Port Number 6311
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)

(ADS Connection)

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,6311 -U <username> -d <database>

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

 
This page has been viewed 4110 times.