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

From: Dan Guisinger (dan@atacomm.com)
Date: 09/06/02 

From: "Dan Guisinger" <dan@atacomm.com>
Date: Fri, 6 Sep 2002 10:37:29 -0700

OMG, someone else has the same problem we ran into
yesterday. Its not documented anywhere from what I can
see.

We wrote our app in VS.NET and its designed to use a
trusted connection to localhost, unless it can't find
one. Then it asks for a database, and in our office we
can tell it to pickup our SQL (MSDE) server using SQL
authentication and the account SA.

However we installed the application yesterday on 2
laptops for a local basketball organization using it for
registration, and one computer was to host the db, so
they could use two machines for entry.

However it didnt work. I could log into the server
laptop just fine using SA, as mixed mode was enabled.

However the remote machine, even though OSQL -L listed
the server, it could not connect, giving me the EXACT
same error message you are receiving.

So I'll repeat your cry for help........HELP! Please,
this is extreamly frusterating.

Thanks,

Dan Guisinger
Atacomm / Ataractic Corporation
>-----Original Message-----
> 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: SQL Server Dual Processors INSERTS take long time
    ... Just because a server ... all you might try adding a clustered index on the table. ... Andrew J. Kelly SQL MVP ... > for other parts of the app, that need to be done in real time. ...
    (microsoft.public.sqlserver.server)
  • Re: version & instances
    ... SQL 2000 SP3a for Antivirus app ... that same server, to avoid breaking any of those apps. ... MSDE has a limited database size ...
    (microsoft.public.sqlserver.msde)
  • Re: Accessing SQL Server w/ Forms on Intranet
    ... on to the SQL server." ... launched the application from a shared drive really shouldn't affect SQL ... Sam Santiago ... > which Forms process information much better then an ASP app communicating ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Invalid Seek Offset continued...
    ... Well shifting to MS SQL will be a very very big step. ... > As Aashish mentioned, network cards drivers may be causing this problem, I ... > also see this error a lot at one customer where the server RAID Controller ... >>> We are deploying a VFP8 app to several beta sites to replace an FPW ...
    (microsoft.public.fox.programmer.exchange)
  • SMS2003 and Dedicated SQL Server.
    ... I want to install the Site Server and the Site Database on ... a remote SQL computer). ... Server into the Local Administrators' group of the SQL ...
    (microsoft.public.sms.setup)