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 - 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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.