Windows 2022
Sponsored Link

SQL Server 2022 : Connect to Database Engine2023/01/13

Connect to Database Engine Service on localhost.
It's possible to connect to the service with command operation on localhost without additional installation.
Run PowerShell and use [Sqlcmd] command to connect.
It is based on that a logon user is the admin user of SQL Server you specified during installation on the example below.
Windows PowerShell
Copyright (C) Microsoft Corporation. All rights reserved.

# connect to database service
# sqlcmd -S [(Hostname or IP address)\(Instance Name)]
# Instance Name is optional if it is default name
PS C:\Users\Administrator> sqlcmd -S localhost 

1> select @@version
2> go

Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64)
        Oct  8 2022 05:58:25
        Copyright (C) 2022 Microsoft Corporation
        Enterprise Evaluation Edition (64-bit) on Windows Server 2022 Datacenter Evaluation 10.0 <X64> (Build 20348: ) (Hypervisor)

(1 rows affected)

1> exit
If you'd like to connect on localhost with GUI operation, it needs to install SQL Server Management Studio (SSMS).
Download and Install SSMS from the official site below.
After installing SSMS, run it.
[3] Click [Connect] button. It's OK to keep default for all selection if localhost connection.
[4] Just connected. It's possible to manage and configure SQL Server on here.
Matched Content