Qdabra Database Accelerator

Re: Query Builder Error

Jimmy — Tue, 09 Jul 2013 20:31:26 GMT

britgeek:
Setting the Initial Catalog to the test database re-produced the error I was hitting before. We've double checked and even dropped and re-granted permissions for the service account on the views/tables on that database that it should be able to access without success.
Does the account need to have full access to the entire database for this to work?

In order to be able to detect the database schema, the account being used to access the database needs to at least have SELECT access to the database's following system views:

systypes
sysobjects
syscolumns

And EXECUTE access to the following system stored procedure:

sp_pkeys

I can't say for sure that those will be enough, but it may be enough. Could you give that a try? In the end, it may be more practical to grant the account reader access to the whole database and deny access to certain DB objects that should be off limits.

Re: Query Builder Error

ErnestoM — Tue, 09 Jul 2013 18:53:32 GMT

I will create a support ticket and contact you via email to investigate further.

Re: Query Builder Error

britgeek — Tue, 09 Jul 2013 15:41:26 GMT

The Service account is also a domain account, not a local account on the SQL box, does this affect the configuration?

Re: Query Builder Error

Hilary Stoupa — Tue, 09 Jul 2013 14:45:12 GMT

I don't know if we've tested with permissions to only tables and views - I'll check w/ the test team.

Re: Query Builder Error

britgeek — Tue, 09 Jul 2013 14:37:07 GMT

Some additional testing I did with the TestConnectionString service revealed that the connection string to the database resolves correctly, so I pasted it straight from the web.config into Query Builder. Also the QdabraSamples now works after resetting IIS a couple of times.

Without the Initial Catalog value set, the form worked, but it retrieved database system level values to the Table Name drop-down, not the table values I was looking for.

Setting the Initial Catalog to the test database re-produced the error I was hitting before. We've double checked and even dropped and re-granted permissions for the service account on the views/tables on that database that it should be able to access without success.

Does the account need to have full access to the entire database for this to work?

Re: Query Builder Error

britgeek — Tue, 09 Jul 2013 00:54:36 GMT

Here it is.

Re: Query Builder Error

Hilary Stoupa — Tue, 09 Jul 2013 00:47:53 GMT

Thanks - and a screen shot of the relevant parts of the web config? I'm going to forward a link to this thread to our support team.

Re: Query Builder Error

britgeek — Tue, 09 Jul 2013 00:43:02 GMT

Here you go

Re: Query Builder Error

Hilary Stoupa — Tue, 09 Jul 2013 00:32:06 GMT

Under the Options tab in a reply, can you add a screenshot of what you have entered in the fields in Query Builder prior to getting this error?

Re: Query Builder Error

britgeek — Mon, 08 Jul 2013 23:59:24 GMT

Yes it's there, as well as the default server line that it references.

Re: Query Builder Error

Hilary Stoupa — Mon, 08 Jul 2013 23:49:37 GMT

If you look in the web config, do you see an entry for QdabraSamples?

Re: Query Builder Error

britgeek — Mon, 08 Jul 2013 23:09:06 GMT

I have tested the web service by calling the AD integration and it worked well, so DBXL is up and running.

Here's the response when querying the sample alias:

An error occured trying to refresh the database description: The query cannot be run for the following DataObject: DescribeDatabaseSchemaFromDatabaseName

InfoPath cannot run the specified query.
The SOAP response indicates that an error occured on the server:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Qdabra.QueryDB.QueryDBException: Error D0003:

The Database alias QdabraSamples was not found in web.config

at Qdabra.QueryDBService.FindAlias(String dbAlias, String&connectionString)
at Qdabra.QueryDBService.GetConnectionString(String database, Boolean&isDbxlDb)
at Qdabra.QueryDBService.Qdabra.QueryDBServices.IQueryDBService.DescribeDatabasesSchemaFromDatabaseName(String database)

Re: Query Builder Error

Hilary Stoupa — Mon, 08 Jul 2013 22:32:53 GMT

Can you try querying the QdabraSamples alias? Just to see if you get the same error?

Re: Query Builder Error

britgeek — Mon, 08 Jul 2013 22:24:11 GMT

Hi Hilary, yes, the account does have access, and is hard-coded into the connection string. Any other ideas?

Re: Query Builder Error

Hilary Stoupa — Mon, 08 Jul 2013 21:34:16 GMT

Just saw this recently! Make sure the service account that DBXL runs under has read permissions to the database you are trying to use QueryBuilder for...