----------------------------------------------------------------------- Start of Report ------------------------------------------------------------------------ SQL Server Connectivity Check v1.0.1256.0, run on 01.12.2023 08:35:20 PM 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: MIKAN\milos NETBIOS Name: MIKAN FQDN: Mikan DNS Suffix: Windows Name and Edition: Windows 10 Pro (2009) Windows Version: 10.0.22621.1105 Windows Build: 22621 Windows Release ID: 2009 64-Bit System: True .NET 4.x version: 4.8.09032 CLR 4.0 Strong Crypto: Not set CLR 4.0 Strong Crypto x86: Not set .NET 2.x/3.x version: 3.5.30729.4926 (SP1) CLR 2.0 Strong Crypto: Not set CLR 2.0 Strong Crypto x86: Not set Clustered: False IIS Running: False CredentialGuard enabled: False Last System Reboot: 12.01.2023 20:20:06 (Uptime: 0 Days, 0 Hours, 15 Minutes) Reboot Recommended: False Computer Role: Standalone Workstation Domain/Workgroup: WORKGROUP Joined to Domain: False Connected to Domain: False Expanded Domain Name: 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 Warning: The application is being run from a local account: MIKAN\milos. Please run using a domain account with local Admin priviledges. Warning: This computer belongs to a workgroup and not a domain. This can cause authentication and delegation issues. Disk Drives: Drive Type Format Capacity Bytes Free % Free Status ----- ----- ------ --------------- --------------- ------ ------ C:\ Fixed NTFS 998 991 982 592 943 868 682 240 94% Network Settings: TCPMaxDataRetransmissions: Default is 5 Initial RTO: 1000 Max SYN Retransmissions: 4 TCPChimney: RSS: enabled TCPA: Min Ephemeral Port: 49152 Max Ephemeral Port: 65535 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::3b6c:2a92:65be:55af%4 InterNetwork 192.168.10.35 FLTMC Filters: applockerfltr | bfs | bindflt | CldFlt | FileCrypt | FileInfo | luafv | npsvctrig | storqosflt | wcifs | WdFilter | Wof Network Mini-Drivers: Service Name Filter Media Types Help Text ------------ ------------------------------------------- -------------------------------------------- @%systemroot%\system32\srvsvc.dll,-110 vwifi,vchannel @%windir%\System32\drivers\vwififlt.sys,-106 MsBridge ms_implatform @%SystemRoot%\system32\bridgeres.dll,-2 NativeWifiP wlan NdisCap ethernet,wlan,ppip,vmnetextension,bluetooth @%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: Bluetooth Device (Personal Area Network) Adapter Type: Ethernet 802.3 Driver Date: 6-21-2006 Speed: 3000000 Speed/Duplex: Flow Control: RSS: Jumbo Frames: NIC Teaming: False Name: Microsoft Wi-Fi Direct Virtual Adapter Adapter Type: Ethernet 802.3 Driver Date: 6-21-2006 Speed: Speed/Duplex: Flow Control: RSS: Jumbo Frames: NIC Teaming: False Name: Microsoft Wi-Fi Direct Virtual Adapter Adapter Type: Ethernet 802.3 Driver Date: 6-21-2006 Speed: Speed/Duplex: Flow Control: RSS: Jumbo Frames: NIC Teaming: False Name: Realtek RTL8822CE 802.11ac PCIe Adapter Adapter Type: Ethernet 802.3 Driver Date: 12-24-2021 Speed: 144400000 Speed/Duplex: Flow Control: RSS: Jumbo Frames: NIC Teaming: False Offloading: ARP offload for WoWLAN (ARPOffloadEnable): Enabled (1) Offloading: GTK rekeying for WoWLAN (GTKOffloadEnable): Enabled (1) Offloading: NS offload for WoWLAN (NSOffloadEnable): Enabled (1) ------------------------------------------------------------ Client Security and Driver Information ------------------------------------------------------------ Security Settings: Crash on Audit Fail: 0 Lanman Compatibility Level: 0 (Send LM & NTLM responses) 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: LanmanCompatibilityLevel: The setting may be too low. 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 Not Supported Client SSL 3.0 Disabled Disabled Client TLS 1.0 Enabled Enabled Client TLS 1.1 Enabled Enabled Client TLS 1.2 Enabled Enabled Client TLS 1.3 Enabled Enabled Server SSL 2.0 Not Supported Not Supported Server SSL 3.0 Disabled Disabled Server TLS 1.0 Enabled Enabled Server TLS 1.1 Enabled Enabled Server TLS 1.2 Enabled Enabled Server TLS 1.3 Enabled Enabled Cipher Suite Protocol Order: Registry List Policy List --------------------------------------- ----------- TLS_AES_256_GCM_SHA384 TLS_AES_128_GCM_SHA256 TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384 TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384 TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256 TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384 TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256 TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA TLS_RSA_WITH_AES_256_GCM_SHA384 TLS_RSA_WITH_AES_128_GCM_SHA256 TLS_RSA_WITH_AES_256_CBC_SHA256 TLS_RSA_WITH_AES_128_CBC_SHA256 TLS_RSA_WITH_AES_256_CBC_SHA TLS_RSA_WITH_AES_128_CBC_SHA TLS_RSA_WITH_NULL_SHA256 TLS_RSA_WITH_NULL_SHA TLS_PSK_WITH_AES_256_GCM_SHA384 TLS_PSK_WITH_AES_128_GCM_SHA256 TLS_PSK_WITH_AES_256_CBC_SHA384 TLS_PSK_WITH_AES_128_CBC_SHA256 TLS_PSK_WITH_NULL_SHA384 TLS_PSK_WITH_NULL_SHA256 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 Type Version Supported TLS 1.2 TLS 1.3 MSF GUID Path Message ----------------------------- ------ --------------- ---------- ------- ------- --- -------------------------------------- -------------------------------------------------------------- ------- SQLOLEDB OLE DB 10.0.22621.1105 Deprecated No No No {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98} C:\Program Files\Common Files\System\Ole DB\sqloledb.dll SQLOLEDB OLE DB 10.0.22621.1105 Deprecated No No No {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98} C:\Program Files (x86)\Common Files\System\Ole DB\sqloledb.dll SQLNCLI11 OLE DB 11.0.7462.6 No Yes No No {397C2819-8272-4532-AD3A-FB5E43BEAA39} C:\WINDOWS\system32\sqlncli11.dll SQLNCLI11 OLE DB 11.0.7462.6 No Yes No No {397C2819-8272-4532-AD3A-FB5E43BEAA39} C:\WINDOWS\SysWOW64\sqlncli11.dll MSOLEDBSQL OLE DB 18.5.0000.0 Yes Yes No Yes {5A23DE84-1D7B-4A16-8DED-B29C09CB648D} C:\WINDOWS\system32\msoledbsql.dll MSOLEDBSQL OLE DB 18.5.0000.0 Yes Yes No Yes {5A23DE84-1D7B-4A16-8DED-B29C09CB648D} C:\WINDOWS\SysWOW64\msoledbsql.dll SQL Server ODBC 10.0.22621.1105 Deprecated No No No C:\WINDOWS\system32\SQLSRV32.dll SQL Server Native Client 11.0 ODBC 11.0.7462.6 No Yes No Yes C:\WINDOWS\system32\sqlncli11.dll ODBC Driver 13 for SQL Server ODBC 13.0.4001.0 Yes Yes No Yes C:\WINDOWS\system32\msodbcsql13.dll ODBC Driver 17 for SQL Server ODBC 17.7.2.1 Yes Yes No Yes C:\WINDOWS\system32\msodbcsql17.dll SQL Server ODBC 10.0.22621.1105 Deprecated No No No C:\WINDOWS\SysWOW64\SQLSRV32.dll SQL Server Native Client 11.0 ODBC 11.0.7462.6 No Yes No Yes C:\WINDOWS\SysWOW64\sqlncli11.dll ODBC Driver 13 for SQL Server ODBC 13.0.4001.0 Yes Yes No Yes C:\WINDOWS\SysWOW64\msodbcsql13.dll ODBC Driver 17 for SQL Server ODBC 17.7.2.1 Yes Yes No Yes C:\WINDOWS\SysWOW64\msodbcsql17.dll Other OLE DB Providers and ODBC Drivers: Name Type Version GUID Path Message ------------------------------------------------------ ------ ------------ -------------------------------------- -------------------------------------------------------------------------- ------- MSOLAP OLE DB 15.1.108.23 {DBC724B0-DD86-4772-BB5A-FCC6CAB2FC1A} C:\Program Files\Microsoft Analysis Services\AS OLEDB\140\msolap.dll MSOLAP OLE DB 15.1.108.23 {DBC724B0-DD86-4772-BB5A-FCC6CAB2FC1A} C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\140\msolap.dll ADSDSOObject OLE DB 10.0.22621.1 {549365d0-ec26-11cf-8310-00aa00b505db} C:\WINDOWS\system32\activeds.dll ADSDSOObject OLE DB 10.0.22621.1 {549365d0-ec26-11cf-8310-00aa00b505db} C:\WINDOWS\SysWOW64\activeds.dll SQL Server Native Client RDA 11.0 ODBC 11.0.5069.55 C:\Program Files\Microsoft SQL Server\130\Shared\sqlnclirda11.dll Driver da Microsoft para arquivos texto (*.txt; *.csv) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Driver do Microsoft Access (*.mdb) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Driver do Microsoft dBase (*.dbf) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Driver do Microsoft Excel(*.xls) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Driver do Microsoft Paradox (*.db ) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Microsoft Access Driver (*.mdb) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Microsoft Access-Treiber (*.mdb) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Microsoft dBase Driver (*.dbf) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Microsoft dBase-Treiber (*.dbf) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Microsoft Excel Driver (*.xls) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Microsoft Excel-Treiber (*.xls) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Microsoft ODBC for Oracle ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\msorcl32.dll Microsoft Paradox Driver (*.db ) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Microsoft Paradox-Treiber (*.db ) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Microsoft Text Driver (*.txt; *.csv) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Microsoft Text-Treiber (*.txt; *.csv) ODBC 10.0.22621.1 C:\WINDOWS\SysWOW64\odbcjt32.dll Processes that have SQL Server (and some other) Drivers Loaded: Process Name Process ID Drivers Loaded ------------------------------------ ---------- --------------- amdfendrsr.exe 3576 odbc32.dll SQLCheck.exe 1628 system.data.dll TouchpointAnalyticsClientService.exe 3096 system.data.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 ------------- -- --- ---------- ----------- ------- -------- ------- ----- ----------- ---------- --------- ------- Services of Interest: Name Instance Description PID Service Account Domain Account Start Mode Started Status ----------- -------- ------------------------------------ ---- --------------------------- -------------- ---------- ------- ------ MSDTC Koordynator transakcji rozproszonych 0 NT AUTHORITY\NetworkService MIKAN Manual False OK MSSQL SAGEPL SQL Server (SAGEPL) 0 NT Service\MSSQL$SAGEPL MIKAN Auto False OK RpcSs Zdalne wywoływanie procedur (RPC) 1528 NT AUTHORITY\NetworkService MIKAN Auto True OK SQLAgent SAGEPL SQL Server Agent (SAGEPL) 0 NT AUTHORITY\NETWORKSERVICE MIKAN Disabled False OK SQLBrowser SQL Server Browser 5088 NT AUTHORITY\LOCALSERVICE MIKAN Auto True OK SQLWriter SQL Server VSS Writer 5044 LocalSystem MIKAN Auto True OK TermService Usługi pulpitu zdalnego 0 NT Authority\NetworkService MIKAN Manual False OK Critical: SQL Server (SAGEPL) is set to automatically start but it is not running. Warning: Koordynator transakcji rozproszonych start mode is set to Manual. Warning: SQL Server Agent (SAGEPL) start mode is set to Disabled. Warning: Usługi pulpitu zdalnego start mode is set to Manual. Domain Service Account Properties: Account Domain Type UAC Sensitive Trust for Del. Const. Del. Kerberos Encryption ------- ------ ---- --- --------- -------------- ----------- ------------------- 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. No Service Principal Names were found on any of the above accounts. SQL Server Instances: Note: Only SQL 2008 and later are checked. There may be SQL 2000 instances. Service Type Instance Name 32-bit ------------ ------------- ------ SQL SAGEPL False Details for SQL Server Instance: SAGEPL (Express Edition) Version: 13.0.1601.5 SP 0 Patch Level: 13.1.4001.0 Clustered: False Always-On: False Authentication Mode: MIXED Certificate: ForceEncryption: False Hidden Instance: False Extended Protection: Off Shared Memory Enabled: True Named Pipes Enabled: True (\\.\pipe\MSSQL$SAGEPL\sql\query) TCP Enabled: True Listen on all IPs: True Keep-Alive Interval (ms): 30000 TCP Port(s): Dynamic TCP Port(s): 0 Install Path: C:\Program Files\Microsoft SQL Server\MSSQL13.SAGEPL\MSSQL\Binn ERRORLOG Path: C:\Program Files\Microsoft SQL Server\MSSQL13.SAGEPL\MSSQL\Log\ERRORLOG Current Process ID: Service Account: NT Service\MSSQL$SAGEPL SPN Account: Warning: Process is not running. ------------------------------------------------------------------------ End of Report -------------------------------------------------------------------------