Cross Domain authentication for SQL 2000


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?
Who is Participating?
momi_sabagConnect With a Mentor Commented:
sql authentication would do the job for sure
you can also use windows authentication if you define your domains to trust each other
in sql 2005 you would be able to use certificates
kecoakAuthor Commented:
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?
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.