InfoPath Dev

Hello again,

So I finished installing DBXL, and am working through the Getting Started tutorial (QdabraWebService/Docs/GettingStarted.htm).

I have reached Task 2: step 2.e (Click Save.), but when I click Save in the DBXL Admin Tool, I get a Message Box with the message "I0033: Access denied."

I still have the ASPNET user in the Administrators group and am logged in as a user with Administrator control.

Any idea why this is happening?

Thanks again for any help,
Jimmy
 

That means you do not have write permissions to the database.

Check permissions in SQL Express.  Your Network Service account should have permission on the QdabraDBXL table.

If you still have issue let me know and we can do a live meeting.

 Ok, that sounds simple enough.  I will try that when I get home.  Sorry for all these basic questions, but I'm still getting my footing with all these unfamiliar software packages.

 Since I am in Japan and work 8-4, it would be very difficult to arrange an online meeting, but with any luck, I'll have the program up and running very soon.

 Thanks for all your help.
 

We actually do a lot of business in Japan so we can make the time work. Most of our forms and solutions are in Japanese as well as english.

We have staff there and are going to be opening a permanent office there soon as well.

 Ok, that's cool.  Maybe I will set up a meeting with you guys sometime soon in that case.

 Actually the reason I'm here is that I'm a programmer and I met Mr. Halstead by chance while he was passing through my town a few days ago.  I'm hoping to do some coding for your team, but I don't have any experience with Windows databases or InfoPath, so I have a lot of catching up to do.

Regarding my current issue, I can't seem to find a way to view or modify permissions for SQL Express.  The SQL Server Configuration Manager doesn't seem to have many settings to modify at all, and the Surface Area Configuration has a utility relating to permissions in Vista, but that doesn't seem to be quite right either, and in any case I tried it and it didn't help.

Searching around the internet I found this page that seems tangentially related to my problem, but I can't find anything called SQL Server Manager, and as I mentioned, the Server Configuration Manager doesn't seem to let me modify permissions of any sort:
http://w3ka.blogspot.com/2008/01/sql-server-express-permissions.html

I found another page (which I can't seem to find now) that said something about modifying the User Rights in the Local Security Policy, but I can't find anything there seemingly related to SQL or this situation.

I could try using the trial developer version of SQL Server if that might make it easier to set permissions, but do you have any ideas?  Am I overlooking something?

 
Thanks again.

Wow, you were able to spot Patrick as he was passing through? I did not think he would stick out from the crowd over there. :)

You need SQL Management studio to work on the database directly.  This does not get installed by default unfortunately.  I would make sure it is included in your Express or trial download package and then run the install again (repair) and make sure management studio is included.

Then you will have it on your computer and can connect to the database and set the permissions, etc. You will need to be able to create additional databases etc.  In 2000 it was called SQL Manager.

 We just happened to be in the same cafe at the same time.  I didn't know who he was until I met him, of course. :-)

So as it turns out, the SQL Management Studio was a separate free download so I downloaded and installed it.  However, even after I give ASPNET all of the role memberships available (except "Deny..." and Guest), I am still getting the Access Denied error.

Another strange thing is that the Management Studio shows a user called "dbo" which is mapped to my login name, but if I try to modify its security settings, I get an error:
"Cannot use the special principal 'dbo'." 

 If it would be better if I worked with someone over Live Meeting, I will be available tomorrow (Thursday) after 4:30 PM JST.  Otherwise I don't mind continuing like this in the forum.

When running DBXL and the Admin tool on the same Vista machine, you will need to do one of two things to work around User Account Control (UAC).  This is because with UAC, Vista treats you as not being a member of the BUILTIN\Administrators group unless you 'Run as Administrator'

1) Run Internet Explorer as Administrator.  Then browse to http://localhost/QdabraWebService/default.htm and click on Administration Tool.  You will now be running as a local administrator. 

or

2) Create a new local group called DBXLAdmins and add yourself to this group.  Then update the QdabraWebService web.config, changing all instances of BUILTIN\Administrators with yourmachinename\DBXLAdmins. 

 Actually I'm using Windows XP SP2.  Might those steps still help my situation?