SQL Server Service Account


Is there a way to find out what the SQL Server server account is from running a t-sql statement without going to the registry to get it?
PeterErhardAsked:
Who is Participating?
 
Metehan OzculluConnect With a Mentor SQL Service ManagerCommented:
I guess no such info is available inside SQL but there is a way to retrive this information from SQL using xp_command shell. You can see this info at  he following web:

http://www.simple-talk.com/sql/database-administration/changing-service-credentials/
0
 
Metehan OzculluSQL Service ManagerCommented:
do you need to find the service account for SQL?
0
 
PeterErhardAuthor Commented:
Yes and was wondering whether its possible to retrieve it from a system table or something and not have to do a registry lookup which I what I saw through a google search.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
BartVxConnect With a Mentor Commented:
You can also find it in the SQL Server Configuration Manager:

Program Files -> Microsoft SQL Server 2008 --> Configuration Tools --> SQL Server Configuration Manager

Then under SQL Server Services, right click the SQL Server Service and select properties.
0
 
Scott PletcherConnect With a Mentor Senior DBACommented:
You can retrieve it using Powershell and WMI, but that's at least as awkward as reading the registry really :-) .
0
 
PeterErhardAuthor Commented:
Thanks guys for the comments.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.