Re: How do I convert sid retrieved from the AD to SDDL string form



It needs to be a byte[], because the data is a variable length byte array.
AD SIDs are generally bigger than GUIDs, so that isn't a good idea. I think
the problem from your previous code sample was that you were calling
ToString on the data.

I'm still confused why you are using OLEDB for searching AD, but whatever
works for you...

Joe K.

--
Joe Kaplan-MS MVP Directory Services Programming
Co-author of "The .NET Developer's Guide to Directory Services Programming"
http://www.directoryprogramming.net
--
"Pucca" <Pucca@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A498835F-3C6E-4569-B83E-B897B1D90025@xxxxxxxxxxxxxxxx
In the Dataset table definition, what type should I set for storing SID,
which is a byte[]. I tried GUID type but it doesn' like it.
--
Thanks.


"Henning Krause [MVP - Exchange]" wrote:

Hello,

if you are using .NET 2.0, you can pass the byte[] you get from the
objectSid property to a SecurityIdentifier class.

Otherwise, you have at least these options:
1) (easy one) Call the Win32 function ConvertSidToStringSid.
2) (more difficult, but more flexibility) Call the Win32 DsCrackNames
function

Best regards,
Henning Krause

"Pucca" <Pucca@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0972CEEE-1D2D-4605-8C4B-3B4995A2195D@xxxxxxxxxxxxxxxx
I retrieve sid from AD into a dataset table. How can I convert this to
SDDL
format string? My code below is not working.

ReportPreview repPreview = new ReportPreview();
string AdSelect = "select objectSid, cn, operatingSystem,
operatingSystemVersion from 'LDAP://CN=Computers,"; +
delimitedDomain + "'";
string padSelect = "Select cn, meetingName from " +
globalCompPath;
string temp;
int rs, num;
OleDbConnection adCon = new
OleDbConnection("Provider=ADsDSOObject");
OleDbDataAdapter qryAdapter = new OleDbDataAdapter(AdSelect,
adCon);
try
{
DataRow newRow = dsReport.Tables["Computers"].NewRow();

qryAdapter.Fill(dsReport, "AdComputers");
num = dsReport.Tables["AdComputers"].Rows.Count;
for (int y = 0; y <
dsReport.Tables["AdComputers"].Rows.Count; y++)
{
SecurityIdentifier si = new
SecurityIdentifier(dsReport.Tables["AdComputers"].Rows[y][0].ToString());
dsReport.Tables["AdComputers"].Rows[y][0] =
si.Value;
}
--
Thanks.




.



Relevant Pages

  • Re: STL vector - which style of for() loop?
    ... enumerates Windows Device Classes, and return a collection of string ... of VC.NET 2002, it is no longer reference-counted, and I think GUIDs are ... It is also possible to write a registry key iterator class, ...
    (microsoft.public.vc.language)
  • Converting GUIDs to base-36
    ... I've got an application that generates GUIDs. ... of GUIDs that end up in files on disk, ... I don't need an AnyBase converter. ... a base-16 string to base-36 string converter. ...
    (microsoft.public.dotnet.languages.csharp)
  • GUIDs in Access-Datenbank
    ... in etlichen Tabellen GUIDs zu verwenden. ... Access bietet jedoch auch den 128-Bit-Wert ... sGUID ist natürlich String. ...
    (microsoft.public.de.vb.datenbank)
  • Re: Select In Syntax
    ... das Problem ist das er der String nicht als GUIDs ... Prev by Date: ... Next by Date: ...
    (microsoft.public.de.sqlserver)