We have a SQL Server 2008 database installed on a Windows Server 2008 server. This server was recently migrated to from a Windows Server 2003 configuration last month. After the migration, users have intermittently been having untrusted domain login failures, though all users workstations are connected to the domain. We are using Windows authentication solely for SQL Server access and all users are added as valid domain users in the database. Users connect to the database via an ODBC connection. Here is the error that is occurring:
SQL Sever ERROR: 18452
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication
Especially tricky is one user who had been able to connect with no issues for 2 weeks and now she cannot connect to SQL Server at all (one week and counting), receiving the above untrusted domain error. I had the user reboot their machine and relogin, change their domain user password and repeatedly try to log into the database with no success. Nothing has changed with her account or the SQL Server backend.
Other users have had similar problems but they either go away by themselves once they relogin to the domain or after their Windows 2008 domain accounts have been recreated and readded to SQL Server. I would like to determine what could be causing these intermittent untrusted domain problems since this is very disruptive for our users and I receive calls regarding these errors from different users every day. Has anyone encountered this type of issue and does anyone have any advice, suggestions or troubleshooting tips that can be used to resolve this issue?