Re: Create a minimun rights account

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: JackMiller (JackMiller_at_discussions.microsoft.com)
Date: 11/12/04 

Date: Thu, 11 Nov 2004 18:09:01 -0800

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: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • 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: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)