30 April,2015 by Tom Collins
Question: How can I find my SQL Server Service Account?
Answer: The SQL Server Service account is stored as a Windows Registry Key.There are a number of methods to access the service account details.
Note: Only valid from SQL Server 2008 R2 SP1
SELECT servicename, service_account FROM sys.dm_server_services GO
In the command line type “Configuration Manager SQL Server” , this will open the SQL Server Configuration Manager . You should see the service account
If these methods cannot help - you do have the added option of using Powershell and executing the Get-Service cmdlet. Read how to use Get-Service on SQL Server - Working with Windows Services Examples and Powershell
SQL Server database files configuration checklist
SQL LOG FILE AUTOGROW performance ... - SQL Server DBA
SQL Server Surface Area Configuration ... - SQL Server DBA
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |