Hi,
I deployed my Blazor Server Application on a Windows 10 Pro which has IIS 10 and SQL Server Express 2019. I am getting this error;
SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.
Verify that the instance name is correct and that SQL server is configured to allow remote connection(provider: SNI_PN11, error:26 - Error Locating Server/Instance Specified)
Here is my sample connection string:
"DefaultConnection": "Data Source=ABC\\SQLEXPRESS;Initial Catalog=InventoryManagement;Integrated Security=True"
I checked with the SQL Check tool and here is the report. Hope you can identify the problem.
------------- Start of Report -------------
SQL Server Connectivity Check v1.0.1245.0, run on 09.23.2022 08:51:51 ™™
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: DESKTOP-B4JHKV8\abc
NETBIOS Name: DESKTOP-B4JHKV8
FQDN: DESKTOP-B4JHKV8
DNS Suffix:
Windows Name and Edition: Windows 10 Pro (2009)
Windows Version: 10.0.19044.2006
Windows Build: 19044
Windows Release ID: 2009
64-Bit System: True
.NET 4.x version: 4.8.04084
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: True
CredentialGuard enabled: False
Last System Reboot: 22.09.2022 14:24:31 (Uptime: 0 Days, 18 Hours, 27 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: DESKTOP-B4JHKV8\abc. 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 249.352.146.944 170.828.259.328 68%
D:\ Fixed NTFS 2.000.381.014.016 2.000.211.116.032 99%
Network Settings:
TCPMaxDataRetransmissions: <missing> 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::45ea:f574:fbfa:a02a%14
InterNetwork 192.168.1.110
FLTMC Filters: 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 @%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: Intel(R) Ethernet Connection (17) I219-V
Adapter Type: Ethernet 802.3
Driver Date: 2-10-2021
Speed: 100 MB/s
Speed/Duplex: Auto Negotiation (0)
Flow Control: Rx & Tx Enabled (3)
RSS: Enabled (1)
Jumbo Frames: Disabled (1514)
NIC Teaming: False
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: Protocol ARP Offload (*PMARPOffload): Enabled (1)
Offloading: Protocol 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
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
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
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: 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_DHE_RSA_WITH_AES_256_GCM_SHA384
TLS_DHE_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_3DES_EDE_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 enabled. Possible risk of intermittent TLS failures if the algorithm version is different between clients and servers.
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.19041.2006 Deprecated No No No {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98} C:\Program Files\Common Files\System\Ole DB\sqloledb.dll
SQLOLEDB OLE DB 10.0.19041.2006 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 Yes Yes No No {397C2819-8272-4532-AD3A-FB5E43BEAA39} C:\WINDOWS\system32\sqlncli11.dll
SQLNCLI11 OLE DB 11.0.7462.6 Yes 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.19041.2006 Deprecated No No No C:\WINDOWS\system32\SQLSRV32.dll
SQL Server Native Client 11.0 ODBC 11.0.7462.6 Yes Yes No Yes C:\WINDOWS\system32\sqlncli11.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.19041.2006 Deprecated No No No C:\WINDOWS\SysWOW64\SQLSRV32.dll
SQL Server Native Client 11.0 ODBC 11.0.7462.6 Yes Yes No Yes C:\WINDOWS\SysWOW64\sqlncli11.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
------------------------------------------------------ ------ ---------------- -------------------------------------- ------------------------------------------------------------------------------------------------------- -------
Microsoft.ACE.OLEDB.12.0 OLE DB 16.0.15601.20054 {3BE786A0-0366-4F5C-9434-25CF162E475E} C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\Office16\ACEOLEDB.DLL
Microsoft.ACE.OLEDB.16.0 OLE DB 16.0.15601.20054 {3BE786A2-0366-4F5C-9434-25CF162E475E} C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\Office16\ACEOLEDB.DLL
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.19041.1889 {549365d0-ec26-11cf-8310-00aa00b505db} C:\WINDOWS\system32\activeds.dll
ADSDSOObject OLE DB 10.0.19041.1 {549365d0-ec26-11cf-8310-00aa00b505db} C:\WINDOWS\SysWOW64\activeds.dll
SQL Server Native Client RDA 11.0 ODBC 11.0.5069.66 C:\Program Files\Microsoft SQL Server\150\Shared\sqlnclirda11.dll
Microsoft Access Driver (*.mdb, *.accdb) ODBC 16.0.15601.20038 C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\Office16\ACEODBC.DLL
Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) ODBC 16.0.15601.20038 C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\Office16\ACEODBC.DLL
Microsoft Access Text Driver (*.txt, *.csv) ODBC 16.0.15601.20038 C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\Office16\ACEODBC.DLL
Driver da Microsoft para arquivos texto (*.txt; *.csv) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Driver do Microsoft Access (*.mdb) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Driver do Microsoft dBase (*.dbf) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Driver do Microsoft Excel(*.xls) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Driver do Microsoft Paradox (*.db ) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Microsoft Access Driver (*.mdb) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Microsoft Access-Treiber (*.mdb) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Microsoft dBase Driver (*.dbf) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Microsoft dBase-Treiber (*.dbf) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Microsoft Excel Driver (*.xls) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Microsoft Excel-Treiber (*.xls) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Microsoft ODBC for Oracle ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\msorcl32.dll
Microsoft Paradox Driver (*.db ) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Microsoft Paradox-Treiber (*.db ) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Microsoft Text Driver (*.txt; *.csv) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Microsoft Text-Treiber (*.txt; *.csv) ODBC 10.0.19041.1 C:\WINDOWS\SysWOW64\odbcjt32.dll
Processes that have SQL Server (and some other) Drivers Loaded:
Process Name Process ID Drivers Loaded
-------------------- ---------- -----------------------------------------------------------
DSAUpdateService.exe 8996 system.data.dll
sqlceip.exe 6456 system.data.dll
SQLCheck.exe 12416 system.data.dll
sqlservr.exe 2460 odbc32.dll, msoledbsql.dll, sqlncli11.dll, sqlnclirda11.dll
SurSvc.exe 6216 system.data.dll, system.data.oracleclient.dll
No SQL Aliases were found on this machine.
No SQL Client Driver SNI settings were found.
-------------------------------------------------------------------- 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
----------------------------------- ------------ --- ---------------------------------------- ----------- ------- --------- -------- ----- ----------- ------------------- ------------------- ----------
IIS Express Development Certificate CN=localhost 2092B42FB6435045B0F58991C16CB565B63071A1 2048 sha256RSA Exchange Yes 13.09.2022 14:30:40 13.09.2027 03:00:00 Not server
Services of Interest:
Name Instance Description PID Service Account Domain Account Start Mode Started Status
------------ ---------- ------------------------------------ ---- ---------------------------------- ---------------------------------- ---------- ------- ------
MSDTC Da§ t lm Ÿ ˜Ÿlem D zenleyicisi 0 NT AUTHORITY\NetworkService DESKTOP-B4JHKV8 Manual False OK
MSSQL SQLEXPRESS SQL Server (SQLEXPRESS) 2460 NT Service\MSSQL$SQLEXPRESS NT Service\MSSQL$SQLEXPRESS Auto True OK
RpcSs Uzaktan Yordam €a§r s (RPC) 716 NT AUTHORITY\NetworkService DESKTOP-B4JHKV8 Auto True OK
SQLAgent SQLEXPRESS SQL Server Agent (SQLEXPRESS) 0 NT AUTHORITY\NETWORKSERVICE DESKTOP-B4JHKV8 Disabled False OK
SQLBrowser SQL Server Browser 0 NT AUTHORITY\LOCALSERVICE DESKTOP-B4JHKV8 Disabled False OK
SQLTELEMETRY SQLEXPRESS SQL Server CEIP service (SQLEXPRESS) 6456 NT Service\SQLTELEMETRY$SQLEXPRESS NT Service\SQLTELEMETRY$SQLEXPRESS Auto True OK
SQLWriter SQL Server VSS Writer 6256 LocalSystem DESKTOP-B4JHKV8 Auto True OK
TermService Uzak Masa st Hizmetleri 1176 NT Authority\NetworkService NT Authority\NetworkService Manual True OK
W3SVC World Wide Web Yay mlama Hizmeti 6188 localSystem DESKTOP-B4JHKV8 Auto True OK
Warning: Da§ t lm Ÿ ˜Ÿlem D zenleyicisi start mode is set to Manual.
Warning: SQL Server Agent (SQLEXPRESS) start mode is set to Disabled.
Warning: SQL Server Browser start mode is set to Disabled.
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 SQLEXPRESS False
Details for SQL Server Instance: SQLEXPRESS (Express Edition)
Version: 15.0.2000.5 SP 0 Patch Level: 15.0.2000.5
Clustered: False
Always-On: False
Authentication Mode: WINDOWS-ONLY
Certificate: Self-generated certificate
ForceEncryption: False
Hidden Instance: False
Extended Protection: Off
Shared Memory Enabled: True
Named Pipes Enabled: False
TCP Enabled: True
Listen on all IPs: True
Keep-Alive Interval (ms): 30000
TCP Port(s): 1433
Dynamic TCP Port(s): 53844
Install Path: C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Binn
ERRORLOG Path: C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\ERRORLOG
Current Process ID: 2460
Service Account: NT Service\MSSQL$SQLEXPRESS
SPN Account:
-------- End of Report -----------