Windows 2019
Sponsored Link

SQL Server 2019 : Connect to Database Engine2020/01/30

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 2019 (RTM) - 15.0.2000.5 (X64)
        Sep 24 2019 13:48:23
        Copyright (C) 2019 Microsoft Corporation
        Enterprise Evaluation Edition (64-bit) on Windows Server 2019 Datacenter Evaluation 10.0 <X64> (Build 17763: ) (Hypervisor)

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