Authentication

Let's say we've got 2 computers - [A] and [B] where is a SQL Server.
Is it possible to make user from [A] log into instance of SQL Server on
[B] with Windows Authentication? So is there a possibility to create a
user on [B] that will correspond exactly to [A], or not?
[A] and [B] could be totally independent (not in local network)
ThanksHi
If there is no trust relationship between the two domains (computers) then
you can not use Windows Authentication.
John
"christof" <nomail@.nomail.de> wrote in message
news:eQO7$cBUGHA.4492@.TK2MSFTNGP09.phx.gbl...
> Let's say we've got 2 computers - [A] and [B] where is a SQL Server.
> Is it possible to make user from [A] log into instance of SQL Server on
> [B] with Windows Authentication? So is there a possibility to create a
> user on [B] that will correspond exactly to [A], or not?
> [A] and [B] could be totally independent (not in local network)
> Thanks|||I have two trusted domain in the same forest, one Windows 2000 server(domain
A), and the other one is windows 2003 server(domain B), trust relationship
bet two domain seems working, I can access folder from both domain,
in domain B, I have a member server with windows 2003 server, an
application with SQL DB installed. application is web base application,
I logon to domain A, launch the application in domain B, using URL, next I
get a Enter network Password, with username, password, domain, I have to
logon to Domain B in order to access the application in Domain B.
My understanding of trust relationship between domain is I do not need to
logon to domain B again because is already trusted.
Please help me.
TQ
wcj
"John Bell" wrote:

> Hi
> If there is no trust relationship between the two domains (computers) then
> you can not use Windows Authentication.
> John
> "christof" <nomail@.nomail.de> wrote in message
> news:eQO7$cBUGHA.4492@.TK2MSFTNGP09.phx.gbl...
>
>|||Hi
If you have to login to the second domain then the trust relationship is
probably not correct. It may be that domain A trusts domain B but you not
vice versa.
John
"bk" wrote:
> I have two trusted domain in the same forest, one Windows 2000 server(doma
in
> A), and the other one is windows 2003 server(domain B), trust relationship
> bet two domain seems working, I can access folder from both domain,
> in domain B, I have a member server with windows 2003 server, an
> application with SQL DB installed. application is web base application,
> I logon to domain A, launch the application in domain B, using URL, next I
> get a Enter network Password, with username, password, domain, I have to
> logon to Domain B in order to access the application in Domain B.
> My understanding of trust relationship between domain is I do not need to
> logon to domain B again because is already trusted.
> Please help me.
> TQ
> wcj
> "John Bell" wrote:
>