Wiki Page

Using MS SQL Server on CS3

We have an MS SQL Server 2019 Developer Edition running on CS3.

Connection Information

Server Type	Database Engine
Host Name	cs3.calstatela.edu
Port Number	1433 (default)
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)

You should replace cs4540stu31 and the password with your own username and password.

Connection Using Azure Data Studio (ADS)

Connection Using sqlcmd

> sqlcmd -S cs3.calstatela.edu -U <username> -d <database>

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

This page has been viewed 4109 times.