Installation Trouble

Last post 03-02-2008 04:36 PM by jrishe. 33 replies.

Page 1 of 3 (34 items) 1 2 3 Next >
	Sort Posts: Previous Next

06-26-2007 12:23 PM

jthrasher
Joined on 12-27-2006
Posts 19

Installation Trouble

Reply Contact

Hi, I'm trying to install the trial but I'm having trouble connecting it to the SQL Database. I don't have a whole lot of experience w/ SQL so I thought it would be best if I just came here and asked for some help.

The current SharePoint 2007 site is setup as a Basic Standalone so it is running SQL 2005 Express. In the Qdabra Database Acceleration Setup I have specified the following

Logon

predefined (Network Service)

SQL Server

server name = (LOCAL)
authentication = windows authentication
database = QdabraDBXL

Domain Security

DBXLAdmin = Builtin\Administrators
Set Global user permissions = checked
Admin group = builtin\administrators

Forms Viewer (no install)

Database Enumerator

Server Name = (LOCAL)
Authentication = windows authentication
Default database = QdabraDBXL <-- is this right?

If I test the connection I get the following error "connection failed. An error occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I double checked and SQL Server is allowing incoming connections.

Any help would be greatly appreciated.

Jason

06-26-2007 06:14 PM In reply to

jthrasher
Joined on 12-27-2006
Posts 19

Re: Installation Trouble

Reply Contact

OK, I solved the Database connection problem, but now the installation errors out just before finishing. here is the error I get now.

Description: Error Initializing DBXL database. Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

EDIT: I found this http://www.infopathdev.com/files/folders/dbxlsupport/entry20602.aspx, but as soon as the install errors it rolls back the installation and deletes all the files

06-26-2007 09:55 PM In reply to

Matt Faus
Joined on 08-18-2006
Dallas, Texas
Posts 1,558

Re: Installation Trouble

Reply Contact

Hi Jason,

Good job on figuring out the database connection issue, we are investigating the best way to resolve this new issue.

Matt Faus / Microsoft InfoPath MVP
Qdabra® Software / Streamline data gathering to turn process into knowledge

06-26-2007 10:11 PM In reply to

Patrick Halstead
Joined on 08-08-2006
Kirkland, Washington, USA
Posts 2,024

Re: Installation Trouble

Reply Contact

Hi Jason,

What are the errors in the Event Viewer log for Qdabra?

Patrick Halstead / Microsoft InfoPath MVP
Qdabra® Software / Streamline data gathering to turn process into knowledge

06-26-2007 10:15 PM In reply to

Clay Fox
Joined on 06-27-2006
USA
Posts 1,915

Re: Installation Trouble

Reply Contact

Hey Jason, sorry for the problems.

The issue has to do with SharePoint 2007 and the httpmodules. We typically see problems after install and have a configuration change to accomodate but I have not seen this before. I am checking to see what can be done with an issue preventing install.

We will have an answer for you shortly.

Clay Fox / Microsoft InfoPath MVP

Filed under: DBXL

06-26-2007 10:54 PM In reply to

Jim Cantwell
Joined on 08-07-2006
Sammamish, WA
Posts 63

Re: Installation Trouble

Reply Contact

If you have SQL Express, the server name will be (LOCAL)\SQLEXPRESS

Jim Cantwell
Qdabra® Software / Streamline data gathering to turn process into knowledge

06-26-2007 11:08 PM In reply to

Jim Cantwell
Joined on 08-07-2006
Sammamish, WA
Posts 63

Re: Installation Trouble

Reply Contact

If it is the <httpModules> section issue, you can apply the change to the web.config before the install completes. After the tabbed dialog pops up prompting to enter logon informatino, go to c:\inetpub\wwwroot\wss\virtualdirectories\80\QdabraWebService\ and edit the web.config (the directory may be slightly different, but you should find it under there). Then complete the install. I haven't seen this issue come up during install, but that may be the problem.

