|
|
Posted by Erland Sommarskog on 06/14/06 21:31
(Eng.Rana@gmail.com) writes:
> thats a gr8 help, i really appreciate it :).
>
> but i was wondering, what if the client and server were of different
> domains, shall we be using only the SQL authentication only???
Unless you can set up some trust between them you need to use SQL
authentication.
Here I need to add this is a question that requires good knowledge about
Windows networking, which I do not possess.
> if yes, is there any other situation where we can't use windows
> authentication???
If you don't have a domain at all, but only a Workgroup, Windows
authentication can be difficult. Username and password must match,
but this may not be enough. For instance, I run virtual machines on
my comnputer at home, and from the host machine I connect to SQL Server
on the virtual machines with Windows authentication, and and Windows
authentication also works between virtual machine. But it does not
work from virtual machines to the SQL Server instances on the host
machine.
If the client comes from a non-Windows OS it may be even more difficult
to use Windows authentication. Obviously.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|