Post reply

SQL server service account

  • February 13, 2012 at 12:58 pm

    #391551

    Is there a way I can find out what sql services account are used for a sql server without remote login to the computer, but just checked from my workstation sql server management studio?

    Thanks

  • February 13, 2012 at 1:06 pm

    #1446473

    SELECT servicename, startup_type_desc, status_desc,

    last_startup_time, service_account, is_clustered, cluster_nodename

    FROM sys.dm_server_services OPTION (RECOMPILE);

    From someone's performance script. I'll source it when I find it again.

    Edit: Found it! Mr. Glenn Berry's wonderful script[/url].

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • February 13, 2012 at 2:37 pm

    #1446523

    Thanks, but I got Invalid object name 'sys.dm_server_service'.

  • February 13, 2012 at 2:50 pm

    #1446536

    sqlfriends (2/13/2012)

    Thanks, but I got Invalid object name 'sys.dm_server_service'.

    Add an s to make service services.

    Jared
    CE - Microsoft

  • February 13, 2012 at 2:54 pm

    #1446539

    sqlfriends (2/13/2012)

    Thanks, but I got Invalid object name 'sys.dm_server_service'.

    What version is your SQL Server instance, the script above is only valid for SQL Server 2008 R2 SP1 onwards. Get your version using

    select serverproperty('ProductVersion'), serverproperty('ProductLevel')

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

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

  • February 13, 2012 at 3:09 pm

    #1446548

    Thanks, most of our server are sql 2008, only one is R2,

    I tried on R2, it works. but not on sql server 2008, good to know.

    Thanks all

  • February 14, 2012 at 10:17 am

    #1446954

    Does any one know what is this View name for SQL Server 2005??

Viewing 7 posts - 1 through 6 (of 6 total)

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