Thursday, March 29, 2012

Directions on how to install SQL 2000 not as Windows admin

Can someone point me to the KB article, guide, or white paper on how to inst
all SQL Server 2000 using a Windows account that is not system administrator
for the the server?"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|||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...
> 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 o
n
> 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
>
>|||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:
[vbcol=seagreen]
>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:
>
>|||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 Ma
nager 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 accoun
t. If you do it in the Ser
vices 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:
>
>sql

No comments:

Post a Comment