Re: power user logon SBS2003

From: Bart Timothy (btimothy_at_earthlink.net)
Date: 03/07/04 

Date: Sat, 6 Mar 2004 23:22:31 -0700

We only need one computer for the app (data collection for a SCADA system).

I've seen 2 installations of SBS2000 runing without active directory. I
don't know how it was done. Those servers never did automatic shut downs
once an hour when AD wasn't enabled. There are lots of regular servers
running out there without AD. Server without AD is pretty much like 2000
Pro from a regular users standpoint, so why can't it be used like a
workstation?

The software vendor never said anything about using MSDE. We found out
about it's existance after our OS purchase and I don't think the vendor
supported it anyway. After all the problems we had getting the app to run,
I wonder if we'd ever got it p and running with out the SQL tools we used in
getting the old data base converted and imported. I admit to not knowing
much about SQL and nothing about MSDE.

I don't agree that two computers, one SBS and one a workstation, are cheaper
to purchase and maintain than one computer running regular server and SQL.
SBS by itself would have been the cheapest option for us, if it would work.

So, the botom line must be none of you gurus can tell me how get a power
user to do a local logon to SBS2003, which is the question I asked in the
first place.

We'll bite the bullet and add a workstation.

Thanks

"Chad A. Gross [SBS-MVP]" <chad.gross@laytonflower.nospam.com> wrote in
message news:uoIQqG1AEHA.2768@tk2msftngp13.phx.gbl...
> Um Bart?
>
> A couple things: 1) Why does a Power User need to log on to the SBS? It
> sounds as if you want the power user to use the SBS as a workstation to
run
> this app. SBS (or any server for that matter) should never be used as a
> workstation. If you only have one user who needs to use this app, why not
> just load up MSDE on a workstation & install the app? If that doesn't
work,
> having two boxes - one SBS running SQL and one workstation to run the app
is
> still going to be a whole hell of a lot less expensive than full products
of
> Windows Server & SQL Server. And just to clarify - Active Directory was a
> fundamental requirement of SBS2000 as well . . . ;^)
>
> --
> Chad A. Gross - SBS MVP
> SBS ROCKS!
>
>
> Bart Timothy wrote:
> > We purchased SBS2003 Premium for the sql portion only. Seemed like a
> > good deal. This was apparently a mistake. Our software vendor had
> > never loaded his app on SBS2003 before. Tweaked SBS2000 had worked
> > for him. Should have purchased 2000 instead.
> >
> > The application which uses sql, needs at least power user rights to
> > operate. Security isn't of concern to us, but keeping the computer
> > locked down from unnecessary changes from normal users is. Having
> > regular users with power user rights is bad enough, but giving them
> > all administrtive rights goes beyond the line for us. Especially
> > with an OS as complicated as SBS.
> >
> > Thankyou Microsoft, for offering such a great deal on SBS and then
> > FORCING us to use active directory when sql is all we needed. We'd
> > been better off using SBS2000, or paying the extra bucks for regular
> > server and sql. Because now we need to use 2 computers where only 1
> > box could do the job.
> >
> > Bart
> >
> > <<in our case SBS sucks!!>>
> >
> >
> > "Javier Gomez [SBS MVP]" <javier_gomez@remove.this.engineer.com>
> > wrote in message news:OCOQBvmAEHA.1036@TK2MSFTNGP10.phx.gbl...
> >> Ok... I will bite: Why?
> >>
> >> You have to change the domain policy for that... it is a very bad
> >> idea.
> >>
> >> --
> >> Javier [SBS MVP]
> >>
> >> << SBS ROCKS !!! >>
> >>
> >> "Bart Timothy" <btimothy@earthlink.net> wrote in message
> >> news:eGVCcFfAEHA.1548@TK2MSFTNGP12.phx.gbl...
> >>> How do you get a power user to be able to do a local logon in
> >>> SBS2003?
> >>>
> >>> thanks
>
>

Relevant Pages

  • Re: SBS and SQL on Client Computer
    ... I do have a site with SBS 2003 premium ... without SQL server installed, and a workstation does have BCM too, but I ... A default Office install doesn't have ...
    (microsoft.public.windows.server.sbs)
  • Re: sql server 2005
    ... If you were then considering R2 upgrade to get 2005 workgroup then really I would be asking your app developers why they cant use 2000. ... Apart from additional monitoring and GUI screens there is only ONE benefit going to workgroup edition from 2000 which is related to datatypes, ... An app for a business in SBS land requires SQL, with the costs of seperate purchase of SQL they must be putting themselves out of the market... ...
    (microsoft.public.windows.server.sbs)
  • Fehler beim Verbinden zu SQL DB (MSDE)
    ... Windows SBS 2003 Professionel Server ... Workstation mit Installierter MSDE und der Office Business Contact ... Ursache: Keiner vertrauten SQL Server-Verbindung ...
    (microsoft.public.de.inetserver.iis.asp)
  • Re: SQL Service in SBS
    ... The SBS 2003 newsgroup is microsoft.public.windows.server.sbs. ... Basically it is a SQL db for project ... There will be about four users that will be using the new app. ... Not to mention the cost of backup software ...
    (microsoft.public.backoffice.smallbiz)
  • Re: power user logon SBS2003
    ... 1) Why does a Power User need to log on to the SBS? ... If you only have one user who needs to use this app, ... Windows Server & SQL Server. ...
    (microsoft.public.backoffice.smallbiz2000)
Loading