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

From: Steve Kass (skass_at_drew.edu)
Date: 06/27/04

  • Next message: Robert D. Pinkerton: "Re: Security for Visual Studio.Net" 
    Date: Sat, 26 Jun 2004 23:50:11 -0400

    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
    >>
    >>
    >>
    >>
    >>
    >>

  • Next message: Robert D. Pinkerton: "Re: Security for Visual Studio.Net"

    Relevant Pages

    • Windows Authentication with IIS on separate machines
      ... -Web Application is using Basic Authentication set in IIS ... -Added user account TESTUSER and gave read access to ... in SQL server but doesn't work if user account was ... Windows account, ...
      (microsoft.public.sqlserver.security)
    • RE: Services login policies and rights question
      ... I learned you failed to install SQL Server Clustering using SQL Service ... An account must be created for the administration and ownership of the ...
      (microsoft.public.sqlserver.clustering)
    • RE: DTS Error
      ... I right click on the SQL Server Agent properties, ... Windows Account and the "Connection" also under Windows Account. ... > Any member of the sysadmin role and the job executes as the SQL Server ...
      (microsoft.public.sqlserver.dts)
    • Re: service accounts setting up 2008
      ... using one Windows account for every service is ... account and specify this account' s information during SQL Server setup. ... NT AUTHORITY/NETWORK SERVICE ...
      (microsoft.public.sqlserver.setup)
    • Cant Set Domain User Account To Use on Services Accounts Screen
      ... I'm trying to install SQL Server 2000 Developer's Edition on Win XP Pro with ... same account for each service. ... SQL Server in Windows Firewall. ... "The logon account cannot be validated for the SQL Server service. ...
      (microsoft.public.sqlserver.setup)