Qdabra Database Accelerator

Re: Database Move Broke DBXL. What are some troubleshooting and resolution steps?

DC Forms — Thu, 25 Oct 2012 18:12:27 GMT

The root cause of several errors was DBXL's inability to connect to its database. This was due to a configuration change to the SQL Server.

SQL Server has been reconfigured to allow DBXL to connect, a new connection string was generated and implemented, and DBXL is now functioning.

Interestingly, a related error was the failure of the Web Parts Maintenance Page. SharePoint pages containing form web parts hosting InfoPath forms that used qRules to query DBXL were failing. It was not obvious that the DBXL problem was related as the errors were:

========
Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 985a0370-f4e4-4b83-bd81-23e7e4e7c403
Date and Time: 10/25/2012 9:17:59 AM
========
Request for the permission of type 'System.Security.Permissions.UrlIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
========
Business logic failed due to an exception. (User: XXXXX\XXXXX, Form Name: DD E-Note_Form-DN, IP: , Request: http://sharepoint/DDE/SiteAssets/EnterDN.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:DDE-Note-Form-DN:-myXSD-2012-08-30T20-50-05, Type: SecurityException, Exception Message: Request for the permission of type' System.Security.Permissions.UrlIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.)
========
Message : Exception thrown from business logic event listener: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.UrlIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
========

It wasn't until the following error was found that the connection was made between the SharePoint Web Parts Maintenance Page error displayed in the browser was made to the DBXL issue.

The following query failed: CheckForValidBusinessDay (User: XXXXX\XXXXX, Form Name: DDE-Note_Form-DN, IP: , Connection Target: , Request: http://sharepoint/DDE/SiteAssets/EnterDN.aspx, Form ID: urn:schemas-microsoft-com:office:infopath:DDE-Note-Form-DN:-myXSD-2012-08-30T20-50-05 Type: DataAdapterException, Exception Message: The remote server returned an error: (500) Internal Server Error.
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Qdabra.QueryDB.QueryDbException: Error L0002:
----------------------
LicensingNoQueryDBLicenses
----------------------

   at Qdabra.QueryDB.QueryDBService.CheckLicenseLimits()
   at Qdabra.QueryDB.QueryDBService.FindAlias(String dbAlias, String& connectionString)
   at Qdabra.QueryDB.QueryDBService.GetConnectionString(String database, Boolean& isDbxlDb)
   at Qdabra.QueryDB.QueryDBService.ProcessInputs(String database, String& table, List`1& columns)
   at Qdabra.QueryDB.QueryDBService.GetRequestedData(String database, String table, List`1 columns, Boolean distinct, String whereClaus, String orderByClaus, Int32 maxRows, Boolean countOnly, MySqlParameterCollection sqlParams)
   at Qdabra.QueryDB.QueryDBService.InternalGetDataSet(XmlNode queryXml, String& table, Boolean& countOnly)
   at Qdabra.QueryDB.QueryDBService.Qdabra.QueryDB.Services.IQueryDBService.GetColumnsXMLQuery(XmlNode queryXml)
   at Qdabra.QueryDB.QueryDBService.Qdabra.QueryDB.Services.IQueryDBService.GetColumnsXMLStrQuery(String queryXml)

Re: Database Move Broke DBXL. What are some troubleshooting and resolution steps?

DC Forms — Wed, 24 Oct 2012 18:00:02 GMT

Ernesto,

Thank you for the e-mail reply.

I am having difficulty in determining what the "new" connection string should be so that I can encrypt it. I am not able to use Visual Studio's Server Explorer to generate a connection string. This may be because there is a different problem that is preventing connections. I've checked the usual suspects and continue to investigate.

Hi Darian,

The connectionString stored in the <general> section is encrypted and was not updated. It will need to be updated to point to the new server.

We have a tool that will allow you to generate the encrypted connection string:

http://www.infopathdev.com/files/folders/sql_integration/entry74108.aspx

Hope this helps.

Re: Database Move Broke DBXL. What are some troubleshooting and resolution steps?

DC Forms — Wed, 24 Oct 2012 14:51:05 GMT

My first thought is that it is a permissions issue. The server didn't move, only the database and log files moved. However it appears SQL Server was re-installed as part of the database work:

4. <DBA> Script login with passwords have been saved in .sql file for each instance in C:\RSDBA_Move folder.
5. <DBA> Detach script that needs to be ran on each instance.

412259-DB1
exec sp_detach_db 'PerformancePoint Services_f6e337127aad421c8bacf250508c484e';
exec sp_detach_db 'Prod_BCSDB';
exec sp_detach_db 'Prod_LOB_DDE';
exec sp_detach_db 'Prod_MetadataDB';
exec sp_detach_db 'Prod_ProfileDB';
exec sp_detach_db 'Prod_SearchDB';
exec sp_detach_db 'Prod_SearchDB_CrawlStore';
exec sp_detach_db 'Prod_SearchDB_PropertyStore';
exec sp_detach_db 'Prod_SecureStoreDB';
exec sp_detach_db 'Prod_SharePoint_AdminContent';
exec sp_detach_db 'Prod_SharePoint_Config';
exec sp_detach_db 'Prod_SocialDB';
exec sp_detach_db 'Prod_StagerDB';
exec sp_detach_db 'Prod_StateDB';
exec sp_detach_db 'Prod_SyncDB';
exec sp_detach_db 'Prod_UsageDB';
exec sp_detach_db 'Prod_WarehouseDB';
exec sp_detach_db 'Prod_WordDB';
exec sp_detach_db 'WSS_Content_SharePoint';
exec sp_detach_db 'WSS_MY_Content';

XXXXX\DBXL
exec sp_detach_db 'QdabraDBXL';
exec sp_detach_db 'QdabraUtility';

XXXXX\XXXX
exec sp_detach_db 'ReportServer$XXXX';
exec sp_detach_db 'ReportServer$XXXXTempDB';

6. <DBA> Uninstall all instance than Reinstall all SQL Server 2008 R2 with SP1 or SP2 patch on the server, ensure to install System files on the D drive not the C drive. I've create a Data folder for each instance on the D and E drive.

7. <DBA> Copy user Database Data and Log file from the below location to each instance data folder on the D (data) and E (Logs) drives.

412259-DB1
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\

XXXXX\DBXL database data and log file locations:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.DBXL\MSSQL\DATA\

XXXXX\XXXX
C:\Program Files\Microsoft SQL Server\MSSQL10_50.XXXX\MSSQL\DATA\

8. <DBA> Below is the attach script that needs to run on each instance

XXXXX\DBXL
exec sp_attach_db @dbname = N'QdabraDBXL',@filename1=N'D:\MSSQL\DBXL_Data\QdabraDBXL.mdf',@filename2=N'E:\MSSQL\DBXL_Log\QdabraDBXL_log.LDF'
exec sp_attach_db @dbname = N'QdabraUtility',@filename1=N'D:\MSSQL\DBXL_Data\QdabraUtility.mdf',@filename2=N'E:\MSSQL\DBXL_Log\QdabraUtility_log.LDF'

XXXXX\XXXX
exec sp_attach_db @dbname = N'ReportServer$XXXX',@filename1=N'D:\MSSQL\XXXX_Data\ReportServer$XXXX.mdf',@filename2=N'E:\MSSQL\XXXX_Log\ReportServer$XXXX_log.LDF'
exec sp_attach_db @dbname = N'ReportServer$XXXXTempDB',@filename1=N'D:\MSSQL\XXXX_Data\ReportServer$XXXXTempDB.mdf',@filename2=N'E:\MSSQL\XXXX_Log\ReportServer$XXXXTempDB_log.LDF'

412259-DB1
exec sp_attach_db @dbname = N'PerformancePoint Services_f6e337127aad421c8bacf250508c484e',@filename1=N'D:\MSSQL\Data\PerformancePoint Services_f6e337127aad421c8bacf250508c484e.mdf',@filename2=N'E:\MSSQL\Log\PerformancePoint Services_f6e337127aad421c8bacf250508c484e_log.LDF'
exec sp_attach_db @dbname = N'Prod_BCSDB',@filename1=N'D:\MSSQL\Data\Prod_BCSDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_BCSDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_LOB_DDE',@filename1=N'D:\MSSQL\Data\Prod_LOB_DDE.mdf',@filename2=N'E:\MSSQL\Log\Prod_LOB_DDE_log.ldf'
exec sp_attach_db @dbname = N'Prod_MetadataDB',@filename1=N'D:\MSSQL\Data\Prod_MetadataDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_MetadataDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_ProfileDB',@filename1=N'D:\MSSQL\Data\Prod_ProfileDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_ProfileDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_SearchDB',@filename1=N'D:\MSSQL\Data\Prod_SearchDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_SearchDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_SearchDB_CrawlStore',@filename1=N'D:\MSSQL\Data\Prod_SearchDB_CrawlStore.mdf',@filename2=N'E:\MSSQL\Log\Prod_SearchDB_CrawlStore_log.LDF'
exec sp_attach_db @dbname = N'Prod_SearchDB_PropertyStore',@filename1=N'D:\MSSQL\Data\Prod_SearchDB_PropertyStore.mdf',@filename2=N'E:\MSSQL\Log\Prod_SearchDB_PropertyStore_log.LDF'
exec sp_attach_db @dbname = N'Prod_SecureStoreDB',@filename1=N'D:\MSSQL\Data\Prod_SecureStoreDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_SecureStoreDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_SharePoint_AdminContent',@filename1=N'D:\MSSQL\Data\Prod_SharePoint_AdminContent.mdf',@filename2=N'E:\MSSQL\Log\Prod_SharePoint_AdminContent_log.LDF'
exec sp_attach_db @dbname = N'Prod_SharePoint_Config',@filename1=N'D:\MSSQL\Data\Prod_SharePoint_Config.mdf',@filename2=N'E:\MSSQL\Log\Prod_SharePoint_Config_log.LDF'
exec sp_attach_db @dbname = N'Prod_SocialDB',@filename1=N'D:\MSSQL\Data\Prod_SocialDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_SocialDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_StagerDB',@filename1=N'D:\MSSQL\Data\Prod_StagerDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_StagerDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_StateDB',@filename1=N'D:\MSSQL\Data\Prod_StateDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_StateDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_SyncDB',@filename1=N'D:\MSSQL\Data\Prod_SyncDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_SyncDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_UsageDB',@filename1=N'D:\MSSQL\Data\Prod_UsageDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_UsageDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_WarehouseDB',@filename1=N'D:\MSSQL\Data\Prod_WarehouseDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_WarehouseDB_log.LDF'
exec sp_attach_db @dbname = N'Prod_WordDB',@filename1=N'D:\MSSQL\Data\Prod_WordDB.mdf',@filename2=N'E:\MSSQL\Log\Prod_WordDB_log.LDF'
exec sp_attach_db @dbname = N'WSS_Content_SharePoint',@filename1=N'D:\MSSQL\Data\WSS_Content_SharePoint.mdf',@filename2=N'E:\MSSQL\Log\WSS_Content_SharePoint_log.LDF'
exec sp_attach_db @dbname = N'WSS_MY_Content',@filename1=N'D:\MSSQL\Data\WSS_MY_Content.mdf',@filename2=N'E:\MSSQL\Log\WSS_MY_Content_log.LDF

Another thought is to try re-installing DBXL and attach to existing databases.

Redacting information from the web.config file for public posting may obscure any possible issues. I'll e-mail the file to you, Ernesto.

Re: Database Move Broke DBXL. What are some troubleshooting and resolution steps?

ErnestoM — Wed, 24 Oct 2012 14:02:10 GMT

DBXL's web.config file has data connection strings which connect DBXL to SQL. Those are generated during installation. It sounds like the move may have left these connection strings obsolete.

Would you be able to obtain a copy of DBXL's web.config file? (from the QdabraWebService folder on the server)

Database Move Broke DBXL. What are some troubleshooting and resolution steps?

DC Forms — Wed, 24 Oct 2012 13:30:58 GMT

I have an installation of DBXL 2.6 on two SharePoint 2010 servers (App and WFE). DBXL was first installed and configured to use its own Active Directory service account and then re-configured to use the same AD service account as the SharePoint web application pool. DBXL's database was installed on a dedicated instance of SQL Server and remained unchanged until earlier today.

The servrs are hosted by a third-party who had to make a configuration change. The change was moving the SQL Server database and log files off of the C: drive and on to dedicated disks to achieve better performance. This move has broken DBXL. The errors are:

Web hosted forms that use qRules to submit the forms to DBXL have the following error reported via the Error node:
Action: SubmitToDbxl. Arguments: submit: SubmitDocumentToDBXL doctype: fundingForm name: 2012-10-24T08-20-29[XXXXX_XXXXX] author: XXXXX . Details: I9999An unhandled exception was thrown: data source=/LM/W3SVC/2014112381/ROOT/QdabraWebService-1-129955547252374866.mdb;user id=Admin;mode=Share Deny None;provider=Microsoft.Jet.OLEDB.4.0;password=. Stack: at Qdabra.Utilities.SubmitDocument(String docType, String name, String author, String description, SubmitDocument submitDocument, XPathNavigator xml, String& docId, String& refId) at Qdabra.Tools.RulesLibrary.Commands.SubmitToDbxl() at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()
When attempting to access the DBXL Administration Tool the web server responds with a HTTP 500 Internal Server Error
The Qdabra event logs on the server are:

Log Name:      Qdabra
Source:        Database Accelerator
Date:          10/24/2012 7:21:04 AM
Event ID:      3000
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      XXXX.XXXX.com
Description:
AddDocument encountered a critical error and needs attention:
User:XXXX\XXXX
Url: /QdabraWebService/dbxldocumentservice.asmx
DevExpress.Xpo.DB.Exceptions.UnableToOpenDatabaseException: data source=/LM/W3SVC/2014112381/ROOT/QdabraWebService-1-129955547252374866.mdb;user id=Admin;mode=Share Deny None;provider=Microsoft.Jet.OLEDB.4.0;password= ---> System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   --- End of inner exception stack trace ---
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.OleDBConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateProviderFromConnection(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.Session.ConnectOldStyle()
   at Qdabra.Dbxl.Implementation.ServiceImplementation.GetNewSession()
   at Qdabra.Dbxl.Implementation.ServiceImplementation.InternalAddDocument(String docTypeName, String xml, String name, String author, String description, String refIdFormat, Boolean shred, Nullable`1 DateCreated, String CreatedBy, Nullable`1 DateModified, String ModifiedBy, Nullable`1 versionNo, Int32& docId, Boolean useExistingRefId, String& refId)

The stack trace was:    at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.OleDBConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateProviderFromConnection(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.Session.ConnectOldStyle()
   at Qdabra.Dbxl.Implementation.ServiceImplementation.GetNewSession()
   at Qdabra.Dbxl.Implementation.ServiceImplementation.InternalAddDocument(String docTypeName, String xml, String name, String author, String description, String refIdFormat, Boolean shred, Nullable`1 DateCreated, String CreatedBy, Nullable`1 DateModified, String ModifiedBy, Nullable`1 versionNo, Int32& docId, Boolean useExistingRefId, String& refId).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="Database Accelerator" />
    <EventID Qualifiers="0">3000</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-10-24T12:21:04.000000000Z" />
    <EventRecordID>726</EventRecordID>
    <Channel>Qdabra</Channel>
    <Computer>XXXX.XXXX.com</Computer>
    <Security />
</System>
<EventData>
    <Data>AddDocument encountered a critical error and needs attention:
User: XXXX\XXXX
Url: /QdabraWebService/dbxldocumentservice.asmx
DevExpress.Xpo.DB.Exceptions.UnableToOpenDatabaseException: data source=/LM/W3SVC/2014112381/ROOT/QdabraWebService-1-129955547252374866.mdb;user id=Admin;mode=Share Deny None;provider=Microsoft.Jet.OLEDB.4.0;password= ---> System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   --- End of inner exception stack trace ---
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.OleDBConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateProviderFromConnection(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.Session.ConnectOldStyle()
   at Qdabra.Dbxl.Implementation.ServiceImplementation.GetNewSession()
   at Qdabra.Dbxl.Implementation.ServiceImplementation.InternalAddDocument(String docTypeName, String xml, String name, String author, String description, String refIdFormat, Boolean shred, Nullable`1 DateCreated, String CreatedBy, Nullable`1 DateModified, String ModifiedBy, Nullable`1 versionNo, Int32& docId, Boolean useExistingRefId, String& refId)

The stack trace was:    at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.OleDBConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateProviderFromConnection(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.Session.ConnectOldStyle()
   at Qdabra.Dbxl.Implementation.ServiceImplementation.GetNewSession()
   at Qdabra.Dbxl.Implementation.ServiceImplementation.InternalAddDocument(String docTypeName, String xml, String name, String author, String description, String refIdFormat, Boolean shred, Nullable`1 DateCreated, String CreatedBy, Nullable`1 DateModified, String ModifiedBy, Nullable`1 versionNo, Int32& docId, Boolean useExistingRefId, String& refId).</Data>
</EventData>
</Event>
Log Name:      Qdabra
Source:        Database Accelerator
Date:          10/24/2012 8:17:17 AM
Event ID:      3
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      XXXX.XXXX.com
Description:
Error initializing Qdabra DBXL web service encountered a critical error and needs attention:
User:
Url: /QdabraWebService/Forms/ID/192/template.xsn
DevExpress.Xpo.DB.Exceptions.UnableToOpenDatabaseException: Data Source=XXXX\DBXL,1533;Initial Catalog=QdabraDBXL;Integrated Security=True ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
   --- End of inner exception stack trace ---
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateProviderFromString(String connectionString, AutoCreateOption autoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption)
   at Qdabra.Dbxl.Implementation.DatabaseInstaller.InitializeXPO()
   at Qdabra.Dbxl.Global.Application_Start(Object sender, EventArgs e)

The stack trace was:    at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateProviderFromString(String connectionString, AutoCreateOption autoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption)
   at Qdabra.Dbxl.Implementation.DatabaseInstaller.InitializeXPO()
   at Qdabra.Dbxl.Global.Application_Start(Object sender, EventArgs e).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="Database Accelerator" />
    <EventID Qualifiers="0">3</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-10-24T13:17:17.000000000Z" />
    <EventRecordID>730</EventRecordID>
    <Channel>Qdabra</Channel>
    <Computer>XXXX.XXXX.com</Computer>
    <Security />
</System>
<EventData>
    <Data>Error initializing Qdabra DBXL web service encountered a critical error and needs attention:
User:
Url: /QdabraWebService/Forms/ID/192/template.xsn
DevExpress.Xpo.DB.Exceptions.UnableToOpenDatabaseException: Data Source=XXXX\DBXL,1533;Initial Catalog=QdabraDBXL;Integrated Security=True ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
   --- End of inner exception stack trace ---
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateProviderFromString(String connectionString, AutoCreateOption autoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption)
   at Qdabra.Dbxl.Implementation.DatabaseInstaller.InitializeXPO()
   at Qdabra.Dbxl.Global.Application_Start(Object sender, EventArgs e)

The stack trace was:    at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase(SqlConnection conn)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.MSSqlConnectionProvider.CreateProviderFromString(String connectionString, AutoCreateOption autoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption)
   at Qdabra.Dbxl.Implementation.DatabaseInstaller.InitializeXPO()
   at Qdabra.Dbxl.Global.Application_Start(Object sender, EventArgs e).</Data>
</EventData>
</Event>
Log Name:      Qdabra
Source:        Database Accelerator
Date:          10/24/2012 8:17:17 AM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:     XXXX.XXXX.com
Description:
TemplateHandler GET failure for url http://sharepoint/QdabraWebService/Forms/ID/192/template.xsn encountered a critical error and needs attention:

User: XXXX\XXXX
Url: /QdabraWebService/Forms/ID/192/template.xsn
DevExpress.Xpo.DB.Exceptions.UnableToOpenDatabaseException: data source=/LM/W3SVC/2014112381/ROOT/QdabraWebService-1-129955582163805858.mdb;user id=Admin;mode=Share Deny None;provider=Microsoft.Jet.OLEDB.4.0;password= ---> System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   --- End of inner exception stack trace ---
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.OleDBConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateProviderFromConnection(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.Session.ConnectOldStyle()
   at Qdabra.Dbxl.Implementation.DocumentRetrieval.DocumentHandlerImplementation.GetTemplateXsn(Int32 docTypeId, String fileName, DateTime& dateLastModified)
   at Qdabra.Dbxl.Implementation.DocumentRetrieval.TemplateHandler.ProcessRequest_GET_or_HEAD(Boolean isHeadRequest)

The stack trace was:    at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.OleDBConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateProviderFromConnection(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.Session.ConnectOldStyle()
   at Qdabra.Dbxl.Implementation.DocumentRetrieval.DocumentHandlerImplementation.GetTemplateXsn(Int32 docTypeId, String fileName, DateTime& dateLastModified)
   at Qdabra.Dbxl.Implementation.DocumentRetrieval.TemplateHandler.ProcessRequest_GET_or_HEAD(Boolean isHeadRequest).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="Database Accelerator" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-10-24T13:17:17.000000000Z" />
    <EventRecordID>731</EventRecordID>
    <Channel>Qdabra</Channel>
    <Computer>XXXX.XXXX.com</Computer>
    <Security />
</System>
<EventData>
    <Data>TemplateHandler GET failure for url http://sharepoint/QdabraWebService/Forms/ID/192/template.xsn encountered a critical error and needs attention:

User: XXXX\XXXX
Url: /QdabraWebService/Forms/ID/192/template.xsn
DevExpress.Xpo.DB.Exceptions.UnableToOpenDatabaseException: data source=/LM/W3SVC/2014112381/ROOT/QdabraWebService-1-129955582163805858.mdb;user id=Admin;mode=Share Deny None;provider=Microsoft.Jet.OLEDB.4.0;password= ---> System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   --- End of inner exception stack trace ---
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.OleDBConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateProviderFromConnection(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.Session.ConnectOldStyle()
   at Qdabra.Dbxl.Implementation.DocumentRetrieval.DocumentHandlerImplementation.GetTemplateXsn(Int32 docTypeId, String fileName, DateTime& dateLastModified)
   at Qdabra.Dbxl.Implementation.DocumentRetrieval.TemplateHandler.ProcessRequest_GET_or_HEAD(Boolean isHeadRequest)
The stack trace was:    at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
   at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.OleDBConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.DB.AccessConnectionProvider.CreateProviderFromConnection(IDbConnection connection, AutoCreateOption autoCreateOption)
   at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.XpoDefault.GetDataLayer(String connectionString, XPDictionary dictionary, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
   at DevExpress.Xpo.Session.ConnectOldStyle()
   at Qdabra.Dbxl.Implementation.DocumentRetrieval.DocumentHandlerImplementation.GetTemplateXsn(Int32 docTypeId, String fileName, DateTime& dateLastModified)
   at Qdabra.Dbxl.Implementation.DocumentRetrieval.TemplateHandler.ProcessRequest_GET_or_HEAD(Boolean isHeadRequest).</Data>
</EventData>
</Event>

I am able to access the DBXL databases via SQL Server Management Studio using the SharePoint web application pool account.

What would be some additional troubleshooting and resolution steps?