Re: Create a minimun rights account

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

Date: Thu, 11 Nov 2004 18:23:02 -0800

ok, thank you.

sorry for my stupidity

"Marina Roos [SBS-MVP]" wrote:

> 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: 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: 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)
  • 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)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)