Darien's Tips
Darien's Tips
  • 39
  • 57 458
MSSQL Server Installation on Windows Server Core
In this video, I’ll demonstrate how to install Microsoft SQL Server on a server system running Windows Server Core (no GUI). As a bonus, I’ll quickly cover the installation of Windows Admin Center and how to use it to easily manage a Windows Server Core instance from any client system via a modern web browser.
Applies to:
Windows Server 2019 server core, Windows Server 2022 server core, Windows Server 2025 server core, Microsoft SQL Server 2019, Microsoft SQL Server 2022
Glossary:
AD = Active Directory
DBMS = Database Management System
gMSA=Group Managed Service Account
GUI = Graphical User Interface
ICMP = Internet Control Message Protocol
NTFS = New Technology File System
ODBC=Open Database Connectivity
SQL = Structured Query Language
SQL = Structured Query Language
Chapters
0:00 Introduction
0:43 Requirements
1:41 Interactive Graphical Interface Installation
4:48 Using Mounted Folders
6:06 Unattended Installation Using a Configuration.ini File
7:22 Post Installation
8:34 Manage SQL Server from Client Workstation
10:11 Manage Windows Server Core (BONUS)
11:23 Thank you for watching!!
Links:
• learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-on-server-core?view=sql-server-ver16
• learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates
• learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2022/cumulativeupdate13
• learn.microsoft.com/en-us/windows-server/get-started/whats-new-windows-server-2025
• www.catalog.update.microsoft.com/Search.aspx?q=KB5036432
• www.microsoft.com/en-us/evalcenter
Переглядів: 121

Відео

