Re: Create a minimun rights account

From: Marina Roos [SBS-MVP] (marina_at_roos.nodontwantspam.nl.com)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 03:12:53 +0100

Hi Jack,

I already told you: only a user with administrator rights can logon locally
to the server. I still don't understand why a user would need to use the SQL
server. To do what?? 

-- 
Regards,
Marina
Microsoft SBS-MVP
"JackMiller" <JackMiller@discussions.microsoft.com> schreef in bericht
news:3D1F8447-9CE8-410F-9102-EB849DF7EE81@microsoft.com...
> Dear Marina,
>
> Thank you for replying my questions. Basically, I am loading all the SQL
> server and Reporting services stuff into the SBS2003. I am a beginning
> developer.
>
> The reason why I need to set up an account who can log on locally to the
> server with the least permission is that : I need to set up a user who can
> use the SQL server but at the same time, this user will have the least
> permission to do any other things on the SBS machine.
>
> Can you brief me which account role will allow log on locally to the
machine?
>
> "Marina Roos [SBS-MVP]" wrote:
>
> > Hi Jack,
> >
> > No go here. Only an administrator can logon locally to the server. Why
would
> > you need a user to do that anyway???
> >
> > -- 
> > Regards,
> >
> > Marina
> > Microsoft SBS-MVP
> >
> > "JackMiller" <JackMiller@discussions.microsoft.com> schreef in bericht
> > news:A6213C0E-1FBB-4008-A9EE-BBCFDCF0FD22@microsoft.com...
> > > I would like to know how to create an account in SBS2003 who can log
on
> > > LOCALLY to the server with the least permissions?
> > >
> > > What role / group should this account belongs to?
> >
> >
> >

Relevant Pages

  • Re: Complete Neophyte Question(s)
    ... You should not have to go Google to find out what WITH GRANT means. ... Server comes with online documentation on you hard disk. ... WITH GRANT is one of the more esotheric features in SQL Server in my ... Or does that depend on the permission? ...
    (microsoft.public.sqlserver.security)
  • Re: Store procedure vs Direct statement ???
    ... sql also executes on the server. ... In response to your example of stored procedures having a security advantage ... When you give users permission to access tables you must be aware you have given ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Permission concept MSSQL05
    ... Each Server has its own security-DB where all the rolls are ... stored and their permission to each DB. ... Well, anything that worked in SQL 2000 will work in SQL 2005, but of ... there are tons of changes in the security area. ...
    (microsoft.public.sqlserver.security)
  • Re: Problems with SLP
    ... SQL is set up using mixed mode, ... >I have set up an SLP in the lab, and when trying to browse to the SLP web ... > "The machine-default permission settings do not grant Local Activation ... > permission for the COM Server application with CLSID ...
    (microsoft.public.sms.setup)
  • Re: Rights for a DBA
    ... You can do as Steve has said to give them start/stop etc permissions ... on the services of SQL, and also make sure that you have given them ... Server is not configured to run as Local System. ... > not give him Administrator rights to the Windows 2000 server itself. ...
    (microsoft.public.windows.server.security)