Is there any disadvantage to running a SQL Server in Windows Authentication mode only?

Gurus,
Is there any disadvantage to running a SQL Server in Windows Authentication
mode only?
Spin
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:9DCDECEE-E65A-4244-B5D2-F3EBA33B12DE@.microsoft.com...
>I actually prefer to run in Windows Only mode. I do switch down to mixed
>mode when I have to, though (typically some darn app that doesn't support
>Windows login or Windows login cannot be used because of firewall/domain
>reasons).
Thanks TIbor. What makes you prefer to run in Windows Only mode?
|||Hello,
"Tibor Karaszi" wrote:

> I actually prefer to run in Windows Only mode. I do switch down to mixed mode when I have to, though
But what in bellow situation:
Two active directory domains CompanyA.local (NetworkA) and CompanyB.local
(NetworkB).
NetworkA and NetworkB connected by VPN.
NetworkA:
srvsql.CompanyA.local
NetworkB:
srvsql.CompanyB.local
All ports open between srvsql.CompanyA.local and srvsql.CompanyB.local, no
firewall.
I have DOMAIN ADMIN account on each domain CompanyA\me, CompanyB\me,
unfortunately I can't connect to srvsql.CompanyB.local from
srvsql.CompanyA.local by WindowsAuthentication, I'm using SQl Logins and this
works.
How use WindowsAuthentication in this situation, where is the problem?
Regards,
anxcomp
|||I can think of one, because I have been limited by it before: consultants
cannot connect to the database with their laptop's, which in my case has 10+
years of acquired tools, scripts and knowledge stored on it. And no, I will
not ever connect my laptop up to another's domain.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Spin" <Spin@.invalid.com> wrote in message
news:63v8k4F28datlU1@.mid.individual.net...
> Gurus,
> Is there any disadvantage to running a SQL Server in Windows
> Authentication mode only?
> --
> Spin
>