Skip to content

log-in-to-an-instance-of-sql-server-command-prompt.md

Latest commit

 

History

History
42 lines (32 loc) · 1.33 KB

log-in-to-an-instance-of-sql-server-command-prompt.md

File metadata and controls

42 lines (32 loc) · 1.33 KB
title Sign in to an Instance of SQL Server (Command Prompt)
description Learn about the sqlcmd utility. See how to use it in a command prompt to test connectivity to an instance of SQL Server.
author rwestMSFT
ms.author randolphwest
ms.date 06/05/2025
ms.service sql
ms.subservice configuration
ms.topic how-to
helpviewer_keywords
logins [SQL Server], named instance of SQL Server
log ins [SQL Server]
logins [SQL Server], default instance of SQL Server
command prompt [SQL Server], logins
logging in [SQL Server]

Sign in to an instance of SQL Server (Command Prompt)

[!INCLUDE SQL Server]

This article describes how to test connectivity to an instance of [!INCLUDE ssNoVersion], using the sqlcmd utility.

Sign in to the default instance of SQL Server

From a command prompt, enter the following command to connect by using Windows Authentication:

sqlcmd [/E] [/S servername]

Sign in to a named instance of SQL Server

From a command prompt, enter the following command to connect by using Windows Authentication:

sqlcmd [/E] /S servername\instancename

Related content