Thursday, August 14, 2025

STP/RSTP Timers Explained : Hello Timer, Max-Age Timer, Forward delay, Differences between STP, RSTP, PVST, RPVST, and MSTP

STP/RSTP uses three timers for its functions. These timers control and define the time STP needs to reach convergence. These timers are Hello, Max age, and Forward delay. The root bridge dictates these timers in BPDUs. The following table lists these timers.

TimerDefault ValueDescription
Hello2 secondsThis is the interval between two consecutive BPDUs.
MaxAge10 times HelloThis is the maximum time a switch waits for a BPDU before changing the STP topology.
Forward delay15 secondsThis is the time the switch keeps ports in learning and listing states.

Let us understand the above timers in detail.

Hello Timer:

Switches use BPDU (Bridge Protocol Data Unit) messages to communicate and share STP (Spanning Tree Protocol) information. A BPDU message contains all the information that STP requires to build and maintain its topology. All STP-running switches broadcast a BPDU at a fixed interval. The Hello-timer defines this interval. The default value of this timer is two seconds. Therefore, all STP-running switches broadcast a BPDU every two seconds.

Max-Age Timer:

As long as a switch receives a BPDU every two seconds from its neighbors, it operates normally. However, if it does not receive a BPDU from the neighbor within MaxAge time, the switch reacts by taking steps to change the STP topology. The default value of this timer is ten times the Hello timer. Since the default value of the hello timer is 2 seconds, the default value of it will be 20 seconds (2 * 10 = 20). So, a switch would wait 20 seconds without hearing a Hello BPDU before reacting.

Forward delay:

Switches use this timer to age out old entries from the CAM table and add new entries. The switch uses CAM table entries to make forwarding decisions. When a network change occurs, CAM table entries become invalid. The switch can not use the existing entries to make forwarding decisions. It must flush the existing entries and learn them again to make forwarding decisions. The switch completes these tasks in the Forward delay time. The default forward delay time is fifteen seconds. STP uses fifteen seconds to flush old entries. It uses the Listening state for this. It takes another fifteen seconds to learn and add new entries to the CAM table. It uses the Learning state for this.

Viewing the STP timer

You can use the show spanning-tree command to view the STP timer values.

show spanning tree command

Similarities between STP, RSTP, PVST, RPVST, and MSTP

The following are the similarities between STP, RSTP, PVST, RPVST, and MSTP. 

  • All create and use a virtual topology to find switching loops in every VLAN.
  • All elect a root bridge and use it as the focal point of the virtual topology.
  • All use the same rules and tiebreakers for the root bridge election.
  • Besides the root bridge, all remaining switches become non-root bridge switches.
  • All select only one root port to reach the root bridge.
  • All use the same rules and tiebreakers to select the root port.
  • All select only one designated port for every local segment or end device.
  • All use the same rules and tiebreakers to select the designated port.
  • After selecting root and designated ports, they block all remaining ports to remove loops.
  • All variations run all ports through a few states. During these states, they learn the network topology, flush CAM table entries, select root and designated ports, and block the ports causing the loops.

Differences between STP, RSTP, PVST, RPVST, and MSTP

The main reason for creating RSTP/RPVST was the convergence. Convergence is the time STP takes to react to a network change. STP/PVST takes a relatively long time for convergence. With default settings, it takes 50 seconds to reach convergence. RSTP/RPVST/MSTP improves it. It reaches convergence within a few seconds (or in slow conditions, in about 10 seconds).

It adds two new port types for rapid convergence. These port types are alternative and backup ports. It uses the alternative port to reach the root bridge if the link connected to the root port fails. It uses the backup port to reach the local segment when the link connected to the designated port fails.

Since it has an alternative or backup port, it does not have to reselect the root or designated ports when a network change occurs. If the root path fails, it enables the alternative port within a few seconds. If the designated path fails, it enables the backup port. It means if the network is running RSTP/RPVST/MSTP, it has to wait a maximum of 10 seconds whenever a change occurs.

STP/PVST does not have a concept of alternative and designated ports. If the root or designated path fails, it reruns the entire process to select the new root or designated ports. Running the entire process again takes 50 seconds. It means if the network is running STP, it has to wait for 50 seconds whenever a change occurs.

RSTP/RPVST/MSTP does not use the learning state. It also renames the blocking state to the discarding state and redefines its use slightly. It combines disabled and blocking states into the discarding state. In the disabled state, the port can work physically, but it can not forward user frames. It simply meant that the interface was administratively disabled.

Conclusion:

There are three STP timers: Hello, Max age, and forward delay. Hello timer defines the interval between BPDUs. The Max age timer defines the switch's wait before rebuilding the STP topology when it does not receive BPDUs from its neighbors. STP uses the forward delay timer to rebuild the CAM table entries. It uses this timer for two states: Listening and Learning. In the Listening state, it ages out old entries. In the Learning state, it adds new entries to make forwarding decisions.

===============================================================


"This Content Sponsored by SBO Digital Marketing.

Mobile-Based Part-Time Job Opportunity by SBO!

Earn money online by doing simple content publishing and sharing tasks. Here's how:

  • Job Type: Mobile-based part-time work
  • Work Involves:
    • Content publishing
    • Content sharing on social media
  • Time Required: As little as 1 hour a day
  • Earnings: ₹300 or more daily
  • Requirements:
    • Active Facebook and Instagram account
    • Basic knowledge of using mobile and social media

For more details:

WhatsApp your Name and Qualification to 8489257126

a.Online Part Time Jobs from Home

b.Work from Home Jobs Without Investment

c.Freelance Jobs Online for Students

d.Mobile Based Online Jobs

e.Daily Payment Online Jobs

Keyword & Tag: #OnlinePartTimeJob #WorkFromHome #EarnMoneyOnline #PartTimeJob #jobs #jobalerts #withoutinvestmentjob"

==========================================================================

Tuesday, August 5, 2025

Installing and Setting Up Microsoft SQL Server Express : Close Windows Services and Task Manager applications before installing

This section provides information for administrators with limited experience with Microsoft SQL Server. The following steps assume you do not have Microsoft SQL Server installed and guide you through downloading and configuring the free Microsoft SQL Server Express edition.

Downloading and Installing Microsoft SQL Server Express and Microsoft SQL Server Management Studio

Before you begin

  • Decide where to install Microsoft SQL Server.
  • Note the connection string as it appears in the installation process. You need it later when installing SOTI Connect.
Important: Close Windows Services and Task Manager applications before installing.

Procedure

  1. Download Microsoft SQL Server 2019 Express to your local machine.
    Note: If you encounter installation issues, update Windows and reboot. Repeat updating and rebooting until there are no more updates to install.
    Note: You may need to restart Microsoft SQL Server multiple times during the installation process for security changes to take effect.
  2. Run the Microsoft SQL Server Express .exe file on your local machine.
  3. Select the Basic installation type to download Microsoft SQL Server Express and all related utilities.

    SQL Server 2019 Express Edition Basic installation selection

  4. Accept the license terms and conditions. Keep the default installation location (on the C: drive), then select Install.Installing Microsoft SQL Server Express
    The installer downloads and installs all the required Microsoft SQL Server Express packages. When everything has been installed successfully, a notification page similar to the following displays:
    SQL Server successful installation notification page
    Note: Take note of the Server value in the Connection String field (red box). You need it when installing SOTI Connect
  5. On the successful installation notification page, select the Install SSMS button (yellow box in the screenshot above) to download and install Microsoft SQL Server Management Studio.
  6. When the Microsoft SQL Server Management Studio installation .exe file finishes downloading, run the .exe file. In the installer window, select where you want to install the Microsoft SQL Server Management Studio. Keep the default installation location on the C: drive.
  7. Select Install.

    SQL Server Management Studio main installation page

    When the installation completes, the Setup Completed screen displays.
  8. Close all applications and restart the server or VM.

Configuring Microsoft SQL Server to Work with SOTI Connect