Another thing to try is to do an IISRESET just before install. Don't access the sharepoint site until you have completed the install. The sharepoint assemblies causing the problem may not have gotten loaded then.

Jim Cantwell
Qdabra® Software / Streamline data gathering to turn process into knowledge

06-27-2007 08:20 AM In reply to

jthrasher
Joined on 12-27-2006
Posts 19

Re: Installation Trouble

Reply Contact

Thanks for all the help everyone, I really appreciate it.

I went ahead and tried to modify the web.config file mid-install but it had no effect, it still errored out with the same message. I also tried doing the IISRESET but no luck there either.

06-27-2007 09:33 AM In reply to

Clay Fox
Joined on 06-27-2006
USA
Posts 1,915

Re: Installation Trouble

Reply Contact

The other thought some of us had was to stop SharePoint services, run the install, update the web config, restart SharePoint.

Also have you looked in event viewer at the Qdabra Errors?

There might be some clues there.

Clay Fox / Microsoft InfoPath MVP

06-27-2007 09:41 AM In reply to

jthrasher
Joined on 12-27-2006
Posts 19

Re: Installation Trouble

Reply Contact

here is the exact error from the event log. I'll try again stopping SharePoint services.

Event Type: Error
Event Source: Database Accelerator
Event Category: None
Event ID: 2000
Date:  6/27/2007
Time:  8:18:27 AM
User:  N/A
Computer: MOSS_TEST
Description:
Error initializing DBXL database.
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<HTML dir="ltr">
<HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8" /><meta HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX" /><title>

Error

</title><link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/>
<script type="text/javascript" language="javascript" src="/_layouts/1033/init.js?rev=VhAxGc3rkK79RM90tibDzw%3D%3D"></script>
<script type="text/javascript" language="javascript" src="/_layouts/1033/core.js?rev=F8pbQQxa4zefcW%2BW9E5g8w%3D%3D"></script>

<TR height="100%"><TD><TABLE width="100%" height="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="ms-titlearealeft" id="TitleAreaImageCell" valign="middle" nowrap><div style='height:100%' class='ms-titleareaframe'></div></td>
<td class="ms-titleareaframe" id="TitleAreaFrameClass">

<table cellpadding=0 height=100% width=100% cellspacing=0>
   <tr><td class="ms-areaseparatorleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=1 alt=""></td></tr>
</table>

</td>
<td valign=top id="onetidPageTitleAreaFrame" class='ms-areaseparator' nowrap width="100%">
   <table id="onetidPageTitleAreaTable" cellpadding=0 cellspacing=0 width=100% border="0">
    <tr>
  <td valign="top" class="ms-titlearea">

    <a href="http://moss_test" id="ctl00_PlaceHolderTitleBreadcrumb_idSimpleGoBackToHome">Go back to site</a>

  </td>
    </tr>
    <tr>
  <td height=100% valign=top ID=onetidPageTitle class="ms-pagetitle">
    <h2 class="ms-pagetitle">

Error

    </h2>
  </td>
    </tr>
   </table>
</td>
<td class="ms-titlearearight">


<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
</tr>

<TR>
   <TD class="ms-leftareacell" valign=top height=100% id="LeftNavigationAreaCell">
    <table class=ms-nav width=100% height=100% cellpadding=0 cellspacing=0>
  <tr>
   <td>
    <TABLE height="100%" class=ms-navframe CELLPADDING=0 CELLSPACING=0 border="0">
     <tr valign="top">
   <td width="4px"><IMG SRC="/_layouts/images/blank.gif" width=4 height=1 alt=""></td>
   <td valign="top" width="100%">







   </td>
     </tr>
     <tr><td colspan=2><IMG SRC="/_layouts/images/blank.gif" width=138 height=1 alt=""></td></tr>
    </TABLE>
   </td>
   <td></td>
  </tr>
    </table>
   </TD>
   <td>
