Re: Directions on how to install SQL 2000 not as Windows admin

From: Chris Wilkins (ChrisWilkins_at_discussions.microsoft.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 08:23:01 -0700

I'm betting the question is "How do I install SQL 2K and configure it so the Service Account is something besides the Local System or an Admin Account". If that's the case, create an account you want the service to run with and then specify that account during the install. If you've already installed, then go into Enterprise Manager and select the Security Tab. Type in the account info there and click on OK. SQL with then apply the correct security permissions to that account. If you do it in the Services portion of computer manager, the security permissions won't be applied and the service will not start.

"Steve Kass" wrote:

> Is your question how to install SQL Server from a Windows account that
> does not have Windows administrator rights, or is your question how to
> install SQL Server so that the Windows user who installed SQL Server
> cannot connect to the new SQL Server as SQL Server system administrator,
> or is you question something about post-installation SQL Server setup?
> I don't think you can do either of the first two, simply because the
> installation makes changes to both Windows and SQL Server that should
> not be allowed by someone without administrator privileges.
>
> In any case, it would help if you could be more specific about whether
> "account" means Windows account, SQL Server account (login), or
> something else, whether SysAdmin refers to the SQL Server system
> administrator role or something else, and what you mean by "setting up".
>
> Steve Kass
> Drew University
>
> Hal wrote:
>
> >I appreciate the response, but it wasn't helpful.
> >
> >I am certain Microsoft has produced a guide to setting up a SQL Server 2000 with an account that is not SysAdmin. I want a link to that guide.
> >
> >If there isn't a guide, then someone should surely write one.
> >
> >"Steve Thompson" wrote:
> >
> >
> >
> >>"Hal" <Hal@discussions.microsoft.com> wrote in message
> >>news:EE70A9F1-FC92-4381-8428-8D01475E4B7C@microsoft.com...
> >>
> >>
> >>>Can someone point me to the KB article, guide, or white paper on how to
> >>>
> >>>
> >>install SQL Server 2000 using a Windows account that is not system
> >>administrator for the the server?<
> >>
> >>Hmmm, typically you need to have local administrative rights to perform
> >>application installs. Perhaps you could negiotiate, or create (depending on
> >>your position on this ;), a local account that has administrative rights,
> >>use that for the install, then disable the account once SQL Server is
> >>installed.
> >>
> >>Steve
> >>
> >>
> >>
> >>
> >>
> >>
>
>

Relevant Pages

  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)
  • Re: SBS Client Connection Problem
    ... The application that is connecting to SQL server gives "object doesn't ... In Windows Explorer I get "an error ... What's the exact problem symptom of the problematic workstation cannot ... Click the Services tab, click to check the "Hide All Microsoft ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)