Link to home
Start Free TrialLog in
Avatar of kecoak
kecoak

asked on

Cross Domain authentication for SQL 2000

Guys,

I have a web server located in domain A and needs to connect to a SQL Server in domain B
what would be the best solution to authenticate to SQL server in domain B?
Can i use Windows authentication or SQL authentication is the only option?
ASKER CERTIFIED SOLUTION
Avatar of momi_sabag
momi_sabag
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kecoak
kecoak

ASKER

what are the option? i Am assuming that if domain A trust domain B, all the computer in Domain A will have access to domain B.

Can you explain me more on using certificates in SQL 2005? Does this mean that the web server need to import certificate to be used to connect to SQL 2005?
Avatar of momi_sabag
momi_sabag
Flag of United States of America image
it means that if the web server is at a different domain, it can connect to sql server using certificate authentication even if there is no trust between the domains