|
|
Posted by Erland Sommarskog on 06/15/06 08:48
(Eng.Rana@gmail.com) writes:
> how can i only enforce sql authenticaion, although the only two options
> available are Windows authentication only or mixed mode.
>
> this means that there always has to be trust between domains or that
> they be on the same domain.
>
> else how can enforce SQL authentication only!!!!!
Not sure that I understand your question. You cannot configure SQL Server
to not permit Windows authentication at all. But if you put the SQL Server
machine in its own domain (or a workgroup), the only way to log in with
Windows authnetication is on the local machine.
Note that SQL authetnication is not dependent on domains trusting each
other.
--
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]
|