----------------------------------------------------------------------- Start of Report ------------------------------------------------------------------------ SQL Server Connectivity Check v1.0.1487.0, run on 10.14.2026 12:49:50 (UTC+02:00) Mitteleuropäische Sommerzeit by the Microsoft CSS SQL Networking Team This report contains the following sections: 1. Computer, Domain, Disk Space, Network Adapters. 2. Client Drivers, SQL Aliases, and Local Security for client connectivity. 3. SQL Server Processes of Interest, Service Account Properties, Service Principal Names, SPN Issues, and Suggested SPNs. --------------------------------------------------------------------- Computer Information --------------------------------------------------------------------- Report run by: DOMAIN\Administrator NETBIOS Name: SERVERNAME FQDN: SERVERNAME.DOMAIN.LOC DNS Suffix: DOMAIN.LOC Windows Name and Edition: Windows Server 2019 Standard (1809) Windows Version: 10.0.17763.9245 Windows Build: 17763 Windows Release ID: 1809 64-Bit System: True .NET 4.x version: 4.8.03761 CLR 4.0 Strong Crypto: 1 CLR 4.0 Strong Crypto x86: 1 .NET 2.x/3.x version: Not installed CLR 2.0 Strong Crypto: 1 CLR 2.0 Strong Crypto x86: 1 Clustered: False IIS Running: True CredentialGuard enabled: False Last System Reboot: 14.10.2026 11:59:22 (Uptime: 0 Days, 0 Hours, 50 Minutes) Reboot Recommended: False Computer Role: Member Server Domain/Workgroup: DOMAIN.LOC Joined to Domain: True Connected to Domain: True Expanded Domain Name: DC=DOMAIN,DC=de Domain Name: DOMAIN.LOC (DOMAIN) Domain Mode: Unknown Parent Domain: Root Domain: DOMAIN.LOC Forest Domain: DOMAIN.LOC Forest Mode: Unknown There do not appear to be any other domains in this organization. There do not appear to be any domains trusted by root domain DOMAIN.LOC. There do not appear to be any domains trusted by forest DOMAIN.LOC. Program Files Folder: C:\Program Files Common Files Folder: C:\Program Files\Common Files Program Files (x86) Folder: C:\Program Files (x86) Common Files (x86) Folder: C:\Program Files (x86)\Common Files Exception: An error occurred searching for SPNs on account . Exception Type: COMException Source: System.DirectoryServices Der Server ist nicht funktionstüchtig. bei System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) bei System.DirectoryServices.DirectoryEntry.Bind() bei System.DirectoryServices.DirectoryEntry.get_AdsObject() bei System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne) bei SQLCheck.Collectors.CollectSPNAccount(DataSet ds) Exception: An error occurred searching for SPNs on account . Exception Type: COMException Source: System.DirectoryServices Der Server ist nicht funktionstüchtig. bei System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) bei System.DirectoryServices.DirectoryEntry.Bind() bei System.DirectoryServices.DirectoryEntry.get_AdsObject() bei System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne) bei SQLCheck.Collectors.CollectSPNAccount(DataSet ds) Disk Drives: Drive Type Format Capacity Bytes Free % Free Status ----- ------- ------ ----------------- ----------------- ------ ------ C:\ Fixed NTFS 268.863.270.912 41.463.959.552 15% D:\ Fixed NTFS 2.147.464.769.536 1.249.889.673.216 58% G:\ Network NTFS 1.236.813.213.696 547.996.422.144 44% H:\ Network NTFS 1.503.101.186.048 920.469.094.400 61% I:\ Network NTFS 1.503.101.186.048 920.469.094.400 61% L:\ Network NTFS 966.230.274.048 716.815.851.520 74% N:\ Network NTFS 4.294.829.928.448 1.196.382.367.744 27% Q:\ Network NTFS 1.503.101.186.048 920.469.094.400 61% R:\ Network NTFS 4.397.910.192.128 3.059.048.988.672 69% S:\ Network NTFS 949.359.575.040 691.887.116.288 72% T:\ Network NTFS 4.294.829.928.448 1.196.382.367.744 27% U:\ Network NTFS 4.294.829.928.448 1.196.382.367.744 27% V:\ Network NTFS 4.294.829.928.448 1.196.382.367.744 27% W:\ Network NTFS 4.294.829.928.448 1.196.382.367.744 27% Z:\ Network NTFS 1.236.813.213.696 547.996.422.144 44% Network Settings: TCPMaxDataRetransmissions: Default is 5 Initial RTO: Max SYN Retransmissions: TCPChimney: RSS: TCPA: Min Ephemeral Port: Max Ephemeral Port: -1 TCP Timed Wait Delay: Syn Attack Protect: No HOSTS file entries found for this machine. The following IP addresses are associated with this machine: Address Family Address -------------- --------------------------- InterNetworkV6 fe80::2e56:d710:f247:28f7%8 InterNetworkV6 fee0:::0 InterNetwork 192.168.1.25 FLTMC Filters: bkpprotector | CldFlt | FileCrypt | luafv | npsvctrig | storqosflt | wcifs | WdFilter | Wof Info: The vnetflt.sys driver is not installed on this machine. Network Mini-Drivers: Service Name Filter Media Types Help Text -------------- --------------------------------- ------------------------------------------------------ @%systemroot%\system32\srvsvc.dll,-110 MsBridge ms_implatform @%SystemRoot%\system32\bridgeres.dll,-2 MsLbfoProvider ms_implatform @%SystemRoot%\System32\drivers\MsLbfoProvider.sys,-500 NdisCap ethernet,wlan,ppip,vmnetextension @%windir%\System32\drivers\ndiscap.sys,-5001 NetBIOS @%windir%\system32\drivers\netbios.sys,-500 Psched cp_tunnel,ethernet,wan @%windir%\System32\drivers\pacer.sys,-100 WfpLwfs ethernet,wlan,ppip,wan @%windir%\System32\drivers\wfplwfs.sys,-6003 WfpLwfs ethernet @%windir%\System32\drivers\wfplwfs.sys,-6002 WfpLwfs vmnetextension @%windir%\System32\drivers\wfplwfs.sys,-6001 Network Adapters: Name: Microsoft Hyper-V Network Adapter Adapter Type: Ethernet 802.3 MAC Address: 00:15:5D:01:02:15 Driver Date: 6-21-2006 Speed: 10 GB/s Speed/Duplex: Flow Control: RSS: Enabled (1) Jumbo Frames: Disabled (1514) NIC Teaming: False Offloading: IPSec Offload (*IPsecOffloadV2): Auth Header and ESP Enabled (3) Offloading: IPv4 Checksum Offload (*IPChecksumOffloadIPv4): Rx & Tx Enabled (3) Offloading: Large Send Offload Version 2 (IPv4) (*LsoV2IPv4): Enabled (1) Offloading: Large Send Offload Version 2 (IPv6) (*LsoV2IPv6): Enabled (1) Offloading: TCP Checksum Offload (IPv4) (*TCPChecksumOffloadIPv4): Rx & Tx Enabled (3) Offloading: TCP Checksum Offload (IPv6) (*TCPChecksumOffloadIPv6): Rx & Tx Enabled (3) Offloading: UDP Checksum Offload (IPv4) (*UDPChecksumOffloadIPv4): Rx & Tx Enabled (3) Offloading: UDP Checksum Offload (IPv6) (*UDPChecksumOffloadIPv6): Rx & Tx Enabled (3) Name: WAN Miniport (IP) Adapter Type: Ethernet 802.3 MAC Address: 16:A6:20:52:41:53 Driver Date: 6-21-2006 Speed: Speed/Duplex: Flow Control: RSS: Jumbo Frames: NIC Teaming: False Name: WAN Miniport (IPv6) Adapter Type: Ethernet 802.3 MAC Address: 28:1F:20:52:41:53 Driver Date: 6-21-2006 Speed: Speed/Duplex: Flow Control: RSS: Jumbo Frames: NIC Teaming: False Name: WAN Miniport (Network Monitor) Adapter Type: Ethernet 802.3 MAC Address: 3C:87:20:52:41:53 Driver Date: 6-21-2006 Speed: Speed/Duplex: Flow Control: RSS: Jumbo Frames: NIC Teaming: False ------------------------------------------------------------ Client Security and Driver Information ------------------------------------------------------------ Security Settings: Crash on Audit Fail: 0 Lanman Compatibility Level: Not specified - default: 5 (Send NTLMv2 response only. Refuse LM & NTLM) Disable Loopback Check: 0 Back Connection Host Names: Max Kerberos Token Size: 48000 Kerberos Logging Level: 0 Kerberos local Encryption: Not Specified (RC4_HMAC_MD5+AES128_HMAC_SHA1+AES256_HMAC_SHA1) Warning: NTLM callbacks should fail. Neither DisableLoopbackCheck nor BackConnectionHostNames is set. Client/Server TLS Version Default Enabled in Reg Disabled By Default Effective Value ------------- ----------- ------------- --------------------- --------------------- --------------- Client SSL 2.0 Not Supported False (0x00000000) ok True (0x00000001) ok Not Supported Client SSL 3.0 Disabled False (0x00000000) ok True (0x00000001) ok Disabled Client TLS 1.0 Enabled False (0x00000000) ok True (0x00000001) ok Disabled Client TLS 1.1 Enabled False (0x00000000) ok True (0x00000001) ok Disabled Client TLS 1.2 Enabled True (0x00000001) ok False (0x00000000) ok Enabled Client TLS 1.3 Not Supported Not Supported Server SSL 2.0 Not Supported False (0x00000000) ok True (0x00000001) ok Not Supported Server SSL 3.0 Disabled False (0x00000000) ok True (0x00000001) ok Disabled Server TLS 1.0 Enabled False (0x00000000) ok True (0x00000001) ok Disabled Server TLS 1.1 Enabled False (0x00000000) ok True (0x00000001) ok Disabled Server TLS 1.2 Enabled True (0x00000001) ok False (0x00000000) ok Enabled Server TLS 1.3 Not Supported Not Supported Cipher Suite Protocol Order: Registry List Policy List -------------------------------------------------------- ------------------------------------------------- TLS_AES_256_GCM_SHA384 (TLS 1.3) TLS_AES_256_GCM_SHA384 (TLS 1.3) TLS_AES_128_GCM_SHA256 (TLS 1.3) TLS_AES_128_GCM_SHA256 (TLS 1.3) TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384 (TLS 1.2) TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (TLS 1.2) TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256 (TLS 1.2) TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (TLS 1.2) TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (TLS 1.2) TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384 (TLS 1.2) TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (TLS 1.2) TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256 (TLS 1.2) TLS_DHE_RSA_WITH_AES_256_GCM_SHA384 (TLS 1.2) TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384 (TLS 1.2) TLS_DHE_RSA_WITH_AES_128_GCM_SHA256 (TLS 1.2) TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256 (TLS 1.2) TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384 (TLS 1.2) TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384 (TLS 1.2) TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256 (TLS 1.2) TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256 (TLS 1.2) TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384 (TLS 1.2) TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256 (TLS 1.2) TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA (TLS 1.2, 1.1, 1.0) TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA (TLS 1.2, 1.1, 1.0) TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA (TLS 1.2, 1.1, 1.0) TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA (TLS 1.2, 1.1, 1.0) TLS_RSA_WITH_AES_256_GCM_SHA384 (TLS 1.2) TLS_RSA_WITH_AES_128_GCM_SHA256 (TLS 1.2) TLS_RSA_WITH_AES_256_CBC_SHA256 (TLS 1.2) TLS_RSA_WITH_AES_128_CBC_SHA256 (TLS 1.2) TLS_RSA_WITH_AES_256_CBC_SHA (TLS 1.2, 1.1, 1.0) TLS_RSA_WITH_AES_128_CBC_SHA (TLS 1.2, 1.1, 1.0) TLS_RSA_WITH_3DES_EDE_CBC_SHA (TLS 1.2, 1.1, 1.0, weak) TLS_RSA_WITH_NULL_SHA256 (TLS 1.2, weak) TLS_RSA_WITH_NULL_SHA (TLS 1.2, 1.1, 1.0, SSL 3.0, weak) TLS_PSK_WITH_AES_256_GCM_SHA384 (TLS 1.2) TLS_PSK_WITH_AES_128_GCM_SHA256 (TLS 1.2) TLS_PSK_WITH_AES_256_CBC_SHA384 (TLS 1.2) TLS_PSK_WITH_AES_128_CBC_SHA256 (TLS 1.2) TLS_PSK_WITH_NULL_SHA384 (TLS 1.2, weak) TLS_PSK_WITH_NULL_SHA256 (TLS 1.2, weak) Diffie-Hellman algorithm version: 2 Diffie-Hellman cipher suites are not enabled. This avoids the risk of certain intermittent TLS failures. SQL Server OLE DB Providers and ODBC Drivers: ODBC traces are disabled. Name Description Type Version Supported TLS 1.2 TLS 1.3 MSF CLSID Path Message ----------------------------- ---------------------------------------- ------ --------------- ---------- ------- ------- --- ------------------------------------ -------------------------------------------------------- ------- SQLOLEDB Microsoft OLE DB Provider for SQL Server OLE DB 10.0.17763.9245 Deprecated Yes No No 0C7FF16C-38E3-11d0-97AB-00C04FC2AD98 C:\Program Files\Common Files\System\Ole DB\sqloledb.dll SQLOLEDB Microsoft OLE DB Provider for SQL Server OLE DB 10.0.17763.9245 Deprecated Yes No No 0C7FF16C-38E3-11d0-97AB-00C04FC2AD98 C:\Program Files\Common Files\System\Ole DB\sqloledb.dll SQLNCLI11 SQL Server Native Client 11.0 OLE DB 11.0.6020.0 No No No No 397C2819-8272-4532-AD3A-FB5E43BEAA39 C:\Windows\system32\sqlncli11.dll SQLNCLI11 SQL Server Native Client 11.0 OLE DB 11.0.6020.0 No No No No 397C2819-8272-4532-AD3A-FB5E43BEAA39 C:\Windows\SysWOW64\sqlncli11.dll MSOLEDBSQL Microsoft OLE DB Driver for SQL Server OLE DB 18.7.0004.0 Yes Yes No Yes 5A23DE84-1D7B-4A16-8DED-B29C09CB648D C:\Windows\system32\msoledbsql.dll MSOLEDBSQL Microsoft OLE DB Driver for SQL Server OLE DB 18.7.0004.0 Yes Yes No Yes 5A23DE84-1D7B-4A16-8DED-B29C09CB648D C:\Windows\SysWOW64\msoledbsql.dll SQL Server SQL Server ODBC 10.0.17763.6766 Deprecated Yes No No C:\Windows\system32\SQLSRV32.dll SQL Server Native Client 11.0 SQL Server Native Client 11.0 ODBC 11.0.6020.0 No No No Yes C:\Windows\system32\sqlncli11.dll ODBC Driver 13 for SQL Server ODBC Driver 13 for SQL Server ODBC 14.0.1000.169 Yes Yes No Yes C:\Windows\system32\msodbcsql13.dll ODBC Driver 17 for SQL Server ODBC Driver 17 for SQL Server ODBC 17.10.6.1 Yes Yes No Yes C:\Windows\system32\msodbcsql17.dll SQL Server SQL Server ODBC 10.0.17763.6766 Deprecated Yes No No C:\Windows\SysWOW64\SQLSRV32.dll SQL Server Native Client 11.0 SQL Server Native Client 11.0 ODBC 11.0.6020.0 No No No Yes C:\Windows\SysWOW64\sqlncli11.dll ODBC Driver 13 for SQL Server ODBC Driver 13 for SQL Server ODBC 14.0.1000.169 Yes Yes No Yes C:\Windows\SysWOW64\msodbcsql13.dll ODBC Driver 17 for SQL Server ODBC Driver 17 for SQL Server ODBC 17.10.6.1 Yes Yes No Yes C:\Windows\SysWOW64\msodbcsql17.dll Other OLE DB Providers and ODBC Drivers: Name Description Type Version CLSID Path Message ------------------------------------------------------ ------------------------------------------------------ ------ --------------- ------------------------------------ -------------------------------------------------------------------------- -------------- ADsDSOObject OLE DB Provider for Microsoft Directory Services OLE DB 10.0.17763.1 549365d0-ec26-11cf-8310-00aa00b505db C:\Windows\system32\activeds.dll ADsDSOObject OLE DB Provider for Microsoft Directory Services OLE DB 10.0.17763.1 549365d0-ec26-11cf-8310-00aa00b505db C:\Windows\system32\activeds.dll Csp16 Connectivity Service Provider OLE DB Unknown 49E0BE0A-39E0-4932-B7BE-F249D56ACD31 csp16.dll File not found Microsoft.Jet.OLEDB.4.0 Microsoft Jet 4.0 OLE DB Provider OLE DB 4.00.9801.0 dee35070-506b-11cf-b1aa-00aa00b8de95 C:\Windows\SysWOW64\msjetoledb40.dll MSDAORA Microsoft OLE DB Provider for Oracle OLE DB Unknown e8cc4cbe-fdff-11d0-b865-00a0c9081c1d C:\Program Files\Common Files\System\Ole DB\msdaora.dll File not found MSDAOSP Microsoft OLE DB Simple Provider OLE DB 10.0.17763.1 dfc8bdc0-e378-11d0-9b30-0080c7e9fe95 C:\Program Files\Common Files\System\Ole DB\msdaosp.dll MSDAOSP Microsoft OLE DB Simple Provider OLE DB 10.0.17763.1 dfc8bdc0-e378-11d0-9b30-0080c7e9fe95 C:\Program Files\Common Files\System\Ole DB\msdaosp.dll MSDASQL Microsoft OLE DB Provider for ODBC Drivers OLE DB 10.0.17763.5933 c8b522cb-5cf3-11ce-ade5-00aa0044773d C:\Program Files\Common Files\System\Ole DB\msdasql.dll MSDASQL Microsoft OLE DB Provider for ODBC Drivers OLE DB 10.0.17763.5933 c8b522cb-5cf3-11ce-ade5-00aa0044773d C:\Program Files\Common Files\System\Ole DB\msdasql.dll MSDataShape MSDataShape OLE DB 10.0.17763.1697 3449A1C8-C56C-11D0-AD72-00C04FC29863 C:\Program Files\Common Files\System\msadc\msadds.dll MSDataShape MSDataShape OLE DB 10.0.17763.1697 3449A1C8-C56C-11D0-AD72-00C04FC29863 C:\Program Files\Common Files\System\msadc\msadds.dll MSOLAP.8 Microsoft OLE DB Provider for Analysis Services 14.0 OLE DB 16.0.70.21 DBC724B0-DD86-4772-BB5A-FCC6CAB2FC1A C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\140\msolap.dll MSOLAP.8 Microsoft OLE DB Provider for Analysis Services 14.0 OLE DB 16.0.70.21 DBC724B0-DD86-4772-BB5A-FCC6CAB2FC1A C:\Program Files\Microsoft Analysis Services\AS OLEDB\140\msolap.dll Search.CollatorDSO Microsoft OLE DB Provider for Search OLE DB 7.0.17763.1 9E175B8B-F52A-11D8-B9A5-505054503030 C:\Windows\system32\tquery.dll Search.CollatorDSO Microsoft OLE DB Provider for Search OLE DB 7.0.17763.1 9E175B8B-F52A-11D8-B9A5-505054503030 C:\Windows\system32\tquery.dll SSISOLEDB.6 OLE DB Provider for SQL Server Integration Services OLE DB 16.0.1000.6 DD481488-DDD1-45C0-B665-CFA131D883E6 C:\Program Files\Microsoft SQL Server\160\DTS\Binn\SSISOLEDB.dll Driver da Microsoft para arquivos texto (*.txt; *.csv) Driver da Microsoft para arquivos texto (*.txt; *.csv) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Driver do Microsoft Access (*.mdb) Driver do Microsoft Access (*.mdb) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Driver do Microsoft dBase (*.dbf) Driver do Microsoft dBase (*.dbf) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Driver do Microsoft Excel(*.xls) Driver do Microsoft Excel(*.xls) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Driver do Microsoft Paradox (*.db ) Driver do Microsoft Paradox (*.db ) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Microsoft Access Driver (*.mdb) Microsoft Access Driver (*.mdb) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Microsoft Access-Treiber (*.mdb) Microsoft Access-Treiber (*.mdb) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Microsoft dBase Driver (*.dbf) Microsoft dBase Driver (*.dbf) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Microsoft dBase-Treiber (*.dbf) Microsoft dBase-Treiber (*.dbf) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Microsoft Excel Driver (*.xls) Microsoft Excel Driver (*.xls) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Microsoft Excel-Treiber (*.xls) Microsoft Excel-Treiber (*.xls) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Microsoft ODBC for Oracle Microsoft ODBC for Oracle ODBC 10.0.17763.1 C:\Windows\SysWOW64\msorcl32.dll Microsoft Paradox Driver (*.db ) Microsoft Paradox Driver (*.db ) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Microsoft Paradox-Treiber (*.db ) Microsoft Paradox-Treiber (*.db ) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Microsoft Text Driver (*.txt; *.csv) Microsoft Text Driver (*.txt; *.csv) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll Microsoft Text-Treiber (*.txt; *.csv) Microsoft Text-Treiber (*.txt; *.csv) ODBC 10.0.17763.1 C:\Windows\SysWOW64\odbcjt32.dll ADAL files present on this machine: Path Version Message ------------------------------- ------- -------------- C:\Windows\system32\adal.dll 3.6.1 C:\Windows\system32\msal.dll File not found C:\Windows\system32\sqladal.dll File not found C:\Windows\syswow64\adal.dll 3.6.1 C:\Windows\syswow64\msal.dll File not found C:\Windows\syswow64\sqladal.dll File not found ADAL registry entries present on this machine: Registry Path ADAL DLL Message --------------------------------------------------------------------- ---------------------------- ------- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSADALSQL!TargetDir C:\Windows\system32\adal.dll HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\MSADALSQL!TargetDir C:\Windows\SysWOW64\adal.dll Processes that have SQL Server (and some other) Drivers Loaded: Process Name Process ID Drivers Loaded ---------------------------------- ---------- ----------------------------------------------- cnslocal.exe 10784 odbc32.dll, activeds.dll, msdadiag.dll cnsmaster.exe 3532 activeds.dll, odbc32.dll, msdadiag.dll Elm.exe 3932 activeds.dll mmc.exe 14680 activeds.dll pdllhost.exe 6096 activeds.dll, odbc32.dll, msdadiag.dll, jvm.dll powershell.exe 2936 system.data.dll, msdadiag.dll PWatchdog.exe 3688 activeds.dll, odbc32.dll, msdadiag.dll sqlceip.exe 5072 system.data.dll, msdadiag.dll sqlceip.exe 992 system.data.dll, msdadiag.dll SQLCheck.exe 13952 system.data.dll, msdadiag.dll, activeds.dll sqlservr.exe 5080 odbc32.dll, msdadiag.dll, msoledbsql.dll sqlservr.exe 7592 odbc32.dll, msdadiag.dll, msoledbsql.dll sqlwriter.exe 4000 msoledbsql.dll, msdadiag.dll svchost.exe 1456 activeds.dll svchost.exe 1704 activeds.dll w3wp.exe 5512 system.data.dll, msdadiag.dll w3wp.exe 6636 system.data.dll, msdadiag.dll, activeds.dll No SQL Aliases were found on this machine. SQL Client Driver SNI Settings: Client Name Protocol Order Force Encryption Trust Server Cert TCP Default Port Keep-Alive Interval (ms) Keep-Alive Retry Interval (ms) 32-bit ----------------- -------------- ---------------- ----------------- ---------------- ------------------------ ------------------------------ ------ SNI11.0 sm tcp np 1433 30000 1000 SNI18.0 sm tcp np 1433 30000 1000 SuperSocketNetLib 0 SNI11.0 sm tcp np 1433 30000 1000 Yes SNI18.0 sm tcp np 1433 30000 1000 Yes SuperSocketNetLib 0 Yes -------------------------------------------------------------------- SQL Server Information -------------------------------------------------------------------- Certificates in the Local Computer MY Store: Friendly Name CN SAN Thumbprint Server Cert Key Len Sig Type KeySpec Usage Private Key Not Before Not After Problem ------------------------ -------------------------------------------------------------------------------- --- ---------------------------------------- ----------- ------- --------- -------- ----- ----------- ------------------- ------------------- ------------------------ CN=ffe16e9f-41ec-4ad5-b9bf-4a67b6865de2 D6D31DA5DFFD2F779D5961D6C017D445E2AC569C 2048 sha256RSA Exchange Yes 22.09.2025 00:07:49 22.09.2035 00:37:49 Not server *.DOMAIN.LOC 2026 09 CN=*.DOMAIN.LOC D10C512FA3E500A71DAC059723F28B81A154FC92 4096 sha256RSA Exchange Yes 16.09.2026 02:00:00 03.04.2027 01:59:59 Not server CN=ffe16e9f-41ec-4ad5-b9bf-4a67b6865de2, DC=7f4b5df7-86d5-4193-97a0-3e052eac79e0 A837A43945AE0796A441CF94598AA6DB0BDD46DB 2048 sha256RSA Exchange Yes 23.04.2026 01:51:50 24.04.2026 01:56:50 Expired cert, Not server CN=ffe16e9f-41ec-4ad5-b9bf-4a67b6865de2, DC=7f4b5df7-86d5-4193-97a0-3e052eac79e0 0FC2C0D044662D2D7AF8437592F9413A65BCB34A 2048 sha256RSA Exchange Yes 14.10.2026 11:54:55 15.10.2026 11:59:55 Not server Certificate Permissions: Friendly Name Thumbprint UserID Permissions ------------- ---------- ------ ----------- Services of Interest: Note: UPN account names (SQLSVC@Contoso.com) are converted to NT Account format (Contoso\SQLSVC) for ease of comparison and LDAP queries. Name Instance Description PID Service Account Domain Account Start Mode Started Status --------------- ------------- ---------------------------------------------------- ----- ---------------------------------------- --------------------------- ---------- ------- ------ IISADMIN IIS-Verwaltungsdienst 3616 localSystem DOMAIN\SERVERNAME$ Auto True OK MSDTC Distributed Transaction Coordinator 8068 NT AUTHORITY\NetworkService NT-AUTORITÄT\Netzwerkdienst Auto True OK MSSQL SQLEXPRESS SQL Server (SQLEXPRESS) 7592 NT Service\MSSQL$SQLEXPRESS DOMAIN\SERVERNAME$ Auto True OK RpcSs Remoteprozeduraufruf (RPC) 1028 NT AUTHORITY\NetworkService NT-AUTORITÄT\Netzwerkdienst Auto True OK SQLAgent SQLEXPRESS SQL Server-Agent (SQLEXPRESS) 0 NT AUTHORITY\NETWORKSERVICE NT-AUTORITÄT\Netzwerkdienst Disabled False OK SQLBrowser SQL Server-Browser 10480 NT AUTHORITY\LOCALSERVICE NT-AUTORITÄT\Lokaler Dienst Auto True OK SQLTELEMETRY SQLEXPRESS SQL Server CEIP service (SQLEXPRESS) 992 NT Service\SQLTELEMETRY$SQLEXPRESS DOMAIN\SERVERNAME$ Auto True OK SQLWriter SQL Server VSS Writer 4000 LocalSystem DOMAIN\SERVERNAME$ Auto True OK TermService Remotedesktopdienste 1164 NT Authority\NetworkService NT-AUTORITÄT\Netzwerkdienst Manual True OK W3SVC WWW-Publishingdienst 4016 localSystem DOMAIN\SERVERNAME$ Auto True OK Warning: SQL Server-Agent (SQLEXPRESS) start mode is set to Disabled. Domain Service Account Properties: Account Domain Type UAC Sensitive Trust for Del. Const. Del. Kerberos Encryption --------- ----------- -------- ------------- --------- -------------- ----------- ---------------------------------------------- SERVERNAME$ DOMAIN Computer 4096 (0x1000) False False False RC4_HMAC_MD5+AES128_HMAC_SHA1+AES256_HMAC_SHA1 Warning: must be trusted for delegation in order for Kerberos delegation to succeed. Info: Credential Guard is not enabled. Unconstrained delegation should work. No constrained delegation back-end service SPNs were found on any of the above accounts. The following Service Principal Names were found: Account SPN Has Duplicates --------- ---------------------------------------------- -------------- SERVERNAME$ HOST/SERVERNAME False SERVERNAME$ HOST/SERVERNAME.DOMAIN.LOC False SERVERNAME$ MSSQLSvc/SERVERNAME.DOMAIN.LOC:1433 False SERVERNAME$ MSSQLSvc/SERVERNAME.DOMAIN.LOC:1434 False SERVERNAME$ MSSQLSvc/SERVERNAME.DOMAIN.LOC:50030 False SERVERNAME$ MSSQLSvc/SERVERNAME.DOMAIN.LOC:51120 False SERVERNAME$ MSSQLSvc/SERVERNAME.DOMAIN.LOC:SQLEXPRESS False SERVERNAME$ RestrictedKrbHost/SERVERNAME False SERVERNAME$ RestrictedKrbHost/SERVERNAME.DOMAIN.LOC False SERVERNAME$ TERMSRV/SERVERNAME False SERVERNAME$ TERMSRV/SERVERNAME.DOMAIN.LOC False SERVERNAME$ WSMAN/SERVERNAME False SERVERNAME$ WSMAN/SERVERNAME.DOMAIN.LOC False SQL Server Instances: Note: Only SQL 2008 and later are checked. There may be SQL 2000 instances. Service Type Instance Name 32-bit ------------ ------------- ------ SQL SQLEXPRESS False Details for SQL Server Instance: SQLEXPRESS (Express Edition) Version: 16.0.1000.6 SP 0 Patch Level: 16.0.4295.3 Clustered: False Always-On: False Authentication Mode: MIXED Certificate: d10c512fa3e500a71dac059723f28b81a154fc92; problems: Not server) ForceEncryption: False ForceStrict: False Hidden Instance: False Extended Protection: Off Shared Memory Enabled: True Named Pipes Enabled: True (\\.\pipe\MSSQL$SQLEXPRESS\sql\query) TCP Enabled: True Listen on all IPs: True Keep-Alive Interval (ms): 30000 TCP Port(s): 1433 Dynamic TCP Port(s): 50030 Install Path: C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Binn ERRORLOG Path: C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Log\ERRORLOG Current Process ID: 7592 Service Account: NT Service\MSSQL$SQLEXPRESS SPN Account: DOMAIN\SERVERNAME$ Suggested SPN Exists Status ------------------------------------------- ------ ------------------- MSSQLSvc/SERVERNAME.DOMAIN.LOC:1433 True Okay MSSQLSvc/SERVERNAME.DOMAIN.LOC:50030 True Okay MSSQLSvc/SERVERNAME.DOMAIN.LOC:SQLEXPRESS True Okay MSSQLSvc/SERVERNAME:1433 False SPN does not exist. MSSQLSvc/SERVERNAME:50030 False SPN does not exist. MSSQLSvc/SERVERNAME:SQLEXPRESS False SPN does not exist. Warning: You should not use SPNs with dynamic ports. ------------------------------------------------------------------------ End of Report -------------------------------------------------------------------------