Blazor Server Application - SQLExpress problem

Cenk 1,021 Reputation points
2022-09-22T18:43:55.76+00:00

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)  
Internet Information Services
Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,611 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,126 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Cenk 1,021 Reputation points
    2022-09-23T05:32:27.577+00:00

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

    0 comments No comments

  2. 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 -------------------------------------------------------------------------  
      
    
    0 comments No comments

  3. Bruce (SqlWork.com) 67,916 Reputation points
    2022-09-23T16:41:39.587+00:00

    try connecting by server name instead of instance name.

    0 comments No comments

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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.