Procedure

  1. Open the Microsoft SQL Server Management Studio.
  2. Establish a connection to the Microsoft SQL Server instance by entering the Server value in the Connection String you noted in Step 4 of the Downloading and Installing Microsoft SQL Server Express and Microsoft SQL Server Management Studio section.
  3. Select Connect.

    SQL Server Connect to Server dialog box

  4. Microsoft SQL Server connects successfully, and the instance name displays.
    SQL Server instance appearing in Object Explorer list
  5. Right-click the instance name and select Properties.

    SQL instance right-click menu with Properties selection highlighted

  6. In the left panel, select Security.
  7. In the Server Properties panel, select SQL Server and Windows Authentication mode in the Server authentication section. Select OK to save your changes.

    SQL Server properties screen with authentication mode selected

  8. Decide whether you want to use a local SQL account or a Windows account for authentication. The following steps describe configuring a local account.
  9. Expand the Security folder and right-click Logins.
  10. Select New Login.

    SQL Server New Login selected

  11. Enter a Login name, in this example Login name is SQLConnect.
  12. Select SQL Server authentication, and create a password for the login.
    Entering a SQL Server password
  13. In the left panel, select Server Roles, select the sysadmin checkbox, and select OK.

    Sysadmin checkbox selected in the New Login screen

  14. A new local login account is created and displays under the Logins header in the left panel.
    List of new SQL logins
    Important: Use this login for your database when you install SOTI Connect.
  15. Ensure NT AUTHORITY\SYSTEM has the sysadmin role assigned to it. Right-click NT AUTHORITY\SYSTEM and select Properties. Select the sysadmin checkbox under Server Roles.
    Note: Use this login if installing SOTI Connect using Windows Authentication. If the database runs on a remote server, the login is not be NT Authority\System. It is MachineName$ (for example, domainname\computername).
  16. Keep Microsoft SQL Server Management Studio running, then run the Microsoft SQL Server Configuration Manager utility, included as part of Microsoft SQL Server Express.
  17. In the Microsoft SQL Server Configuration Manager utility, expand SQL Server Network Configuration and select Protocols for SQLEXPRESS.
    Note: Select the correct protocol for your SOTI Connect instance if it is different the Protocols for SQLEXPRESS.

    SQL Server protocol screen

  18. Right-click the TCP/IP protocol and enable the TCP/IP protocol.
  19. Right-click the TCP/IP protocol again and then select Properties. The TCP/IP Properties panel displays.
  20. In the TCP/IP Properties panel, select the IP Addresses tab, empty any IP TCP Dynamic Ports fields and set the IPAII TCP Port to 1433.
    Selection screen for TCP/IP protocol
  21. Select Apply, then select OK.
  22. Restart your Microsoft SQL Server instance and Microsoft SQL Server Management Studio to apply your changes.

SQL Server Security Notes

The following information discusses securing access to the database and minimizing permissions.

The installation of SOTI Connect, requires more database privileges than needed for normal working operation. You should reduce the level of access after the installation of Microsoft SQL Server is complete. Use the following table as a reference to the required access levels after the installation is complete.

OperationRequired Database Privileges
Installing or upgradingSysadmin. The SA account is a super admin with permissions for any scenario.
Normal working operationdb_owner.
Service running as local system with DB installed on the same serverLocal System > NT AUTHORITY\System.

The service runs on the computer with this permission.

Note: NT needs Sysadmin during an upgrade.
Service running as local system with the DB installed on a remote serverdb_owner.

UsingMicrosoft SQL Server, add the user or the group containing the user to the db_owner role.

Note: The database does not use the local system or NT AUTHORITY\System, but becomes MachineName$ (for example, domainname\computername).
Service running as a service accountEnsure the user account is also in the DB as an account with the correct permissions.

For example, if the user account samplecompany/ConnectMDM is running the service, ConnectMDM with the domain samplecompany, the account must be given the needed permissions.

If you used the Microsoft SQL Server authentication option (for example, when you created the SQLConnect login in the example above), you should remove the sysadmin role after completing the SOTI Connect installation. You should also confirm that the SQLConnect login has db_owner user mappings for all the SOTI Connect databases.

Note: You must restore the sysadmin role to the SQLConnect user before running the SOTI Connect installer again.

If you used the Windows authentication method to install SOTI Connect, you should remove the sysadmin role from the NT AUTHORITY/SYSTEM login. You should also confirm that this login has db_owner user mappings for all the SOTI Connect databases.

Microsoft SQL Server stores the SOTI Connect databases. Creating, updating, and deleting a database is associated with its owner service. When uninstalling SOTI Connect, you can either retain all the databases or just the 'SOTIConnectDeviceStateHistory' and 'SotiConnectLoggingService' databases.
Important: Due to the possible encryption of some files, you must retain the File Store database to keep access to File Store files after uninstalling SOTI Connect.

You should also remove the sysadmin role from the user who ran the SOTI Connect installer. You must restore the sysadmin role to that user before running the SOTI Connect installer again.


===============================================================


"This Content Sponsored by SBO Digital Marketing.

Mobile-Based Part-Time Job Opportunity by SBO!

Earn money online by doing simple content publishing and sharing tasks. Here's how:

  • Job Type: Mobile-based part-time work
  • Work Involves:
    • Content publishing
    • Content sharing on social media
  • Time Required: As little as 1 hour a day
  • Earnings: ₹300 or more daily
  • Requirements:
    • Active Facebook and Instagram account
    • Basic knowledge of using mobile and social media

For more details:

WhatsApp your Name and Qualification to 7338068894

a.Online Part-Time Jobs from Home

b.Work from Home Jobs Without Investment

c.Freelance Jobs Online for Students

d. Mobile-Based Online Jobs

e.Daily Payment Online Jobs

Keyword & Tag: #OnlinePartTimeJob #WorkFromHome #EarnMoneyOnline #PartTimeJob #jobs #jobalerts #withoutinvestmentjob"



Youtube Channel Image
Nadaipazhagu Tamizhaa Subscribe To watch Videos
Subscribe