Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Service Service Accounts Expand / Collapse
Author
Message
Posted Thursday, February 23, 2012 8:43 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:17 PM
Points: 32,157, Visits: 16,546
Comments posted to this topic are about the item Service Service Accounts






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1257073
Posted Thursday, February 23, 2012 8:49 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:20 PM
Points: 1,335, Visits: 1,200
Wow. I did not knew there are DMV's to see the Service accounts.

Good to knew it.

Very good question.
Post #1257075
Posted Thursday, February 23, 2012 8:57 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, June 17, 2015 7:24 AM
Points: 1,882, Visits: 2,922
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
sys.dm_server_registry - http://msdn.microsoft.com/en-us/library/hh204561.aspx


see the problem?


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1257079
Posted Thursday, February 23, 2012 11:55 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 3:46 AM
Points: 2,223, Visits: 177
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.
Post #1257133
Posted Friday, February 24, 2012 12:20 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 12:17 AM
Points: 1,527, Visits: 592
Please correct the typo!
Post #1257152
Posted Friday, February 24, 2012 12:22 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, June 17, 2015 6:38 AM
Points: 1,819, Visits: 118
Why you can't prepare task correctly?
My answer was right compared to prepared options.
Post #1257155
Posted Friday, February 24, 2012 12:29 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:47 AM
Points: 4,508, Visits: 5,965
I did not know about the dm_server_services DMV, so I learned something here, thanks , Steve.
Knowing this would have saved me a fair headache a few days ago.

Point of note: tringer fouble causes endless trouble....


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1257160
Posted Friday, February 24, 2012 12:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 14,474, Visits: 12,467
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!




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1257172
Posted Friday, February 24, 2012 1:20 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 5:33 AM
Points: 3,582, Visits: 1,423
Learnt something new from the question, which was good.
Selected the only one correct answer, leaving out the other "correct" option. No points.
Post #1257184
Posted Friday, February 24, 2012 1:24 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 2, 2015 3:49 PM
Points: 2,140, Visits: 569
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
Post #1257188
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse