From the course: Learning Microsoft SQL Server 2022

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Configure and start the server

Configure and start the server - SQL Server Tutorial

From the course: Learning Microsoft SQL Server 2022

Configure and start the server

- [Instructor] In its default configuration, SQL Server starts automatically in the background whenever the computer boots up so they can listen for incoming connection requests and be ready to retrieve or write data to the databases that it manages. However, you won't see any indication of its presence if you look for it down on your Windows Taskbar or even if you go over to the System Notification tray. This configuration makes sense when you're running SQL Server on dedicated hardware, but if you're running SQL Server on your own personal desktop or laptop computer, it's probably is not ideal to always have SQL Server running and consuming your resources. In order to manage the settings or to start and stop the server, we need to use a program called SQL Server Configuration Manager. You can find it by going over to the Start menu and you'll see we have a new folder that's been added for SQL Server 2022. Inside is the…

Contents