Inserting an ApplicationGroup

Topics: General Topic
Dec 5, 2014 at 10:59 PM
Edited Dec 5, 2014 at 11:09 PM
I'm trying to insert an ApplicationGroup using the objectsid generation here: http://netsqlazman.codeplex.com/discussions/67889

It says to use CONVERT(VARBINARY(85), Name). The issue with this is that running the UI after inserting this just gives me an exception saying that the sid revision number other than 1 is invalid. I'm trying to generate the sid based on the Name parameter that I'm passing in. I looked at the code for CreateFromParts to generate the _BinaryForm and I don't understand what's going on there. I just want to be able to create an objectsid for a basic Application Group using only sql. How can I accomplish this?

.NET SQL Authorization Manager Ver 3.5.4.0