question

Cenk-1028 avatar image
0 Votes"
Cenk-1028 asked ErlandSommarskog answered

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)



sql-server-generalwindows-server-iisdotnet-aspnet-core-blazor
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

The error is extremely clear. There's not much the community can do as we cannot see your machine. You might try.

 Data Source=.\\SQLExpress;

If you don't know the SQL instance name then use Visual Studio's SQL Object Explorer on the Windows machine. Otherwise read the docs or do a Google search.

SQL Server Express User Instances

Google


0 Votes 0 ·

"DefaultConnection": "Data Source=.\\SQLEXPRESS;Initial Catalog=InventoryManagement;Integrated Security=True",

Didn't work. Same error.

0 Votes 0 ·

Please check the SQL check tool report that I posted.

0 Votes 0 ·
Cenk-1028 avatar image
0 Votes"
Cenk-1028 answered

SQL Server Express is listening on a dynamic port and a static port(1433). I checked the TCP/IP properties.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cenk-1028 avatar image
0 Votes"
Cenk-1028 answered Cenk-1028 published

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 -------------------------------------------------------------------------
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Bruce-SqlWork avatar image
0 Votes"
Bruce-SqlWork answered

try connecting by server name instead of instance name.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.)

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.