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

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

From: "Daniel Pratt" <dprREMOVETHISatt71@hotmail.com>
Date: Thu, 5 Sep 2002 08:59:58 -0400

    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

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)