I have SQL Server Express installed locally on a machine and it works most of the time but occasionally it fails to make a connection with this error:
Could not obtain information about Windows NT group/user 'MYDOMAIN\myUser', error code 0x6fd.
I'm at a loss for what to change. I can't guarantee the laptop can see the domain controller at all times because - well - it's a laptop! But it would seem that has no effect anyway (it works when disconnected from the network usually; it fails when connected sometimes).
Here's the SQL Server connection string:
Data Source=localhost\MYINSTANCE;Integrated Security=True;Initial Catalog=myDbName;Connection Timeout=15
What should I do?
I've tried moving it to a localdb and using SQL authentication to the SQL Server Express instance. Both ways STILL FAIL with the "could not obtain information..." message. They succeed if there is no network at all, but they all fail if there is a network that isn't the domain one. Not sure what the next move should be...