|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
AuthenticationLet'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 Hi
If there is no trust relationship between the two domains (computers) then you can not use Windows Authentication. John Show quote "christof" <nom***@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 Show quote "John Bell" wrote: > Hi > > If there is no trust relationship between the two domains (computers) then > you can not use Windows Authentication. > > John > > "christof" <nom***@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 > > > 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 Show quote "bk" wrote: > 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" <nom***@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 > > > > > >
Other interesting topics
|
|||||||||||||||||||||||