I'm working on an ASP.NET MVC app, following along a tutorial in CODE magazine. I'm doing this tutorial at home, with SQL Server 2019 Developer Edition installed on a Windows 10 Professional PC, named RazorCrest. I'm doing development on different Windows 10 Professional machine. Using the connection string from the article's tutorial, I've changed it to use RazorCrest, so it looks like this:
I'm doing this in a home environment, just peer-to-peer network.
When I tried to just verify the connection from the app, which just does a SELECT from a table with only a few records in it. However, it failed with this error:
Message=Failed to generate SSPI context.
Source=Core Microsoft SqlClient Data Provider
I've done this before with a different app, but in that case I used SQL Authentication instead of Windows authentication. In this case, the author of the tutorial is used Windows authentication. I had hoped I could use that, giving my Microsoft credentials when the attempt to open the connection came about, but as you can see by the error that didn't happen. I'm wondering, is it possible, given my peer-to-peer network, to make this work with Windows authentication? Or must I use SQL Authentication?