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 123»»»

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: Today @ 10:15 AM
Points: 32,779, Visits: 14,938
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: Wednesday, April 02, 2014 9:27 PM
Points: 1,242, Visits: 1,097
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, April 09, 2014 12:58 AM
Points: 1,904, Visits: 2,771
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 09, 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
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:16 AM
Points: 1,232, Visits: 447
Please correct the typo!
Post #1257152
Posted Friday, February 24, 2012 12:22 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 12:58 AM
Points: 1,397, Visits: 116
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


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: Today @ 6:40 AM
Points: 3,683, Visits: 4,818
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 @ 7:29 AM
Points: 12,206, Visits: 9,168
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 @ 8:03 AM
Points: 3,087, Visits: 1,145
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: Tuesday, March 25, 2014 3:06 AM
Points: 2,015, Visits: 503
good query about new DMV in SP1.
But change wrong first item sys.dm_service_services to sys.dm_server_services
is needed


MCITP x 3
MCSE x 1
Post #1257188
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse