Service Service Accounts

  • Comments posted to this topic are about the item Service Service Accounts

  • Wow. I did not knew there are DMV's to see the Service accounts.

    Good to knew it.

    Very good question.

  • Your answer states:

    Correct answer:

    Query sys.dm_service_services, Query sys.dm_server_registry

    Explanation:

    After SP1 for SQL Server 2008 R2, there is a new DMV that allows you to query for the service accounts used for the various SQL Server services. You can also use the sys.dm_server_registry DMV to find the information, although this is not as clean.

    Ref: dm_server_services - http://msdn.microsoft.com/en-us/library/hh204542.aspx%5B/b%5D

    sys.dm_server_registry - http://msdn.microsoft.com/en-us/library/hh204561.aspx%5B/quote%5D

    see the problem?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • The Option specified is wrong it is not Sys.dm_service_services but it is Sys.dm_server_services.

    I got my question wrong because of this.

    :w00t:

  • Please correct the typo!

  • Why you can't prepare task correctly?

    My answer was right compared to prepared options.

  • This was removed by the editor as SPAM

  • Very interesting question, as I don't have SP1 installed yet on our server.

    Luckily I guessed the intent of the question and realised that the first answer was a typo.

    Let the flame wars begin! 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Learnt something new from the question, which was good.

    Selected the only one correct answer, leaving out the other "correct" option. No points.

  • good query about new DMV in SP1.

    But change wrong first item sys.dm_service_services to sys.dm_server_services

    is needed:-)

    MS SQL 2008 MCITP x 3
    MS SQL 2012 MCSE x 2

  • Nice question

    I knew it wasnt in dm_os_nodes or dm_os_windows_info, so as it says to pick two, it had to be the top two.

    Changed the top one to sys.dm_ser then let intellisence figure the rest out and just confirm, suppose there is a use for intellisence after all.

  • SQL Version

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    but when I query these two objects - Query sys.dm_service_services, Query sys.dm_server_registry

    it show "Invalid object name..."

    Any help?

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Raghavendra Mudugal (2/24/2012)


    SQL Version

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    but when I query these two objects - Query sys.dm_service_services, Query sys.dm_server_registry

    it show "Invalid object name..."

    Any help?

    you need SP1 as detailed in the QotD, your on 10.50.1600 which is the RTM, you need to upgrade to 10.50.2500

  • anthony.green (2/24/2012)


    Raghavendra Mudugal (2/24/2012)


    SQL Version

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    but when I query these two objects - Query sys.dm_service_services, Query sys.dm_server_registry

    it show "Invalid object name..."

    Any help?

    you need SP1 as detailed in the QotD, your on 10.50.1600 which is the RTM, you need to upgrade to 10.50.2500

    and what that means "(Build 2600: Service Pack 3)" Is this not pertaining to SP?

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Raghavendra Mudugal (2/24/2012)


    anthony.green (2/24/2012)


    Raghavendra Mudugal (2/24/2012)


    SQL Version

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    but when I query these two objects - Query sys.dm_service_services, Query sys.dm_server_registry

    it show "Invalid object name..."

    Any help?

    you need SP1 as detailed in the QotD, your on 10.50.1600 which is the RTM, you need to upgrade to 10.50.2500

    and what that means "(Build 2600: Service Pack 3)" Is this not pertaining to SP?

    Nope, that is about your operating system.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 15 posts - 1 through 15 (of 31 total)

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