Cómo Instalar SQL Server y Management Studio en Windows, Guía Rápida Instalar SQL Server y SSMS

How to Install SQL Server and Management Studio

Introduction to Installation

• Jorge Luis Herrera introduces himself as a professor and systems engineer, outlining the goal of the session: installing SQL Server and Management Studio on Windows 10 and 11.

• The installation process begins with a Google search for "download SQL Server," leading to the official Microsoft download page.

Choosing the Right Version

• Users are presented with four options: SQL Server 2022 Local, Azure SQL, Developer Edition, and Express. The Express version is recommended for its lightweight nature.

• Jorge decides to download the Express version due to its smaller size (4 MB), emphasizing that it is suitable for quick installations.

Installation Steps

• After downloading, users should navigate to their downloads folder. It's crucial to right-click on the installer and select "Run as administrator" instead of double-clicking.

• Upon launching the installer, users will see options for basic, custom, or medium downloads; selecting "basic" is advised despite a language conflict warning.

Configuration Settings

• Users must accept terms in English during installation and confirm default installation paths in C:Program FilesMicrosoft SQL Server.

• A connection string option appears during setup; users should copy this into a text document for future reference.

Installing Management Studio (SSMS)

• After installing SQL Server, users can install SSMS by clicking an option at the bottom of the window which opens a browser for downloading.

• The download process includes navigating through steps until reaching a button labeled "Download SSMS21."

Finalizing Installation

• Once downloaded, right-click on SSMS installer and run as administrator. Confirm installation prompts as necessary.

• During SSMS setup, users will see options regarding additional resources like compilers; it's suggested to mark all available options before proceeding with installation.

Completion of Setup

• After waiting for installations to complete (approximately 2.28 GB required), users can choose whether or not to launch immediately after finishing.

• All installation windows can be closed once confirmed successful; instructions conclude with how to access Management Studio via search functionality in Windows.

How to Set Up SQL Server Management Studio

Initial Setup and Installation

• The program can be found by locating the blue logo, not the yellow folder. Users can pin it to the taskbar for easy access.

• Upon opening, users are prompted to log in with a Microsoft account or GHub; however, this step can be skipped.

• Users are given an option to try new versions of the software. If no server name appears, they need to manually enter their computer's name followed by SQL Express.

Finding Server Name

• To find the server name, navigate to "This PC," right-click on it, and select properties where the device name is displayed.

• The server name format should include a backslash followed by SQL Express. If needed, users can search online for how to type a backslash.

Connection Settings

• After entering the server name correctly, users must choose authentication options; Windows authentication is recommended initially.

• It's crucial to verify connection settings before attempting to connect. Options include mandatory or optional trust settings for the server.

Database Access and Language Settings

• Once connected successfully, users can access databases and create new queries within Management Studio.

• The installation language defaults based on Windows settings; if English is preferred over Spanish, reinstallation with language modification is necessary.

Verifying SQL Server Status

• To check if SQL Server is running properly, use Windows + R and type services.msc, then locate SQL Server in the list.

• Ensure that SQL Server (SQL Express) shows as running; if not, it may need restarting through right-click options in services.

Connecting to Management Studio

Initial Connection Issues

• The speaker highlights that if the connection fails, it is likely because the SQL Server engine is not running.

• A demonstration of attempting to connect shows a failure message due to the engine being deactivated.

• The speaker emphasizes the importance of ensuring all necessary checks are performed before starting work with the program.

Starting the SQL Server Engine

• To resolve connection issues, right-clicking and selecting "Start" initiates the SQL Server engine.

• After starting, a confirmation appears indicating successful execution, allowing users to reconnect without issues.