Item Authorization error

Topics: General Topic, MMC SnapIn
Nov 23, 2011 at 8:51 PM
Edited Nov 23, 2011 at 8:51 PM

I downloaded and installed NetSqlAzMan.

I created a database called "NetSqlAzManStorage" and executed the provided sql script.

Then I start the mmc snap in and follow these instructions, given in the *.cs sample file.

/* -------------------
 * NetSqlAzMan Samples
 * -------------------
 * Andrea Ferendeles
 * aferende@hotmail.com
 * http://netsqlazman.codeplex.com
 *
 * 1) Install first NetSqlAzMan.msi
 * 2) Create a new Sql database: "NetSqlAzManStorage"
 * 3) Execute Sql Script (installation folder) on this sql database
 * 4) Launch NetSqlAzMan Console: start - run - "netsqlazman.msc"
 * 5) Create a Store called "My Store"
 * 6) Under "My Store", create an Application called "My Application"
 * 7) Under "My Application" - Item Definitions, create an Operation called "My Operation"
 * 8) Under Item Authorization - "My Operation", assign yourself (Windows Account) a set an "Allow" permission
 *
 */

 

At point 8, when I try to add a account I get this error:

Item Authorization error

Could not load file or assembly

'CubicOrange.Windows.Forms.ActiveDirectory, Version=2.0.0.0, Culture=neutral, PublicKeyToken=bc057...' or one of its dependencies.

 

I'm running a Win7 64bit with an MS-Sql 2008. I just want to try the sample. I've no ActiveDirectory running here. Any suggestions?

I tried the search but didn't find anything.

 

Thanks in advance.

Nov 23, 2011 at 9:12 PM

Which version of NetSqlAzMan have you installed ?

Could you please verify if in your NetSqlAzMan installation folder, you have the CubicOrange.Windows.Forms.ActiveDirectory.dll file ?

Let me know.

Andrea.

__________________________________
Andrea Ferendeles
NetSqlAzMan Project Coordinator
E-mail aferende@hotmail.com Web http://netsqlazman.codeplex.com

Nov 23, 2011 at 9:21 PM

In my installation folder isn't that *.dll, just a *.xml file with that name.

Newest entry in Build-History.rtf says

"3.6.0.10 22-Nov-2011"

Nov 23, 2011 at 9:26 PM

Ok.

I found a little MSI bug but only for the x86 release version.

I have fixed and uploaded the new package on the codeplex.com site now.

Please download it again and let me know (uninstall the old release first).

PS: Just a question … why you have downloaded the x86 version … if you have an x64 processor ? J

__________________________________
Andrea Ferendeles
NetSqlAzMan Project Coordinator
E-mail aferende@hotmail.com Web http://netsqlazman.codeplex.com

Nov 23, 2011 at 9:27 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Nov 23, 2011 at 9:32 PM
Edited Nov 23, 2011 at 9:33 PM

Good question.

That download was recommended. :)

Nov 23, 2011 at 9:35 PM

Codeplex.com allows just one “recommended” download …

I guess that most people still have x86 processors.

In any case I put a prefix before each file ... but it is not enough.

However try and let me know if you have other problems.

Regards,

Andrea.

__________________________________
Andrea Ferendeles
NetSqlAzMan Project Coordinator
E-mail aferende@hotmail.com Web http://netsqlazman.codeplex.com

Nov 23, 2011 at 9:39 PM

I'll try it tomorrow, have to sleep now. But I'll give feedback.

Nov 23, 2011 at 9:40 PM

Yup.

Me too. J

Good night.

Nov 24, 2011 at 10:03 AM

So I first tried the x86 download. Installation works fine, *.dll is included and i get no error when I try to add an user.

 

But I've a new Problem. :P

On this line in the sample:

auth = storage.CheckAccess("My Store", "My Application", "My Operation", userIdentity, DateTime.Now, true, out attributes);

I've created an testuser with the given name and password (string sqlConnectionString = "data source=(local);initial catalog=NetSqlAzManStorage;user id=netsqlazmanuser;password=password";)

And when I use these login credentials and execute a query (select * from netsqlazman_storesTable) I get one row. So the store "My Store" exists.

Nov 24, 2011 at 10:07 AM

Ok.

This may happen of the SQL user netsqlazmanuser is not a “dbo” member.

Try to add this user to the “NetSqlAzMan_Administrators” db role (NetSqlAzManStorage db).

Regards,

Andrea.

__________________________________
Andrea Ferendeles
NetSqlAzMan Project Coordinator
E-mail aferende@hotmail.com Web http://netsqlazman.codeplex.com

Nov 24, 2011 at 10:44 AM

Ok works now.

Thanks. :)

Nov 24, 2011 at 10:49 AM

Great.

__________________________________
Andrea Ferendeles
NetSqlAzMan Project Coordinator
E-mail aferende@hotmail.com Web http://netsqlazman.codeplex.com