Re: ?? unable to access SQL Server w/ sa account unless user is Administrator on local machine

From: Daniel Pratt (dprREMOVETHISatt71@hotmail.com)
Date: 09/06/02 

From: "Daniel Pratt" <dprREMOVETHISatt71@hotmail.com>
Date: Fri, 6 Sep 2002 08:20:58 -0400

Hi Tolga, Ron,

"Ron Talmage" <rtalmage@prospice.com> wrote in message
news:e3PR$IWVCHA.2964@tkmsftngp11...
> Daniel,
>
> Check to see what kind of authentication your SQL Server is set to. If
it's
> Windows only, and if your account belongs to the local admins group, the
sa
> login will succeed but you'll actually log in using a trusted connection.
> Then when the account is removed from the local admins group, the login
will
> fail, because sa is a SQL login, not a Windows trusted login.

    Thanks for your responses. I'm sure that SQL Server is configured to
accept SQL Server and Windows authentication. I suppose it's possible that
some wierd set of circumstances has the app trying to use a trusted
connection, so I will experiment with disabling the BUILTIN\Administrators
group.

Regards,
Dan