From the course: Learning Microsoft SQL Server 2022

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Log into the server

Log into the server

- [Narrator] In order to work within the server and gain access to the various databases and tables of information that we're storing, we'll use a program called SQL Server Management Studio. Management Studio is often referred to by its acronym, SSMS, and it'll provide a graphical interface to the server's content so that we don't have to rely on a text-based command line interface. You'll find Management Studio in a start menu folder called SQL Server Tools. It's this icon right here with the crossed hammer and wrench. For maximum compatibility with SQL Server 2022, you want to make sure that you're using Management Studio version 19 or higher. Just like with Configuration Manager, I'm going to right click on it and choose to Pin to Start. That way we have easy access to SSMS. Okay, let's go ahead and start it up. Now, when the program first launches, you'll be presented with this Connect to Server dialogue window. Here…

Contents