• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 596
  • Last Modified:

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?
0
kecoak
Asked:
kecoak
  • 2
1 Solution
 
momi_sabagCommented:
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
0
 
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?
0
 
momi_sabagCommented:
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
0
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.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now