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();             
            }                        
            
            Console.ReadLine();        

 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

Hi,

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.

Regards,

Andrea.

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