I have SQL Server 2000 SP3 server running on W2003 SP1 Std that is setup to
run under a domain account with local admin privileges. The server and
user
account are in the same domain.
When I then try to register the SQL Server instance via SQLEM, running
with
my privileges and I also have local admin to the SQL Server server and
have
the same setup for other servers already in place, I get an error saying
"Cannot generate SSPI context"
Does anyone have any ideas on how I can correct this?
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)
Re: Table loseing primary key when not local admin? ...sufficient rights or a proper initial catalog defined. ... When a user is using the app we developed, ... > if they are a local admin it works perfectly fine... ... > permissions on sql server or just .NET stuff? ... (microsoft.public.dotnet.framework.adonet)
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)
Re: SQL Server Remote Management - Command Line Question ... If you are a local admin on the Win2K box that is running ... or isql to add, delete, change logins, users in SQL Server.... If you disable or delete the users Windows account when the ...>rights on the machine, be able to log into that machine remotely and somehow ... (microsoft.public.sqlserver)
Re: Cant edit logins or server roles ... A windows local admin may have sysadmin access for a SQL Server... don't seem to be a member of sysadmins. ... (microsoft.public.sqlserver.security)
