Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Script for Service Account

Author  Topic 

riya.johnson
Starting Member

17 Posts

Posted - 2009-09-15 : 00:01:03
I want to know whether my MS SQL Service is using "Local System" or some other account. Could you please help my in creating a script for this?

Regards
Riya

Riya Johnson

SteveTR
Starting Member

7 Posts

Posted - 2009-09-15 : 16:13:05
Riya,
I assume you know the manual method to determine the account SQL is using by looking at the "log on as" property of the MSSQLSERVER and SQLSERVERAGENT services in Computer Management.
If you need to do this using scripting, you can try the examples from the TechNet Scripting site:
[url]http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept04/hey0910.mspx[/url]
- Steve TR
Go to Top of Page
   

- Advertisement -