Anyone experienced this before...
Windows 2008 Cluster on SQL 2005 SP3 cluster domain abc
Windows 2008 Cluster on SQL 2005 SP3 cluster domain xyz
Two way trust exists between the 2 domains.
Adding user xyz\user to sql server on domain abc and getting the following error
Msg 15401, Level 16, State 1, Line 1
Windows NT user or group 'xyz\user1' not found. Check the name again.
The windows firewall is disabled on the clusters. DB collation is CI
I tried adding the same account to SQL Sp3 on a Windows 2003 (stand-alone) server in the abc domain and it worked.