This question goes above the context of OrmLite, but I’m trying to get it working with OrmLite at the moment. I need to connect to Sql Server from a non-domain machine with the server only allowing trusted connections via a domain login (a la Trusted_Connection=True). Is this possible? I know it can be done via the *nix library FreeTDS somehow (a Mac SQL client is connecting fine that uses FreeTDS), so I’m hoping there’s some possibility of doing it in C#. I’ve tried a few things using WindowsImpersonationContext but not getting very far. These kinds of authentication things go past my expertise.
I’ve posted on SO. In the meantime, I just thought of something…won’t this be an issue when people start running .NET Core apps/sites on a Linux instance where the site needs to connect to a SQL Server via trusted auth?