<div class='ms-areaseparatorleft'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
   <td class='ms-formareaframe' valign="top">
  <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="ms-propertysheet">
   <TR valign="top" >
   <TD class="ms-descriptiontext" width="100%">

   </TD>
      <TD ID=onetidYPadding width="10px"><IMG SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></TD>
    </TR>
    <TR >
   <TD ID=onetidMainBodyPadding height="8px"><IMG SRC="/_layouts/images/blank.gif" width=1 height=8 alt=""></TD>
    </TR>
    <tr>
    <td valign="top" height="100%">
      <A name="mainContent"></A>

<table width=100% border=0 class="ms-titleareaframe" cellpadding=0>
<TR>
<TD valign=top width="100%" style='padding-top: 10px' class='ms-descriptiontext'>
    <span id="ctl00_PlaceHolderMain_LabelMessage">The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.</span>
    <P><span class="ms-descriptiontext">
  <span id="ctl00_PlaceHolderMain_helptopic_troubleshooting"><A Title="Troubleshoot issues with Windows SharePoint Services. - Opens in new window" HREF="BLOCKED SCRIPTHelpWindowKey('troubleshooting')">Troubleshoot issues with Windows SharePoint Services.</A></span>

  </span>
</TD>
</TR>
</table>
<script type="text/javascript" language="JavaScript">
var gearPage = document.getElementById('GearPage');
if(null != gearPage)
{
   gearPage.parentNode.removeChild(gearPage);
   document.title = "Error";
}
</script>

    </td>
    </tr>
  </table>
   </td>
   <td class="ms-rightareacell">
<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
</TR>
<tr>
<td class="ms-pagebottommarginleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
<td class="ms-pagebottommargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
<td class="ms-bodyareapagemargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
<td class="ms-pagebottommarginright"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
</tr>
</TABLE></TD></TR>
</TABLE>

   <input type="text" name="__spDummyText1" style='display:none;' size=1/>
   <input type="text" name="__spDummyText2" style='display:none;' size=1/>
</form>

</BODY>
</HTML>

--.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

06-27-2007 09:54 AM In reply to

jthrasher
Joined on 12-27-2006
Posts 19

Re: Installation Trouble

Reply Contact

When turning off SharePoint Services I get the following error

Event Type: Error
Event Source: Database Accelerator
Event Category: None
Event ID: 2000
Date:  6/27/2007
Time:  9:51:56 AM
User:  N/A
Computer: MOSS_TEST
Description:
Error initializing DBXL database.
Unable to connect to the remote server

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

The Qdabra Install Wizard has a error says:

The installation failed, and the rollback has been performed. --> Error initializing DBXL database. --> Unable to connect to the remote server. --> No connection could be made because the target machine actively refused it.

06-27-2007 10:15 AM In reply to

Jim Cantwell
Joined on 08-07-2006
Sammamish, WA
Posts 63

Re: Installation Trouble

Reply Contact

Please verify access using 'SQL Server Manager' and the SQL server instance used e.g. '(LOCAL)\SQLEXPRESS'

Jim Cantwell
Qdabra® Software / Streamline data gathering to turn process into knowledge

06-27-2007 10:18 AM In reply to

jthrasher
Joined on 12-27-2006
Posts 19

Re: Installation Trouble

Reply Contact

I have verified the access using the "test connection" button and there seems to be no issues. Is there something else I should check?

06-27-2007 11:43 AM In reply to

jthrasher
Joined on 12-27-2006
Posts 19

Re: Installation Trouble

Reply Contact

maybe this information will help

Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date:  6/27/2007
Time:  11:31:13 AM
User:  COMPANY\USER
Computer: MOSS_TEST
Description:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{61738644-F196-11D0-9953-00C04FD919C1}
to the user COMPANY\USER SID (S-1-5-21-1722490270-620562974-1691616715-4085). This security permission can be modified using the Component Services administrative tool.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

06-28-2007 10:00 AM In reply to

jthrasher
Joined on 12-27-2006
Posts 19

Re: Installation Trouble

Reply Contact

Any more suggestions? I'd really like to try out this product.

Thanks

Page 1 of 3 (34 items) 1 2 3 Next >