Forum Discussion
How to allow Kerberos authentication on SQL Express?
A self signed certificate has been installed on SQL Express but the WinUI UWP app still will not connect. The server log says:
> SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.
I am not able to connect to SQL Express with the Inventory.Sample.
Inventory Sample on GitHub Putting "TrustServerCertificate=True" at the end of the connection string fails.
This connection string works in a console app to test ado connection "using Microsoft.Data.SqlClient;".
string connString = @"Data Source=.\SQLEXPRESS;Initial Catalog=VanArsdelDb;Integrated Security=SSPI;TrustServerCertificate=True;"; ​
The app and SQL Express are both on the same box.
No RepliesBe the first to reply
