Using SQL Server Management Studio (SSMS)

  1. Check the SQL Server DBMS Help Pages.

  2. Download and install SQL Server Management Studio (SSMS).
    3.  SSMS is an integrated environment designed to manage any SQL infrastructure, including SQL Server. It provides a comprehensive utility that combines graphical tools with rich script editors.


  3. Launch the SSMS.
    4.  The following steps are based on Connect to the SQL Server.


    ⇓   The password was created when you customized your SQL Server installation.


    If the connection fails like
    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
    Follow the steps below to fix the problem. The steps are based on:


    1. Launch the Microsoft Management Console at

             C:/Windows/System32/services.msc
      and start the SQL Server instance, e.g., XQLEXPRESS03 (typo of SQLEXPRESS03), created when SQL Server setup:


    2. Activate the SQL Server Configuration Manager at

             C:/Windows/System32/mmc.exe
      and configure the SQL Server Network by setting the TCP Port to 1433:


  4. Manage the SQL Server.
    5.
    Activate the SQL Server instance if it is not on yet.

    1. Launch the Microsoft Management Console at

             C:/Windows/System32/services.msc
      and start the SQL Server instance, e.g., XQLEXPRESS03 (typo of SQLEXPRESS03), created when SQL Server setup:


    2. Activate the SQL Server Configuration Manager at

             C:/Windows/System32/mmc.exe
      and configure the SQL Server Network by setting the TCP Port to 1433:


    Show the query interface:


    ⇓   New Query & Execute


    Create a user:
    This function is based on How to Create New Login in SQL Server.

    • db_accessadmin
    • db_backupoperator
    • db_datareader
    • db_datawriter
    • db_ddladmin
    • db_denydatareader
    • db_denydatawriter
    • db_owner
    • db_securityadmin
    • public
    Security ⇒ Logins ⇒ New Login...


    ⇓   New Query & Execute


    Create a database:

    The master database in SQL Server is a critical system database that stores essential system-level information. It contains metadata about the SQL Server instance, such as logins, server configuration settings, linked servers, and the location of all other databases. Without the master database, SQL Server cannot start or function.

    ⇓   New Query & Execute


  5. :

  6. :

  7. :

  8. :

  9. :