# Microsoft SQL Server
[Download and Install](https://www.microsoft.com/en-us/sql-server/sql-server-downloads)
- 2 options:
- Express (*I selected this one*)
- limited features
- limited database size
- can be used for business purposes
- Developer
- can not be used for business purpose
- Prob just install "basic"
Overview of different Apps:
- Sql Server Configuration Manager
- can see that server is running
- start mode: "automatic" = will start will booting up computer
- can pause, stop, start server here
When installed, provided this info:
- Connection String: `Server=localhost\SQLEXPRESS;Database=master;Trusted_Connection=True;`
- Instance Name: `SQLEXPRESS`
- SQL Administrators: `ELISESYOGA\toy4t`
- Features Installed: `SQLENGINE`
- SQL Server Install Log Folder: `C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20231031_172936`
- Installation Media Folder: `C:\SQL2022\Express_ENU`
- Installation Resources Folder: `C:\Program Files\Microsoft SQL Server\160\SSEI\Resources`
Changed "log-on as" from "this account" to "built in account: local system" by right click server -> properies