Unlock a BitLocker Volume Using the Windows Recovery Environment WinRE or a Windows OS Installation
Переглядів 92814 днів тому
In this video, we’ll cover how to gain access to the C: volume when protected with BitLocker Encryption when the target computer is stuck in a BSOD (stop error) boot loop. Applies to: Windows 10, Windows 11 Glossary: BDE = BitLocker Drive Encryption BSOD = Blue Screen of Death OS = Operating System WinPE = Windows Preinstallation Environment WinRE = Windows Recovery Environment Chapters 0:00 In...
Install, Configure, and Manage Hyper-V on Windows 10 and Windows 11
Переглядів 551Місяць тому
In this video, we’ll cover the installation, configuration, management, and use of Microsoft Hyper-V on Windows 11. We’ll cover using Hyper-V Manager, PowerShell, and Windows Admin Center to create and manage local Windows and Linux virtual machines. Applies to: Windows 10, Windows 11, Windows Server 2016, Microsoft Hyper-V Server 2016, Windows Server 2019, Microsoft Hyper-V Server 2019, Window...
Create or Restore Windows Recovery Partition
Переглядів 2,7 тис.Місяць тому
In this tutorial, we’ll guide you through the step-by-step process of creating a new Windows Recovery Environment (WinRE) partition, enabling access to native Microsoft recovery and troubleshooting tools. Applies to: Windows 10 (Home, Professional, Enterprise, Education) Windows 11 (Home, Professional, Enterprise, Education) Windows Server 2016, 2019, 2022, 2025 (Standard, Datacenter, server co...
Windows Server 2025 (Server Core) Basic Installation
Переглядів 3642 місяці тому
This video covers a basic, typical installation of Windows Server 2025 server core on a physical server or in a virtual environment. The detailed steps are similar and can be used for Windows Server 2022. For an advanced installation demonstration. For an advanced installation demonstration, see “Windows Server 2022 Advanced Installation.” The installation demonstrated is straightforward, follo...
Configure iSCSI Target Server on Windows Server
Переглядів 4492 місяці тому
In this video, we’ll cover the installation and configuration of the iSCSI Target Server role in Windows Server. We’ll also configure the iSCSI initiator to connect to the iSCSI server from Windows and Linux clients. Applies to: Windows Server 2025, Windows Server 2022, Windows Server 2019, Windows Server 2016, Windows Server 2012 R2. Glossary: ADDS = Active Directory Domain Services CHAP = Cha...
Install Windows 11 Home or Pro without Internet Access or a Microsoft Account
Переглядів 7 тис.2 місяці тому
In this video, I’ll show how to install and complete the setup of Windows 11 Home and Windows 11 Professional editions without Internet access. The steps in this video are native to the OS and do not require or use any unauthorized methods. Applies to: Windows 11 Home, Windows 11 Professional, Windows 11 Professional for Workstations Glossary: BAT = Batch (batch file) CMD = Command GUI = Graphi...
Create Windows Install USB Drive
Переглядів 7583 місяці тому
In this video, we will cover the steps to create a bootable Windows USB device that will boot into either a UEFI or BIOS-based system, including those with Secure Boot enabled. This process uses native Windows tools; no third-party tools or applications are necessary. Applies to: Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 11, Windows Server 2008 R2, Windows Server 2012, Windows Serv...
Windows Memory Diagnostic
Переглядів 4633 місяці тому
The Windows Memory Diagnostic tool is a built-in feature available in the latest Windows 11 operating systems. It can conduct a RAM test to detect possible problems with your PC's memory. Learn how to use it here. Applies to: Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 11, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019, W...
DaVinci Resolve Studio 19 Beta 1 first look
Переглядів 6053 місяці тому
This is a quick “shallow” dive into a few of the new enhancements in the new DaVinci Resolve Studio 19, Beta 1, which was released on April 12, 2024. Applies to: DaVinci Resolve Studio 19.0.0, Beta 1 Windows 11 Glossary: • DV = DaVinci Resolve • DVS = DaVinci Resolve Studio • FLAC = Free Lossless Audio Codec • MKV = Matroska • MP4 = MPEG-4 Part 14 Chapters 0:00 Introduction 0:18 Fixed Playhead ...
Windows Server 2025, Insider Preview Quick Peek
Переглядів 6023 місяці тому
Windows Server 2025 is here (almost). And here is where we will take a quick peek. Applies to: Windows Server 2025 Chapters 0:00 Introduction 0:30 Installation 1:42 Post Installation 2:30 SSH 4:28 Active Directory 6:17 Desktop Experience 7:28 Thank You! Links: learn.microsoft.com/en-us/windows-server/get-started/whats-new-windows-server-insiders-preview techcommunity.microsoft.com/t5/windows-se...
Determine Disk Type via PowerShell (Quick Tip)
Переглядів 1815 місяців тому
In this quick-tip video, learn how to tell if an installed disk(s) is either an SSD or an HDD by using the native PowerShell CMDLET Get-PhysicalDisk.
Windows 11 23H2 Is Here! And this is how you can get it.
Переглядів 5838 місяців тому
Windows 11 23H2 is official, and it is here! And this video will show how to get it. Chapters 0:00 Introduction 0:18 How to Get 23H2 1:08: What’s New in 23H2 1:30: How to Check 2:04: Links and Thank You! 2:15 Please Like and Subscribe Credits: Lonesome Journey by Keys of Moon | soundcloud.com/keysofmoon Attribution 4.0 International (CC BY 4.0) creativecommons.org/licenses/by/4.0/ Music promote...
DaVinci Resolve Tips - Advanced Effects on Title Text and Generators
Переглядів 7249 місяців тому
🎬 In This Tutorial: Unlock the hidden potential of your video titles and generators! Dive into the innovative world of DaVinci Resolve, where I’ll show you how to seamlessly integrate stunning Fusion and OpenFX plugin effects - from dramatic blurs to transformative warps - directly onto your basic titles and generators. Chapters 0:00 Introduction 0:32 Compound Clip: Title Text 1:15 Edit Title T...
Install Red Hat Enterprise Server 9 2
Переглядів 6429 місяців тому
This video will cover a simple installation of Red Hat Enterprise Server 9.2 with no GUI and without the benefit of a DHCP server. It will also cover “first boot,” updates, and the root account. Applies to: Red Hat Enterprise Linux 8, Red Hat Enterprise Linux 9, Oracle Enterprise Linux 8, Oracle Enterprise Linux 9, Rocky Linux 8, Rocky Linux 9, CentOS Stream 8, CentOS Stream 9 Glossary: CIDR = ...
Create a Custom WinPE Image Using Windows ADK with the WinPE Add-On
Переглядів 8 тис.10 місяців тому
Create a Custom WinPE Image Using Windows ADK with the WinPE Add-On
Windows Notepad Now Has Session Persistence
Переглядів 15110 місяців тому
Windows Notepad Now Has Session Persistence
Windows 11, 23H2 Quick Peek
Переглядів 3,4 тис.10 місяців тому
Windows 11, 23H2 Quick Peek
Storage Spaces, Windows 11 22H2
Переглядів 6 тис.10 місяців тому
Storage Spaces, Windows 11 22H2
Windows Server 2022 (Desktop Experience) Basic Installation
Переглядів 7 тис.10 місяців тому
Windows Server 2022 (Desktop Experience) Basic Installation
Storage Spaces, Windows Server 2022 21H2
Переглядів 4,7 тис.11 місяців тому
Storage Spaces, Windows Server 2022 21H2
Export, Import, and Migrate WSL and WSL2 Installations
Переглядів 1,1 тис.Рік тому
Export, Import, and Migrate WSL and WSL2 Installations
Mount a Drive or Volume to an NTFS Folder in Windows 11 and Windows 10
Переглядів 1,5 тис.Рік тому
Mount a Drive or Volume to an NTFS Folder in Windows 11 and Windows 10
Windows 11, OS Build 22621.1344 (What's New)
Переглядів 298Рік тому
Windows 11, OS Build 22621.1344 (What's New)
Windows Subsystem for Linux, WSL Installation on Windows 10, 11, and Server 2022
Переглядів 1,3 тис.Рік тому
Windows Subsystem for Linux, WSL Installation on Windows 10, 11, and Server 2022
What's New in Windows 11 Dev Channel (Tabbed Notepad)
Переглядів 121Рік тому
What's New in Windows 11 Dev Channel (Tabbed Notepad)
Windows Server 2022 Advanced Installation.
Переглядів 735Рік тому
Windows Server 2022 Advanced Installation.
Installation of Ubuntu Server 22.04 LTS, Server Without a GUI
Переглядів 2,9 тис.Рік тому
Installation of Ubuntu Server 22.04 LTS, Server Without a GUI
How to Properly Remove the Windows.old Folder Following an OS Upgrade
Переглядів 167Рік тому
How to Properly Remove the Windows.old Folder Following an OS Upgrade
Extend Ubuntu ext4 Partition TEST/DEMO
Переглядів 4582 роки тому
Extend Ubuntu ext4 Partition TEST/DEMO

КОМЕНТАРІ

  • @Li1Th3ia
    @Li1Th3ia День тому

    The people who already downgraded or didn’t upgrade : 😦

    • @Li1Th3ia
      @Li1Th3ia День тому

      I don’t know why I said that though-

  • @nathanphillips6423
    @nathanphillips6423 7 днів тому

    You put me to sleep with your long drawn out monotone voice

  • @everythingelse.6169
    @everythingelse.6169 10 днів тому

    So it's actually possible to add disks of different sizes to the existing pool !!

  • @avanap8096
    @avanap8096 15 днів тому

    Shut up bot

    • @darienstips9409
      @darienstips9409 9 днів тому

      Cylon bot number 1 says , "by your command." :)

  • @avanap8096
    @avanap8096 15 днів тому

    👎

  • @TATO-H2O
    @TATO-H2O 16 днів тому

    any change you have the commands? as text file etc?

  • @BillMullen-t2w
    @BillMullen-t2w 17 днів тому

    Great demonstration of the topic! Thank you!

  • @paulwarner5395
    @paulwarner5395 21 день тому

    Thanx for the video. Are the 3 security questions new in 24H2??

  • @flowkoko
    @flowkoko 28 днів тому

    I cant boot into the WinRE, it gets interrupted by a STOP CODE page error PROCESS1 INITIALIZATION FAILED. please help

  • @jonsnoff5369
    @jonsnoff5369 Місяць тому

    This worked wonders! Thanks a bunch :)

  • @mazz85-
    @mazz85- Місяць тому

    Yikes, this one is tricky, but anything is better than to deal with the not wanted "features". I just want my OS clean as possible for gamin.

  • @mazz85-
    @mazz85- Місяць тому

    BTW, this is the proper speed for tutorial, nicely done. Disslike the adhd ones, that are like Roadrunners versus mr Coyote.

  • @mazz85-
    @mazz85- Місяць тому

    Do we add DirectX for gaming ?

  • @mazz85-
    @mazz85- Місяць тому

    Does it matter if you are installing into Intel ? Couse your code says AMD.

  • @mazz85-
    @mazz85- Місяць тому

    If this one can use Battlenet, then this might be the thing for me. Steam and Origin are secondary to World of Warcraft. For example when the servers are down, i play other games, or when i just need a breathe.

  • @fbifido2
    @fbifido2 Місяць тому

    can you setup a full business domain network using only server 2025 core? none of the servers should have a GUI. - a domain controller - a file and printer server - ADCS - SQL Server - etc ....

    • @darienstips9409
      @darienstips9409 Місяць тому

      Yes. I'll have a video coming out soon detailing setting up a domain using Server core. Keep an eye out! :)

    • @darienstips9409
      @darienstips9409 9 днів тому

      See installation of SQL Server on Server Core. ua-cam.com/video/kipCxa9c2ZM/v-deo.html. Domain controller and others coming soon.

  • @Completely_Incomplete
    @Completely_Incomplete Місяць тому

    What happens if you lose access to Windows. Is it possible to just reinstall windows and recover the pools/virtual drives and restore data?

  • @Completely_Incomplete
    @Completely_Incomplete Місяць тому

    Is there a way to monitor the storage spaces for physical drive failure or other virtual failures without physically logging into windows. Something proactive that will generate alerts or email.

  • @Jaryl-xt7ql
    @Jaryl-xt7ql Місяць тому

    Help. It still forces me o connect to the internet. There's no 'I dont have internet' option

    • @garryclark9959
      @garryclark9959 3 дні тому

      if you shut down your internet first while installing it will detect that you dont have net and will or should (as in the past) detect you dotn have a net connection adn should auto proceed from there, idk what it is your trying to install but in my experiences and based on past experiences i would dissconnect my pc from my internet by unpluggin the cable (now adays we have mobos with build in wifi cards) so now adays one "could" shut off they router/modem temperarely, or even disable the wifi card via bios to get through this aspect would just have to remember to re enable afterward

  • @breakingtwitting
    @breakingtwitting Місяць тому

    love windows server . seems much less bloated than desktop version

  • @SaiyanParmos
    @SaiyanParmos 2 місяці тому

    That was amazing....

  • @isaacbarahonahidalgo9427
    @isaacbarahonahidalgo9427 2 місяці тому

    Great tutorial, thank you very much. One question, do you know how to add SSD tier caching to a new pool?

  • @brianbourassa7602
    @brianbourassa7602 2 місяці тому

    Might have been a great tutorial except that ALL the syntax/cmds should have been included as a text file or some copy-able text. It's a LOT to read and retype from screen video!

  • @thorbennielsen3845
    @thorbennielsen3845 2 місяці тому

    What about adding cache drive?

  • @techexprt1
    @techexprt1 2 місяці тому

    This feature is much better than the Hardware RAID, I had many hardware arrays that failed and never rebuilt proeprly, because the controller does not work as expecetd or goes bad for no reason and very slow. HARDWARE RAID IS DEAD !

  • @franciscofilho330
    @franciscofilho330 2 місяці тому

    Thank u!

  • @kmomarfarooque
    @kmomarfarooque 2 місяці тому

    Your lecture was so easy to follow and very helpful . thank you so much.

  • @kenteague6542
    @kenteague6542 3 місяці тому

    Thanks, Darien! This video is very helpful.

  • @ThePatrykolus
    @ThePatrykolus 4 місяці тому

    Thank you for telling me to unregister when I didn't really mean to - I just lost my WSL, as I did it in wrong order. Jeeez, this command is dang stupid - how could anyone name REMOVE/DELETE option "unregister". Microsoft WTF? And no damn prompt. No chances to recover as I have no backup nor restore. Great.

  • @do98swfm15
    @do98swfm15 4 місяці тому

    Thanks for the good video, and I want to know the process of making Windows 11 Explorer, taskbar, and start menu appear in PE created like this. In addition, the Recyclebin icon and This PC icon are visible on the desktop.

  • @juanpablomezagazabon9238
    @juanpablomezagazabon9238 4 місяці тому

    thanks u so mucho bro!

  • @TechEvolutionUSA
    @TechEvolutionUSA 4 місяці тому

    Great video!

  • @joerebis2063
    @joerebis2063 5 місяців тому

    Okay, but how do you make the system drive redundant? You have to install windows on a drive in the first place in order to get to these screens to create a storage space and the primordial storage only seems to contain all of the other drives. How do you make the system drive redundant if you're just looking for some basic redundancy?

    • @TEverettReynolds
      @TEverettReynolds 2 місяці тому

      He said it at @1:04. He had 2 x 254 GB disks in Raid 1.

    • @joerebis2063
      @joerebis2063 2 місяці тому

      ​@@TEverettReynolds I meant using storage spaces. Is that possible?

    • @Completely_Incomplete
      @Completely_Incomplete Місяць тому

      ​@@joerebis2063 don't think this is possible using storage spaces but you could use traditional Windows Mirroring in Disk Management

    • @joerebis2063
      @joerebis2063 Місяць тому

      @@Completely_Incomplete Thank you, I have just heard that it is potentially pretty slow and that might be an issue on the system drive. I run NVME capable RAID cards on other larger servers that I have but that's too expensive for a commodity server. My guess I am just trying to figure out what everybody is doing for system drive redundancy in an NVME environment in an AMD system without an external card. I used to use Intel RAID on Chip (ROC Chip) but it requires Intel CPUs and might still pose a bottle neck for NVME throughput.

    • @Completely_Incomplete
      @Completely_Incomplete Місяць тому

      @@joerebis2063 I don't see how Mirroring using Windows (not storage spaces) would be any slower than just running a single drive. If it was Raid5 I'd understand that performance wouldn't be great. But with raid 1 you get double the safety and no advantage or disadvantage to speed.

  • @ultraali453
    @ultraali453 5 місяців тому

    Amazing Tutorial. Thank you for putting so much effort into this!

  • @NotoriousJP4
    @NotoriousJP4 5 місяців тому

    Not even an option to install the desktop experience. What am I doing wrong?

  • @NotoriousJP4
    @NotoriousJP4 5 місяців тому

    I don't have GUI, only CMD. What is the issue.

  • @JieHouJessie
    @JieHouJessie 6 місяців тому

    I have intel I226v network adapter and it isn’t recognized in windows server 2022. Latest intel network adapter driver for windows server 2022 doesn’t support it neither. What should I do with a pc with no internet?

  • @d.p1304
    @d.p1304 6 місяців тому

    Thanks a lot

  • @bulcub
    @bulcub 7 місяців тому

    Very nice explaining DETAIL setup of 2022

  • @gorbynr1
    @gorbynr1 7 місяців тому

    Why would you not use refs?

  • @JB_inks
    @JB_inks 8 місяців тому

    Nice one

  • @sunyclubband4203
    @sunyclubband4203 8 місяців тому

    I whis there was a tutorial of how to use every tool in davinci resolve, Nice vid by the way

  • @CoreyKennington
    @CoreyKennington 8 місяців тому

    Great job. Nice overview

  • @markpavlowski7223
    @markpavlowski7223 9 місяців тому

    First, scrap all your old hardware...then continue...

  • @pixelrancher
    @pixelrancher 9 місяців тому

    Cool.

  • @twd2
    @twd2 9 місяців тому

    Bro, I have all of these features onWindows 11 Pro / Version 22H2 / OS build 22621.2428

    • @darienstips9409
      @darienstips9409 9 місяців тому

      You are right. MSFT somewhat pushed back the 23H2 update and added most of the features to KB5030310, released September 26, 2023. support.microsoft.com/en-us/topic/september-26-2023-kb5030310-os-build-22621-2361-preview-363ac1ae-6ea8-41b3-b3cc-22a2a5682faf

  • @AdmV0rl0n
    @AdmV0rl0n 10 місяців тому

    Nice work - good video!

  • @terencealbertmcbain8041
    @terencealbertmcbain8041 10 місяців тому

    When does this new build come out?

    • @darienstips9409
      @darienstips9409 10 місяців тому

      KB5030310 came out 26 Sept. For some computers, it provided the enhancements in the video. For others, only a subset. However, KB5030310 is only build 22621.2361, which is sill 22H2. As to when 23H2 is coming out, that still seems to be up in the air.

  • @LandoTech
    @LandoTech 10 місяців тому

    Amazing content Darien

  • @philipodonnell494
    @philipodonnell494 10 місяців тому

    Promo-SM 😒