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. |
Sponsored Link |
|