Post reply

service account

  • June 25, 2010 at 1:12 am

    #96823

    Hi,

    Small clarification.

    In SQL 2005/2008 we have Sql server Configuration Manager to change the domain accout for SQL SERVER and SQL AGENT services. I know the reason why only we need to edit the credentials in sql config mgr. it adds some permissions in the Actve Dir while using Linked Servers..

    I want to do the same in SQL Server 2000 but i could'nt find the similar kind of utility in sql 2000.

    In SQL 2000, Can i directly go and change the account in services.msc or else do i need to Right click the instance -->Properties -->

    under Security tab, startup service account???

    Thanks in Advance

  • June 25, 2010 at 11:38 am

    #1185166

    I have always used service.msc to change the accounts for SQL 2000. I don't believe its any more scientific than that - just make sure that account has permission in SQL beforehand.

  • June 25, 2010 at 2:31 pm

    #1185261

    In SQL2000 always change the accounts SQL services run under via properties ---> security in enterprise manager

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

  • June 26, 2010 at 12:20 am

    #1185325

    Thank You All.

    It worked fine.

Viewing 4 posts - 1 through 3 (of 3 total)

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