Re: Installing SPS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Shane Young (syoung)
Date: 03/15/05


Date: Tue, 15 Mar 2005 14:55:19 -0500

I will have to say I am not 100% sure. I always use local admin. I know
that SQL wants the user to be a local admin on the SQL box. So I don't know
for sure. Give it a shot and see what you get. Be sure that the user also
has permissions to any content you want to crawl.

-- 
Shane Young
http://www.lucruminc.com
"dwisby" <dwisby@discussions.microsoft.com> wrote in message 
news:C4EFB176-38FE-4F60-BBB4-405AED1A184F@microsoft.com...
> Shane, by the way, does PowerUser permission work for everything?
>
> David Wisby
>
> "Shane Young" wrote:
>
>> I use 1 account for everything.  Really depends on how security conscious
>> you want to be.
>>
>> Do you have a copy of the "SharePoint Products & Technologies Resource 
>> Kit"?
>> I think it will carry you through most of your immediate needs.
>>
>> -- 
>> Shane Young
>> http://www.lucruminc.com
>>
>>
>> "dwisby" <dwisby@discussions.microsoft.com> wrote in message
>> news:4460BFB8-9E87-426D-BA3E-EF7992C07E04@microsoft.com...
>> >I have been asked to set up SPS for our Data Management team, however 
>> >have
>> >no
>> > prior experience with this product.
>> > In the initial installation it asks to create an account and place in 
>> > the
>> > local PowerUsers group and use it as the Config DB Admin. The account I
>> > used
>> > is a domain account created for this install. In the section "Default
>> > Content
>> > Account" it says you can use a different account for this and the 
>> > Portal
>> > Site
>> > Application Pool Identity. It states that this account will be used for
>> > the
>> > CentralAdminAppPool. Can I use the same domain account for all of these
>> > settings? If not what should I use,i.e. another domain account created
>> > specifically for this or some user that will be involved with
>> > Administration.
>> > I would like to use the specific account I created in the beginning, as
>> > this
>> > account is not related to a user that may leave our employ.
>> > Sorry to be long winded and making this clear as mud, but as I said 
>> > this
>> > is
>> > my first run at SPS and I would like to get it right the first time.
>> > Oh and by the way, this won't be my last question submitted. :-)
>> > Any help would be greatly appreciated.
>> >
>> > Thanks
>> >
>> > David Wisby
>>
>>
>> 


Relevant Pages

  • Re: Users
    ... To change sa login do I connect via an ODBC connection - and is an account with local admin on my machine would accomplish that change. ... What type of access would you allow network engineers to have in sql, the main functionality is a network back up they run and include SQL in that. ...
    (microsoft.public.sqlserver.server)
  • Re: DTS fails on job but runs manually
    ... Basically the issue was that the sql account did not exist on my destination ... When executed by the SQL Agent your DTS package runs as the local admin ... making use of resources outside the machine where the SQL Server runs. ...
    (microsoft.public.sqlserver.dts)
  • Re: Domain Profiles Borked - Cant Grant Admin Rights - HELP!!!
    ... > status of their account. ... local Admin rights were given to ... > afflicted machine and give them local Admin rights, ... the SID of your users is no longer the same as it was. ...
    (microsoft.public.windowsxp.setup_deployment)
  • RE: local admin account password
    ... Do you think if someone wanted to break the local admin account they ... more recovery console and don't think cached logins will work. ... 5)My main idea/plan is to store all the passwords on a central SQL server. ...
    (Focus-Microsoft)
  • Re: Problems installing SQL Server 2005 in two node cluster
    ... the SQL Server service account does not need to be a local admin. ... > -> Purging the setup files from the registry with the Windows Install ...
    (microsoft.public.sqlserver.clustering)