SQL Server Express is listening on a dynamic port and a static port(1433). I checked the TCP/IP properties.
Blazor Server Application - SQLExpress problem
Hello,
I have this Blazor Server Application, I deployed it to Windows 10 Pro. IIS 10 and SQL Express 2019 installed.
Here is my connection string:
"DefaultConnection": "Data Source=ABC\\SQLEXPRESS;Initial Catalog=InventoryManagement;Integrated Security=True",
Here is the error message:
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)
4 answers
Sort by: Most helpful
-
-
Cenk 1,021 Reputation points
2022-09-23T07:03:58.957+00:00 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 -------------------------------------------------------------------------
-
Bruce (SqlWork.com) 67,916 Reputation points
2022-09-23T16:41:39.587+00:00 try connecting by server name instead of instance name.
-
Erland Sommarskog 113.3K Reputation points MVP
2022-09-23T21:28:28.297+00:00 What you should do first of all is to apply the most recent Cumulative Update for SQL Server 2019. It's not really going to resolve your problem, but you are running the original release of SQL 2019, and there are tons of bug fixes and improvements in the CUs.
Before you try to get this working in Blazor, first try to connect to SQL Server through SSMS or SQLCMD. In this case you should be able to connect with
.\SQLEXPRESS
. If you get this working, we can start to fight with Blazor later. (I know nothing about Blazor myself.)