I have a SQL server 2005 in A domain, Windows Authentication, use domain user as SQL server service account. I have some developers in B domain, trusted with A domain. They failed to connect SQL server via Windows Authentication. Please tell me how to resolve this problem. Thanks Gu
Well, it depends on the error your're getting and other basic troubleshooting steps. 1. Can they ping the SQL box from their domain? 2. Can they connect to a share on that SQL box? 3. Can they connect with SQL accts? In short you need to make sure you've got basic connectivity first... at a Windows level. I would test that first. Then I would test a connection with a SQL acct. If that works, then I would look at the rights the users are getting through the trust. You should have a Global group in domainA and put the domainB users in it. Then give rights in SQL to your Global group. Also, make sure they've got windows rights on the SQL box as windows auth in SQL will check windows rights before checking SQL rights. "GUSN2005" wrote: > I have a SQL server 2005 in A domain, Windows Authentication, use domain user > as SQL server service account. > > I have some developers in B domain, trusted with A domain. They failed to > connect SQL server via Windows Authentication. Please tell me how to resolve > this problem. > > Thanks > Gu >
