Category: Oracle/MSSQL/MySQL

Oracle, MSSQL, and MySQL are powerful relational database management systems (RDBMS) widely used for managing, storing, and querying data in enterprise and web applications. Each offers unique features suited for different scales and environments

Install DBeaver on macOS: Connect to PostgreSQL Database

Posted on Christian By Christian No Comments on Install DBeaver on macOS: Connect to PostgreSQL Database
Install DBeaver on macOS: Connect to PostgreSQL Database

DBeaver is  a free and open source database management tool for Windows, Linux and Mac OS X designed utilized by developers, system administrators, database admins etc. It supports a wide range of databases, including popular ones like MySQL, PostgreSQL, SQLite, and Oracle. In this short article, we shall discuss how to “Install DBeaver on macOS: Connect to…

Read More “Install DBeaver on macOS: Connect to PostgreSQL Database” »

Oracle/MSSQL/MySQL

Fix An error has occurred during report processing (rsProcessingAborted)

Posted on Christian By Christian No Comments on Fix An error has occurred during report processing (rsProcessingAborted)
Fix An error has occurred during report processing (rsProcessingAborted)

MBAM Report Users can access the Compliance and Audit reports in the MBAM administration website. The local group for this role is installed on the Administration and Monitoring Server, Compliance and Audit Reports Server, and Compliance Status Database Server. In this article, we shall discuss how to resolve the “Fix An error has occurred during…

Read More “Fix An error has occurred during report processing (rsProcessingAborted)” »

Oracle/MSSQL/MySQL, Windows Server

Change SQL Database Collation: ePO events DB and SQL server should match with ePO core collation

Posted on Christian By Christian No Comments on Change SQL Database Collation: ePO events DB and SQL server should match with ePO core collation
Change SQL Database Collation: ePO events DB and SQL server should match with ePO core collation

In SQL Server, collations dictate the sorting rules, case sensitivity, and accent sensitivity properties for your data types such as char and varchar. They determine the code page and corresponding characters that can be represented for those data types. “In this article, we will discuss this error message “Change Database Collation: EPO core collation is…

Read More “Change SQL Database Collation: ePO events DB and SQL server should match with ePO core collation” »

Oracle/MSSQL/MySQL

Disable SQL Auto Close: Auto Close is enabled for both ePO and ePO Events Databases

Posted on Christian By Christian No Comments on Disable SQL Auto Close: Auto Close is enabled for both ePO and ePO Events Databases
Disable SQL Auto Close: Auto Close is enabled for both ePO and ePO Events Databases

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” »

Oracle/MSSQL/MySQL

Configure SQL Server Instance to listen on a specific TCP Port

Posted on Christian By Christian No Comments on Configure SQL Server Instance to listen on a specific TCP Port
Configure SQL Server Instance to listen on a specific TCP Port

In this blog post, we shall discuss how to Configure SQL Server Instance to listen on a specific TCP Port using SQL Server Configuration Manager. The default instance of Microsoft SQL Server listens on TCP Port 1433. This is the default port for communication between Microsoft SQL Server and its applications. Here is a similar…

Read More “Configure SQL Server Instance to listen on a specific TCP Port” »

Oracle/MSSQL/MySQL

How to upgrade Microsoft SQL Server 2019 to 2022

Posted on Christian By Christian No Comments on How to upgrade Microsoft SQL Server 2019 to 2022
How to upgrade Microsoft SQL Server 2019 to 2022

In this article, we will discuss the steps on how to upgrade Microsoft SQL Server 2019 to 2022. Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. This upgrade process is the same as when upgrading from Microsoft SQL server 2017 to 2019 and so on. Please see how does DELL…

Read More “How to upgrade Microsoft SQL Server 2019 to 2022” »

Oracle/MSSQL/MySQL

How to encrypt Microsoft SQL Server Traffic

Posted on Christian By Christian No Comments on How to encrypt Microsoft SQL Server Traffic
How to encrypt Microsoft SQL Server Traffic

