Close

windows

SQL Server 2016 Cluster – Partially Running – CEIP

SQL Server 2016 Cluster – Partially Running [half red/half green] – came across below issue, and upon further investigation l noticed the nodes has CEIP versions of Analysis services as well as Agent. Simply removing these roles, returned the server roles status to running/green   Click here for reference link on msdn.microsoft forum Click here […]

Read More

Active Directory Creation On Windows Server 2016

Active Directory Creation On Windows Server 2016 – using a Virtual Machine running under Windows 10 Pro Hyper-V Screenshots:   DNS:     AD should now be functional, for other servers to join this domain. Note, most core production servers use static ip addresses , and not dynamic/DHCP as might be seen in the screenshots […]

Read More

Powershell – Stopping a Microsoft Windows Service

In this example, l will attempt to get and stop a windows service for say, SQLdefragmanagementservice. First open a windows powershell console, using the run as administrator below. Use the get-process to get the process id. Use the stop-process to kill the windows process/service. Then run the code shown in the screenshot below, modify as […]

Read More