----------------------------------------------------------------------- Start of Report ------------------------------------------------------------------------ SQL Server Connectivity Check v1.0.1316.0, run on 05/15/2024 10:26:38 (UTC-03:00) Hora oficial do Brasil 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: LAPTOP-2L1BKODT\gabri NETBIOS Name: LAPTOP-2L1BKODT FQDN: LAPTOP-2L1BKODT DNS Suffix: Windows Name and Edition: Windows 10 Home Single Language (23H2) Windows Version: 10.0.22631.3527 Windows Build: 22631 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: Not installed CLR 2.0 Strong Crypto: Not set CLR 2.0 Strong Crypto x86: Not set Clustered: False IIS Running: False CredentialGuard enabled: True Last System Reboot: 13/05/2024 12:07:21 (Uptime: 1 Days, 22 Hours, 19 Minutes) Reboot Recommended: True 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: Reboot is recommended due to pending file rename operations being present. Warning: The application is being run from a local account: LAPTOP-2L1BKODT\gabri. 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 239.414.013.952 168.872.488.960 70% 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::1210:5aa5:165b:5deb%15 InterNetworkV6 2804:14d:3283:9c81:a1ab:6a91:7449:dc0a InterNetworkV6 2804:14d:3283:9c81::1000 InterNetworkV6 2804:14d:3283:9c81:a453:1acb:dc71:b56 InterNetwork 192.168.0.124 FLTMC Filters: bfs | bindflt | CldFlt | FileCrypt | FileInfo | gameflt | luafv | npsvctrig | storqosflt | UCPD | 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 vmnetextension @%windir%\System32\drivers\vmswitch.sys,-60004 vwifi,vchannel @%windir%\System32\drivers\vwififlt.sys,-106 vmnetextension Microsoft Azure VFP Switch Filter Extension l2bridge ethernet,ppip @%SystemRoot%\System32\drivers\l2bridge.sys,-5001 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 MAC Address: 3C:21:9C:94:34:D6 Driver Date: 6-21-2006 Speed: 3000000 Speed/Duplex: Flow Control: RSS: Jumbo Frames: NIC Teaming: False Name: Intel(R) Wireless-AC 9462 Adapter Type: Ethernet 802.3 MAC Address: 3C:21:9C:94:34:D2 Driver Date: 11-23-2022 Speed: 433300000 Speed/Duplex: Flow Control: RSS: Jumbo Frames: NIC Teaming: False Offloading: Descarregamento ARP para WoWLAN (*PMARPOffload): Habilitado (1) Offloading: Descarregamento NS para WoWLAN (*PMNSOffload): Habilitado (1) Offloading: Nova geração de chaves GTK para WoWLAN (*PMWiFiRekeyOffload): Habilitado (1) Name: Microsoft Wi-Fi Direct Virtual Adapter Adapter Type: Ethernet 802.3 MAC Address: 3C:21:9C:94:34:D3 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 MAC Address: 3E:21:9C:94:34:D2 Driver Date: 6-21-2006 Speed: Speed/Duplex: Flow Control: RSS: Jumbo Frames: NIC Teaming: False Name: Realtek PCIe GbE Family Controller Adapter Type: Ethernet 802.3 MAC Address: 8C:B0:E9:EA:86:26 Driver Date: 10-22-2021 Speed: Speed/Duplex: Auto Negotiation (0) Flow Control: Rx & Tx Enabled (3) RSS: Jumbo Frames: Disabled (1514) NIC Teaming: False Offloading: ARP Offload (*PMARPOffload): Enabled (1) Offloading: IPv4 Checksum Offload (*IPChecksumOffloadIPv4): Rx & Tx Enabled (3) Offloading: Large Send Offload v2 (IPv4) (*LsoV2IPv4): Enabled (1) Offloading: Large Send Offload v2 (IPv6) (*LsoV2IPv6): Enabled (1) Offloading: NS Offload (*PMNSOffload): 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: B4:AB: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: E6:B5: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: FA:66: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 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 1.3) TLS_AES_128_GCM_SHA256 (TLS 1.3) TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384 (TLS 1.2) TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256 (TLS 1.2) TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (TLS 1.2) TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (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_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_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 Type Version Supported TLS 1.2 TLS 1.3 MSF GUID Path Message ----------------------------- ------ --------------- ---------- ------- ------- --- -------------------------------------- -------------------------------------------------------------- ------- SQLOLEDB OLE DB 10.0.22621.3527 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.3527 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.2100.60 No No No No {397C2819-8272-4532-AD3A-FB5E43BEAA39} C:\Windows\system32\sqlncli11.dll SQLNCLI11 OLE DB 11.0.2100.60 No No No No {397C2819-8272-4532-AD3A-FB5E43BEAA39} C:\Windows\SysWOW64\sqlncli11.dll SQL Server ODBC 10.0.22621.3447 Deprecated No No No C:\Windows\system32\SQLSRV32.dll SQL Server Native Client 11.0 ODBC 11.0.2100.60 No No No Yes C:\Windows\system32\sqlncli11.dll ODBC Driver 11 for SQL Server ODBC 12.0.2000.8 Yes No No Yes C:\Windows\system32\msodbcsql11.dll SQL Server ODBC 10.0.22621.3447 Deprecated No No No C:\Windows\SysWOW64\SQLSRV32.dll SQL Server Native Client 11.0 ODBC 11.0.2100.60 No No No Yes C:\Windows\SysWOW64\sqlncli11.dll ODBC Driver 11 for SQL Server ODBC 12.0.2000.8 Yes No No Yes C:\Windows\SysWOW64\msodbcsql11.dll Other OLE DB Providers and ODBC Drivers: Name Type Version GUID Path Message ------------------------------------------------------ ------ --------------- -------------------------------------- ----------------------------------------------------------------------------- ------- MSOLAP OLE DB 12.0.2000.8 {E7B0C00E-8739-4a5a-B267-DCC873FC1E8D} C:\Program Files\Microsoft Analysis Services\AS OLEDB\120\msolap120.dll MSOLAP OLE DB 12.0.2000.8 {E7B0C00E-8739-4a5a-B267-DCC873FC1E8D} C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\120\msolap120.dll ADSDSOObject OLE DB 10.0.22621.2860 {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 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 ADAL files present on this machine: Path Version Message ------------------------------- ------- -------------- C:\Windows\system32\adal.dll File not found C:\Windows\system32\msal.dll File not found C:\Windows\system32\sqladal.dll File not found C:\Windows\syswow64\adal.dll File not found 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 No redirection HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\MSADALSQL!TargetDir No redirection Processes that have SQL Server (and some other) Drivers Loaded: Process Name Process ID Drivers Loaded -------------------------- ---------- --------------- OneApp.IGCC.WinService.exe 4092 system.data.dll SQLCheck.exe 10424 system.data.dll SUEngine.exe 1728 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 SuperSocketNetLib 0 SNI11.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 ------------------- ----------------------------------- --- ---------------------------------------- ----------- ------- -------- -------- ----- ----------- ------------------- ------------------- ---------- SSIS Worker Service CN=192.168.1.29, CN=laptop-2l1bkodt 8C8C9206535A320688A444DE6A7055A5B061DA8B 2048 sha1RSA Exchange Yes 11/05/2024 17:48:36 11/05/2034 17:48:36 Not server Services of Interest: Name Instance Description PID Service Account Domain Account Start Mode Started Status ----------- ---------- -------------------------------------- ---- --------------------------- --------------- ---------- ------- ------ MSDTC Coordenador de transações distribuídas 0 NT AUTHORITY\NetworkService LAPTOP-2L1BKODT Manual False OK MSSQL SQLEXPRESS SQL Server (SQLEXPRESS) 0 LocalSystem LAPTOP-2L1BKODT Auto False OK RpcSs RPC (Chamada de Procedimento Remoto) 1232 NT AUTHORITY\NetworkService LAPTOP-2L1BKODT Auto True OK SQLAgent SQLEXPRESS SQL Server Agent (SQLEXPRESS) 0 LocalSystem LAPTOP-2L1BKODT Auto False OK SQLBrowser SQL Server Browser 4660 NT AUTHORITY\LOCALSERVICE LAPTOP-2L1BKODT Auto True OK SQLWriter Gravador VSS do SQL Server 4688 LocalSystem LAPTOP-2L1BKODT Auto True OK TermService Serviços de Área de Trabalho Remota 0 NT Authority\NetworkService LAPTOP-2L1BKODT Manual False OK Critical: SQL Server (SQLEXPRESS) is set to automatically start but it is not running. Critical: SQL Server Agent (SQLEXPRESS) is set to automatically start but it is not running. Warning: Coordenador de transações distribuídas start mode is set to Manual. Warning: Serviços de Área de Trabalho Remota start mode is set to Manual. Domain Service Account Properties: Account Domain Type UAC Sensitive Trust for Del. Const. Del. Kerberos Encryption ------- ------ ---- --- --------- -------------- ----------- ------------------- Warning: Credential Guard is enabled. Unconstrained delegation will not 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 SQLEXPRESS False Details for SQL Server Instance: SQLEXPRESS (Express Edition) Version: 12.0.2000.8 SP 0 Patch Level: 12.0.2000.8 Clustered: False Always-On: False Authentication Mode: MIXED Certificate: ForceEncryption: False ForceStrict: Not supported Hidden Instance: False Extended Protection: Off Shared Memory Enabled: True Named Pipes Enabled: False TCP Enabled: False Install Path: C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Binn ERRORLOG Path: C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Log\ERRORLOG Current Process ID: Service Account: LocalSystem SPN Account: Warning: Process is not running. ------------------------------------------------------------------------ End of Report -------------------------------------------------------------------------