“Changing the Primary Domain DNS Name of this Computer Failed” – Server 2008 R2
Within an AWS account I have a Windows Server 2016 Domain Controller, and I’m trying to join a Windows Server 2008 R2 to my Whyte.net Domain.
Hi!… I’m Peter Whyte.
Hello and welcome to my website, which is a place for me to store all my notes as I blog away as a software enthusiast.
My area of interest very much revolves around Database Administration (DBA), so there will be a lot of RDMS related posts on here, particularly SQL Server.
It’s been an amazing journey working away at this blog which I started in January 2017. Like anything, practise makes perfect. My hope is to continue to improve my writing and all the other skills required to run a blog. It’s been a long and fun journey so far… and I feel like I’m just getting started!
I hope you enjoy, and feel free to comment on posts or write me a line any time. I’d apprecaite any critique or feedback you may have.
Cheers,
Pete
Recent Posts
Testing Connectivity to Remote Server Ports with PowerShell
All admins need a tool to test connectivity to remote servers on TCP ports. In Windows, this is commonly done using PuTTy or PowerShell.
Forcing Encryption in SQL Server
If you’re ever planning to allow external connections to a SQL Server, one of the first things to ensure is that the data is encrypted at rest and in-transit.
Include Execution Trace Messages in SQL Server Error Logs
Logs are always important if you’re supporting systems. The SQL Server Agent has always been a heavily used tool in my experience, so writing execution trace messages to the logs might help investigate an issue one day.
Backing up a SQL Server Database with Encryption
Backing up a SQL Server Database with Encryption is the secure way of performing your SQL Server backups. If you’re ever worried about the data within your databases, you may consider this option when performing database backups.
Backing up a SQL Server Certificate
It’s important to backup SQL Server Certificates, but only if you’re using them really. If for example, your SQL Server database backups are encrypted and you need to restore it on another server, then you will need both the certificate and private key that was used.
