SQL Server 2019 : Connect to Database Engine2020/01/30 |
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 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 |
[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://docs.microsoft.com/ja-jp/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 |
|