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.
| Author |
Topic |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2007-05-07 : 04:25:47
|
| Guys, Is there any ways to use TSQL to get the startup account of SQL? Does it store this info in any registry entries or maybe some windows function to get this out? Using script that is.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-05-07 : 04:28:09
|
| SQL Server service account or SQL Server Agent service account?Peter LarssonHelsingborg, Sweden |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-05-07 : 04:31:51
|
| Its the sql server service account, I think i know how to find the agent service account (ie through sysprocesses, is there a better way?)To add to that, I did a profiler trace trying to get it, but doesn't seems like EM do anything to get the data, it needs to get the AuditLevel & LoginMode from the registry, but not the service startup account. Any ideas? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-05-07 : 05:18:47
|
| HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\ObjectNamePeter LarssonHelsingborg, Sweden |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-05-08 : 02:16:21
|
| Thanks Peso, great stuff. |
|
|
|
|
|
|
Query Startup account