In this article, we will discuss how to encrypt Microsoft SQL Server Traffic. You can encrypt all incoming connections to SQL Server or enable encryption for just a specific set of clients. For either of these scenarios, you first have to configure SQL Server to use a certificate that meets Certificate requirements for SQL Server before taking…

Read More “How to encrypt Microsoft SQL Server Traffic” »

Oracle/MSSQL/MySQL

Setup is unable to access the SQL UDP Port 1434 on the specified SQL Server

Posted on Christian By Christian No Comments on Setup is unable to access the SQL UDP Port 1434 on the specified SQL Server
Setup is unable to access the SQL UDP Port 1434 on the specified SQL Server

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” »

Oracle/MSSQL/MySQL

Install SQL Server 2022 Express and SQL Server Management Studio

Posted on Christian By Christian No Comments on Install SQL Server 2022 Express and SQL Server Management Studio
Install SQL Server 2022 Express and SQL Server Management Studio

This article will discuss how to install SQL Server 2022 Express and SSMS Tool (SQL Server Management Studio). The SQL Server Express edition is the entry-level, free database that is ideal for learning and building desktop and small server data-driven applications. It is the best choice for independent software vendors, developers, and hobbyists building client…

Read More “Install SQL Server 2022 Express and SQL Server Management Studio” »

Oracle/MSSQL/MySQL

Change from SQL Server and Windows Authentication Mode to Windows authentication Mode

Posted on Christian By Christian No Comments on Change from SQL Server and Windows Authentication Mode to Windows authentication Mode
Change from SQL Server and Windows Authentication Mode to Windows authentication Mode

SQL Server supports two authentication modes: Windows Authentication Mode and Mixed Mode (Windows Authentication and SQL Server Authentication). These modes determine how users connect to the SQL Server instance and authenticate their identity. In this article, we shall discuss how to change  change the server authentication mode “SQL Server and Windows Authentication Mode” in SQL…

Read More “Change from SQL Server and Windows Authentication Mode to Windows authentication Mode” »

Oracle/MSSQL/MySQL

Resolve “no pg_hba.conf entry for host on PostgreSQL

Posted on Christian By Christian No Comments on Resolve “no pg_hba.conf entry for host on PostgreSQL
Resolve “no pg_hba.conf entry for host on PostgreSQL

The “pg_hba.conf” entry for a host on a Windows system. The “pg_hba.conf” file in PostgreSQL is crucial for managing client authentication. Specifying which hosts are allowed to connect to the database server. In this article, we shall discuss how to Resolve “no pg_hba.conf entry for host on PostgreSQL. Please see How to install PostgreSQL on…

Read More “Resolve “no pg_hba.conf entry for host on PostgreSQL” »

Oracle/MSSQL/MySQL

Migrate Veeam Configuration Database to PostgreSQL Server

Posted on Christian By Christian No Comments on Migrate Veeam Configuration Database to PostgreSQL Server
Migrate Veeam Configuration Database to PostgreSQL Server

To migrate the Veeam Backup & Replication configuration database from Microsoft SQL Server to PostgreSQL, create a new configuration backup and restore it on the PostgreSQL instance. This process enables continued use of the same Veeam Backup & Replication server, now connected to a configuration database on PostgreSQL instead of Microsoft SQL Server. In this…

Read More “Migrate Veeam Configuration Database to PostgreSQL Server” »

Backup, Oracle/MSSQL/MySQL

Install PostgreSQL on Windows server as Veeam Database Engine

Posted on Christian By Christian No Comments on Install PostgreSQL on Windows server as Veeam Database Engine
Install PostgreSQL on Windows server as Veeam Database Engine

Starting from Veeam Backup & Replication v12, the PostgreSQL database can be used instead of Microsoft SQL Server. It will interest you to know that, this default installation comes with PostgreSQL. PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, macOS, Solaris), and Windows. In this article, you will learn how to…

Read More “Install PostgreSQL on Windows server as Veeam Database Engine” »

Oracle/MSSQL/MySQL