Scribd
Upload
19 views2 pages

Technical Background

SQL Server Management Studio is a free tool to manage SQL Server databases. It allows graphical management of databases. To install, select the server type and name then authentication. It opens with components like Object Explorer, Query Editor and Solution Explorer to manage databases.

Uploaded by

Sharmi Joyce Dausen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
19 views2 pages

Technical Background

SQL Server Management Studio is a free tool to manage SQL Server databases. It allows graphical management of databases. To install, select the server type and name then authentication. It opens with components like Object Explorer, Query Editor and Solution Explorer to manage databases.

Uploaded by

Sharmi Joyce Dausen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Technical Background

SQL Server Management Studio

SQL Server is a relational database management system (RDBMS) by Microsoft.

It supports SQL along with additional features known as T-SQL or Transact-SQL.

Microsoft provides set of tools to manage local or remote SQL Server databases such

as SSMS (SQL Server Management Studio), SQL Server Agent, SQL Server Analysis

Services, SQL Server Reporting Services, SQL Server Integration Services, etc.

(Tutorials Teachers).

SQL Server Management Studio is a free multipurpose integrated tool to access,

develop, administer, and manage SQL Server databases, Azure SQL Databases, and

Azure Synapse Analytics. SSMS allows you to manage SQL Server using a graphical

interface.

SSMS can also be used to access, configure, manage & administer Analysis ser-

vices, Reporting services, & Integration services. It runs only on Windows.

How to Install:

1. To launch SSMS from the Start menu, click Start and scroll down and expand

Microsoft SQL Server Tools 18. Click on Microsoft SQL Server Management Studio.

2. Clicking on the "Microsoft SQL Server Management Studio" will open the following

window to connect with the server.

3. Connect to SQL Server Instance

4. Select Server Type, Server Name, and Authentication mode to connect with your

server. SSMS can be used to connect with Database Engine, Analysis Services, Re-
porting Services, Integration Services, etc. Here, we will connect with our local SQL

Server database, so select Database Engine as a server type.

5. Next, select the server name to which you want to connect. It can be a local or re-

mote DB server. Select an appropriate server name or <Browse for more..> to browse

server name.

6. Next, select the authentication mode. The latest version of SSMS offers five modes of

authentication to choose from, as shown below. The most common is Windows Authen-

tication and SQL Server Authentication.

7. After selecting the authentication type and entering the user name and password

(SQL authentication) and click on the Connect button. On successful login, the SSMS

opens the following window.

SQL Server Management Studio has the following components:

 Object Explorer

 Security

 Server Objects

 Query and Text Editor

 Template Explorer

 Solution Explorer

 Visual Database Tools

Visual Basic

Profiling System

You might also like