Hi all, this is a really wierd problem that any help anyone could offer would be greatly appreciated.
My company uses a program which is accessed by users and requires their account logon from our active directory on one of our servers. For some reason as of this morning this logon process does not work for some users, they are given two errors
"Login failed for user. The user is not associated with a trusted SQL Server connection"
"[DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied"
This error is not for all users only a select few, I have examined the SQL server and the permissions for domain users seems to be correct. The active directory is working okay as users are able to log into their workstations in the first place without a problem.
It then occured to me that all the users with the problem were running Windows 7, however some users who are able to log in are also running Windows 7. Upon further analysis all the users with the problem are running Windows 7 X86. I was wondering if this is mearly a coincidence or if there is some associated problem with X86 7.
Any help anyone can give on this issue would be SO greatly appreciated as I am somewhat at a loss!