Help - Upgrade SQL 2000 to SQL 2008

  • local accounts work even on a domain, but you have to replicate them from machine to machine using the same username and password, much the same as you do in a workgroup. This uses passthrough authentication, its very difficult to manage as the users have to be in sync on each machine. If you have a Windows domain, use domain user accounts its a lot easier.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Perry Whittle (4/19/2010)


    local accounts work even on a domain, but you have to replicate them from machine to machine using the same username and password, much the same as you do in a workgroup. This uses passthrough authentication, its very difficult to manage as the users have to be in sync on each machine. If you have a Windows domain, use domain user accounts its a lot easier.

    That is true - but is such a hassle I don't even consider it worth the effort. Additionally, you can use a local account and grant access to network resources using the system itself - but then you have other issues to deal with.

    It's just easier to setup and manage using a domain user (non-privileged, of course).

    Just to be clear - there are times when using a local account is the right thing to do. However, in almost every case (except one, so far) - I have found that the requirements change later on and you end up changing to a domain user anyways. That one case I have is a particular product for a DR situation where we want the server up and available if something happens to AD - and if that happens, using a domain user the system would not be available.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Jeffrey Williams-493691 (4/19/2010)


    there are times when using a local account is the right thing to do.

    in my opinion only when using a windows workgroup

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Perry Whittle (4/20/2010)


    Jeffrey Williams-493691 (4/19/2010)


    there are times when using a local account is the right thing to do.

    in my opinion only when using a windows workgroup

    I think we agree on that point - like I said, I have one instance where the vendor is requiring a local account. But, that is a special case and I still disagree with their assertion.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply