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

Connect to Database Engine Service on localhost.

[1]	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

[2]	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. ⇒ https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms 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