SqlException when trying to create / delete attributes multiple times

Topics: General Topic
Oct 29, 2011 at 1:03 PM

Hi, I am new to NetSqlAzman... so excuse the bad terminology... 

I just wanted to know if I missed something obvious...

I get the following exception thrown "Application permission denied." when I try and run the following code

            string connectionString = @"Data Source=Localhost;Initial Catalog=NetSqlAzManStorage;Integrated Security=SSPI;";

            CheckAccessHelper helper = new CheckAccessHelper(connectionString);            

            for (int i = 0; i < 3; i++)
                helper.Storage.Stores["KeyBlade"].Applications["Automation"].Items["Temp"].CreateAttribute("New Attribuite", "123");
                helper.Storage.Stores["KeyBlade"].Applications["Automation"].Items["Temp"].Attributes["New Attribuite"].Delete();             

 Is there something I am doing wrong. Basically I really just want to update the value in an attribute, but could not see a way to do this - so now I am removing / readding the attribute? But in my scenario I may want this to be done multiple times.

Oct 30, 2011 at 5:17 PM


the Windows user you are using to connect to SQL Server (NetSqlAzManStorage DB) must be a member of the NetSqlAzMan_Administrators or the dbo db role.



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