Search code examples
sql-serverauthenticationblazorsql-default-instance

How do I get my Blazor app to see my local SQL Server for authentication?

I'm starting with a vanilla Blazor app in Visual Studio 16.3.7 with authentication: enter image description here

I go to the Register page: enter image description here

I fill in the email and password fields, click the Register button, and after a long think it fails with this error:

An unhandled exception occurred while processing the request. Win32Exception: Unknown error (0x89c50118) Unknown location 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 connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot create an automatic instance. See the Windows Application event log for error details. ) Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, object providerInfo, string newPassword, SecureString newSecurePassword, bool redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, bool applyTransientFaultHandling, string accessToken, DbConnectionPool pool, SqlAuthenticationProviderManager sqlAuthProviderManager) Stack Query Cookies Headers Routing Win32Exception: Unknown error (0x89c50118) Show raw exception details ...

When I go to my Windows Event Viewer, the following error seems relevant: enter image description here

Any suggestions for fixing this?

Solution

  • I used the Registry Editor to delete the UserInstances key with the older ParentInstance. Now my registry looks like this: enter image description here

    And I'm getting a different error in my Blazor app.

    Thank you Henk for pointing me in the right direction!