- Open SQL Configuration Manager
- Check SQL Server State is ‘Running’
- Open SQL Server Management Studio (SSMS)
- Use your Server Name and Windows Authentication
1. Open SQL Configuration Manager
2.Check SQL Server State is ‘Running’
“SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers. SQL Server Configuration Manager is installed with your SQL Server installation. ” – docs.microsoft.com
3. Open SQL Server Management Studio (SSMS)
“SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with many rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.” – docs.microsoft.com
4. Use Server Name and Windows Authentication
Click on ‘Browse for more..’ to find you local SQL server.
5. Select The Server to connect to
6. Connect to Server
7. Connected SQL Server Manager Studio
Read how to get connnection string from the appSettings.json.