Post reply

Which table is the SQL server and Agent accounts located

  • November 20, 2007 at 1:21 pm

    #76824

    Hello,

    I'm not sure if this belongs in this forum or the newbie forum. I'm trying to find out where the SQL Server and Agent accounts are located. I'm in the middle of moving around 80 SQL servers on different domains into one domain. Asides from looking in the Control Panel\services or the SQL Enterprise manager is there a table where I can query this information. With all these servers, I want to keep track of which server has what for the SQL Server service and Agent account.

    Thanks

    -Ryan

  • November 26, 2007 at 10:45 am

    #754150

    This is in Control Panel Services. The MSSQLServer service and SQLAgent services are the defaults. Multiple instances will have the instance name listed.

    It's in the registry as well. More info here: http://support.microsoft.com/kb/283811

Viewing 2 posts - 1 through 1 (of 1 total)

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