Timeline for How to obtain SIDs of Sql Server installed NT Service Accounts
Current License: CC BY-SA 3.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 15, 2013 at 12:44 | comment | added | Gennady Vanin Геннадий Ванин | This is "funny" but RTFM tells: "The SQL Server Agent service is disabled on instances of SQL Server Express and SQL Server Express with Advanced Services" | |
| Dec 31, 2012 at 22:03 | history | tweeted | twitter.com/#!/StackDBAs/status/285868684671602688 | ||
| Dec 31, 2012 at 6:38 | answer | added | Jon Seigel | timeline score: 3 | |
| Dec 31, 2012 at 6:38 | history | edited | Jon Seigel |
edited tags
|
|
| Oct 30, 2012 at 20:46 | answer | added | PollusB | timeline score: 0 | |
| Feb 27, 2012 at 21:30 | comment | added | jcolebrand♦ | Let's start over again. Why do you need the SIDs? | |
| Feb 27, 2012 at 21:26 | comment | added | Nivesh Patnaik | D:\temp\SysinternalsSuite>psgetsid "NT SERVICE\SQLAgent$SQLEXPRESS" PsGetSid v1.44 - Translates SIDs to names and vice versa Copyright (C) 1999-2008 Mark Russinovich Sysinternals - www.sysinternals.com SID for NT SERVICE\SQLAgent$SQLEXPRESS: S-1-5-80-592940576-1656185091-296729330-4026955537-2205062631 D:\temp\SysinternalsSuite> | |
| Feb 27, 2012 at 21:25 | comment | added | Nivesh Patnaik | I used psgetsid "NT SERVICE\SQLAgent$SQLEXPRESS" to get the full SID value for "NT SERVICE\SQLAgent$SQLEXPRESS" which is a member of one of the local groups. Since I could not find the SID that I found in the registry, I asked the domain admin if he could find that value in the registry, and he could not either. | |
| Feb 27, 2012 at 20:21 | comment | added | jcolebrand♦ | that matched what value? | |
| Feb 27, 2012 at 20:17 | comment | added | Nivesh Patnaik | I had one of our domain admins connect to the server with escalated privs 1) He could not find any key or value in the registry that matched the value I have him, 2) Using PowerShell Get-WmiObject he could not find SqlAgent$SQLEXPRESS in either Win32_SystemAccount or Win32_UserAccount. | |
| Feb 27, 2012 at 17:36 | comment | added | jcolebrand♦ | That is likely because you don't have the local server registry permissions to search for those values. Have you asked someone with domain administrative rights to look for those values for you? | |
| Feb 27, 2012 at 17:23 | comment | added | Nivesh Patnaik | Using D:\temp\SysinternalsSuite>psgetsid "NT SERVICE\SQLAgent$SQLEXPRESS", I am able to see the SID of the object. However, when I search the server's registry for that value, I cannot find it. | |
| Feb 27, 2012 at 17:22 | comment | added | Nivesh Patnaik | We use SID as the primary key for tracking objects and memberships on local systems. For group members that are objects in some domain, we are able to obtain the objectSID attribute of the object which matches what Win Users and Groups displays. | |
| Feb 27, 2012 at 15:52 | comment | added | jcolebrand♦ | the short answer to your question is "from the system list of SIDs" which should be found in the registry, at the very least. But the more important question is "why do you need the SIDs?" | |
| Feb 23, 2012 at 20:52 | history | asked | Nivesh Patnaik | CC BY-SA 3.0 |