• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 585
  • 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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

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