Re: Table loseing primary key when not local admin?



Yes, without access to the code, my first guess would be that the account
you have setup for the individual (I'm assuming SSPI security) does not have
sufficient rights or a proper initial catalog defined.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Brian Henry" <nospam@xxxxxxxxxx> wrote in message
news:O1wDwPTvFHA.3720@xxxxxxxxxxxxxxxxxxxxxxx
> This is just bugging me... We store our database on SQL Server 2000 with
> service pack 4 installed on it. When a user is using the app we developed,
> if they are a local admin it works perfectly fine... If they are not a
> local admin, the app throws an exception with the message "Table does not
> have a primary key"... any idea why someone who is logged into the network
> as a non-admin would have this happen to them? yet when someone is logged
> in as an admin (aka me) it does not? does it have anything to do with
> permissions on sql server or just .NET stuff? thanks!
>


.



Relevant Pages

  • Re: Problems installing SQL Server 2005 in two node cluster
    ... the SQL Server service account does not need to be a local admin. ... > -> Purging the setup files from the registry with the Windows Install ...
    (microsoft.public.sqlserver.clustering)
  • Re: All users can start and stop SQL Server?
    ... Riki's problem as I see it is that the local Admin on Machine B can stop and ... irrespective of SQL Server rights, they shouldn't be able to affect another ... SQL runs as a service and any local administrator ... >> The students log on with their own user name. ...
    (microsoft.public.sqlserver.security)
  • .mdbs and windows file security - any gurus??
    ... an in-house VB app. ... The Access file is then transferred via flash media to an ... get an error to the effect "cannot build database file". ... If they login to the destination PC as local admin or give ...
    (microsoft.public.access.externaldata)
  • Re: vb.net multi-user app
    ... > has been given local admin rights to the machines running the app. ... need to write their Apps to run on todays modern OS's in todays security ...
    (microsoft.public.vb.database)
  • Re: Registry
    ... open query analyzer using just my Windows login even ... though I'm not mapped into the logins on the sql server. ... I get in simply because I'm local admin. ...
    (microsoft.public.sqlserver.security)