In this article, we shall discuss how to Install SQL Server Management Studio 21 on Windows Server. SSMS 21 can be installed via the “Visual Studio Installer.” Microsoft’s shift to using the Visual Studio-style installer for tools like SSMS 21 as highlighted during Microsoft Build. This reflects a broader strategy on unified experience, and also…
Read More “Install SQL Server Management Studio 21 on Windows Server” »
SQL Server Management Studio (SSMS) is a powerful tool for managing SQL infrastructure, from SQL Server to Azure SQL Database. In this guide, we shall discuss how to Install SQL Server Management Studio 20 on Windows Server. Please, see how to Upgrade VBR to 12.3.1: Setup detected inconsistent configuration, how to deploy and integrate VHR…
Read More “Install SQL Server Management Studio 20 on Windows Server” »
Microsoft integrates Configuration Manager into the Intune family of products, offering an integrated solution for managing all devices. This integration simplifies licensing and eliminates the need for complex migrations. Users can continue leveraging their existing Configuration Manager investments while tapping into the capabilities of the Microsoft cloud at their own pace. This is a comprehensive…
Read More “How to install Endpoint Configuration Manager on HyperV VM” »
In Microsoft SQL Server, the “SA” login is a highly privileged account. This is often referred to as the “system administrator” or “superuser” login. In this article, we shall show you how to enable an SA account that has been disabled. Please see How to manage automatic login on Ubuntu Linux, how to fix Unable…
Read More “How to enable an SA account that has been disabled” »
In this article, we will discuss how to fix the Microsoft SQL Evaluation period has expired: How to upgrade SQL Server instance. SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. Please see some related MSSQL guides I have written. What are the differences…
Read More “Microsoft SQL Evaluation period has expired: How to upgrade SQL Server instance” »
In this article, we shall learn how to resolve “Windows could not start the SQL Server service on local computer 17051: A network-related or instance-specific error occurred while establishing a connection to SQL Server”. The SQL Server is a relational database management system from Microsoft. The system is designed and built is to manage and store…
Microsoft SQL Server Management Studio (SSMS) is an integrated environment where you can manage your SQL infrastructure. SSMS can be used to access, configure, manage, administer, and develop all components of SQL Server and Azure SQL Database. Microsoft SQL server management studio is a free software for public use and can be connected to any of your…
You may run into the following error “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. Please see How to install Microsoft SQL Server Management…
In this article, we will learn how to alter a DATABASE compatibility level. Please see some related MSSQL guides I have written. What are the differences between various Editions of Microsoft SQL Server. How to install MSSQL Server 2019 Developer Edition and SSMS on Windows. Database Compatibility Level is a valuable tool to assist in…
In this article, we shall discuss “How to Download and install MSSQL 2019 Express Edition and SSMS on Windows Server”. SQL Server 2019 Express is a free edition of SQL Server, ideal for the development and production of desktop, web, and small server applications. Please see How to use Microsoft SQL Server Management Studio to…
Read More “Download and install MSSQL 2019 Express Edition and SSMS” »
It is worth noting that Microsoft SQL Server 2019 takes full advantage of OpenShift and Linux Containers etc. SQL Server 2019 has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate the same way on Linux. For those who are still wondering about this integration and…
Read More “Install Microsoft SQL Server 2019 and MSSQL Command line tools on Ubuntu Linux” »
Microsoft SQL Server is a relational database management system developed by Microsoft. The primary function of storing and retrieving data as requested by other software applications. In this article, we shall discuss how to fix ‘Unable to connect to MSSQL Server after changing Server name”. See this article for the differences between various Editions of MsSQL…
Read More “Unable to connect to MSSQL Server after changing Server name” »
