windows - DBplatz

windows

A collection of 9 posts

HomeLab: Creating a domain account and users.

HomeLab: Creating a domain account and users.

In a previous article we saw how to create a domain controller, now let's create domain users. Let's click on Start and then Server Manager. Go to Tools and then to Active Directory Users and Computers. Click on the domain (netplatz) and then go to users and right-click User. Provide

HomeLab: Creating a Domain Controller on Windows 2019.

HomeLab: Creating a Domain Controller on Windows 2019.

Now that we know how to create a VM using Hyper-V, let's configure a domain controller which is required for our HomeLab SQL Server Always On installation. There is a really helpful guide already here, but I'll be using Windows 2019 instead. So, once our VM is up and running,

HomeLab: Creating a Windows 2019 Virtual Machine with Hyper-V

HomeLab: Creating a Windows 2019 Virtual Machine with Hyper-V

Today, I'm creating a new Windows 2019 VM using Hyper-V for my home lab. The goal is to create a new SQL Server AlwaysOn and FCI cluster for testing. So let's see how we can start just creating a VM for my domain controller (DC). Official docs are here Open

PostgreSQL - default superuser privileges were removed.

PostgreSQL - default superuser privileges were removed.

Last week a colleague contacted me about a PostgreSQL installation where the privileges of the postgres user suddenly "disappeared". I searched around a bit and found this really useful article in stackoverflow. However, his server was Windows, so I tried and replicated this issue on a Windows 2019 server. First

SQL Server - SSMS exiting immediately after showing the splash screen.

SQL Server - SSMS exiting immediately after showing the splash screen.

Last year, I installed SQL Server Management Studio 18.0 on a server tested the connection to the SQL Instance and everything looked OK. SSMS was exiting immediately after showing the splash screen. But months later, I tried again and SSMS was not starting. To troubleshoot this, let's cd to

SQL Server - Could not find the Database Engine Startup handle.

SQL Server - Could not find the Database Engine Startup handle.

A few weeks ago I had the task to install SQL Server 2014 Express Edition and SQL Server Management Studio (SSMS) 18.4 and what it was going to be no more than an hour ended in a 16 hours change. Actually, I did install successfully one of the servers,

SQL1397N The Db2 service failed to logon.

SQL1397N The Db2 service failed to logon.

I always install a free version of Db2 on my laptop so I can play a bit in a really safe environment without breaking the real ones. Db2 Express-c has been replaced by the Db2 Community Edition So a few days ago I tried to start my Db2 instance for

How to install SQL Server Management Studio (SSMS).

How to install SQL Server Management Studio (SSMS).

In this post, we will install SQL Server Management Studio on a Windows Server 2019. We've downloaded the installation from here SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. So once the installation file is on the

How to install SQL Server 2019 on Windows Server 2019.

How to install SQL Server 2019 on Windows Server 2019.

In a previous post, we learned about installing Db2. Now I'm installing SQL Server. I've download SQL Server Developer Edition from here. However, now you don't get the ISO or installation files anymore, what you get is a downloader. So, If the target server does not have access to the