![How to create a new Azure SQL Database [PaaS]](https://techdirectarchive.com/wp-content/uploads/2025/12/create-a-new-Azure-SQL-Database-1.jpg)
In this article, we shall discuss “how to create a new Azure SQL Database [PaaS]” using the Azure Portal, highlighting the key steps, the most relevant configuration options, and the architectural considerations to keep in mind from the very beginning. Please, see How to create a two-way Active Directory Trust, [AZURE] Restore MSSQL Server on…
Running outdated SQL Server versions exposes your business to security risks, performance issues, and compliance gaps. Microsoft no longer supports some older SQL Server editions, leaving systems unpatched and vulnerable. Upgrading to SQL Server 2025 ensures protection, stability, and access to the latest features. In this article, we shall discuss how to Install all Editions…
Read More “How to Install all Editions of Microsoft SQL Server 2025” »
It is interesting to note that SQL Server 2025 (17.x) builds on previous releases to grow SQL Server. This enables you to use your choices of development languages, data types, on-premises or cloud environments, and operating system. In this article, we shall discuss “SQL Server 2025 upgrade Requirements and Compatibility”. Please, see How to upgrade…
Read More “SQL Server 2025 Upgrade Requirements and Compatibility” »
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 BitLocker Administration and Monitoring (MBAM) provides a simplified administrative interface that you can use to manage BitLocker Drive Encryption. Therefore, customers find this solution very useful for managing client PCs with BitLocker that are domain-joined on-premises. In this article, we shall discuss how to Get MBAM BitLocker Recovery Keys from Microsoft SQL Server. Please…
Read More “Get MBAM BitLocker Recovery Keys from Microsoft SQL Server” »
The SQL Auto Close feature automatically closes inactive database connections after a specified period of inactivity. By default, auto close is enabled but Trellix does not like this behaviour. In this article, we will discuss the fix to “Disable SQL Auto Close: Auto Close is enabled for both ePO and ePO Events Databases”. Please see…
Read More “Disable SQL Auto Close: Auto Close is enabled for both ePO and ePO Events Databases” »
When setting up SQL and configuring some applications. The following error might be prompted “Setup is unable to access the SQL UDP port 1434 on the specified SQL server”. This means that the setup requires access to the SQL UDP port 1434 to retrieve the TCP port assignment information from the SQL server. Please see…
Read More “Setup is unable to access the SQL UDP Port 1434 on the specified SQL Server” »
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” »
An SQL Server instance is a complete SQL server and you can install many instances on a machine but you can have only 1 default instance. It represents a separate and independent database environment that can store and manage data. In this article, I will teach you how to verify if the xp_cmdshell feature is enabled or disabled in…
Read More “How to verify whether the xp_cmdshell feature is enabled or disabled in MSSQL Server” »
![Fix a network-related or instance-specific error occurred while establishing a connection to SQL Server [Part 2]](https://techdirectarchive.com/wp-content/uploads/2023/11/Fix-Network-related-MSSQL-instance-error.jpg)
Realistically, this is a rather frequent error error message. We shall learn how to “fix a network-related or instance-specific error occurred”. This error could mean different things as there is no one solution that fits all. Please see how to Migrate Your WordPress Site with WordPress Duplicator, how to Fix Spell Check Not Working in…
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…
