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

From: Ron Talmage (rtalmage@prospice.com)
Date: 09/06/02 

From: "Ron Talmage" <rtalmage@prospice.com>
Date: Thu, 5 Sep 2002 22:00:59 -0700

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.

Ron 

--
Ron Talmage
SQL Server MVP
"Daniel Pratt" <dprREMOVETHISatt71@hotmail.com> wrote in message
news:#PQIAwNVCHA.1716@tkmsftngp08...
>     We've encountered a wierd security problem with our app and SQL
Server.
> We're doing more testing, but I'm hoping someone has a clue as to what is
> going on here.
>
>     We have a client machine running XP and our app. The app connects to
SQL
> Server on another machine using "sa" and a password. SQL Server is
> configured to accept both types of authentication. If the logged-in domain
> user belongs to the local Administrators group, our app connects fine. If
> the user does not belong to the local Administrators group, the app fails
> with the typical "access denied" error:
>
>         Error (-2147467259) [DBNETLIB][ConnectionOpen (Connect()).]SQL
> Server does not exist or access denied.
>
>     What possible difference could membership in the local Administrators
> group make to connecting to SQL Server with a SQL Server user account?
>
>     Thanks for any help.
>
> Regards,
> Dan
>
>