How to Connect SQL Management Studio with Local SQL Server Express?

In short:

  1. Open SQL Configuration Manager
  2. Check SQL Server State is ‘Running’
  3. Open SQL Server Management Studio (SSMS)
  4. Use your Server Name and Windows Authentication

1. Open SQL Configuration Manager

SQL Configuration Manager

2.Check SQL Server State is ‘Running’

SQL Configuration Manager
“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)

Open Microsoft SQL Server Manager
“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

SSMS Connection
Click on ‘Browse for more..’ to find you local SQL server.

5. Select The Server to connect to

SSMS Select The Server To Connect To

6. Connect to Server

Connect to Server

7. Connected SQL Server Manager Studio

connected SQL Server Manager Studio
Read how to get connnection string from the appSettings.json.

Leave a Reply

Your email address will not be published.