InfoPath Dev

Hi

I installed this once before with a full version of SQL and all was fine because obviously I knew the passwords and DB settings for SQL.
Now I'm looking to test it on a proper webserver, I want to keep all applications default, so I installed Sharepoint services with the bundled SQL Express - trouble is I can't get into SQL express because it's all sealed up - so what are the default settings for QDABRA? I can't seem to get the installation to communicate with SQL.

Thanks

Bob

Hi Bob.

As part of the install, two new databases will be created in SQL Express.

You must be using an account that has SysAdmin permissions or at least permisison to create new databases in SQL when running the install.  The install also will need to assign permisisons to the Network Services account to be able to access the databases from the web services.

With SQL Express you will need to replace (local) with your machine name\SQLEXPRESS as this is the default instance name for SQL Express.  You can do the test connection on the Database Enumeration tab to verify.

If you need additional assistance email me and I can help you out.

Clay

Yes, I saw that information in another post and I tried that but failed because I was thinking "local" was a term SQL often uses - replacing with the server name works, but now I'm failing with the dbase enumerator, because I don't know the default dbase

Bob

The default database is not required and can be left blank.  The database is a parameter in the query itself so it can be set dynamically.

Are you getting an additional error?  You can go to the Event Viewer and see any Qdabra errors. Please email me the text to help troubleshooting.

Clay

"An error has occured while establishing a connection to SQL Server 2005, This may be caused by the fact that SQL Server does not allow remote connections.(Provider: named pipes - error 40)

Ok this is a SQL setup.

 Under Configuration tools go to surface area configuration

Then Surface Area Configuration for Services and Connections

In the tree view under Database Engine select Remote connections

Select to use both.

This will allow the connectivity you need.

If that's an SQL setting, I can't get in there becase I don't know the password - it just installed without asking the normal polite questions.

Sorry.

From the server go to start and all programs and that is where the SQL Surface AreaConfiguration program is.  You should not need to connect to a database for this.

Clay,

That's my point: There is no configuration avaiable anywhere - I'll investigate Microsoft's site.

OK, I just found out that the SQL Express setup can be opend using Windows security and the following server name: \\.\pipe\mssql$microsoft##ssee\sql\query
yes that really works!

Bob

Ok, now it installs right up to the last section then can't initialise:

Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 11001
Date:  2008-03-20
Time:  12:56:54 PM
User:  UK2\Administrator
Computer: UK2-BDC
Description:
The description for Event ID ( 11001 ) in Source ( MsiInstaller ) cannot be found.
The local computer may not have the necessary registry information or message DLL files
to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag
to retrieve this description; see Help and Support for details. The following information
is part of the event: Product: Qdabra Database Accelerator v2.1 -- Error 1001.
The installation failed, and the rollback has been performed.
--> Error initializing DBXL database. --> Cannot initialize database 'QdabraDBXL'
on server '\\.\pipe\mssql$microsoft##ssee\sql\query '.  See eventlog for details.,
(NULL), (NULL), (NULL).
Data:
0000: 3331367b 44383944 39342d43 342d4437
0010: 2d433935 31443539 4242302d 44343036
0020: 43324546 7d31

Bob

SQLExpress is different than SQL 2005.

I know lots of people have used it successfully but I do not have a box that is using it at the moment.

Also since it came bundled you probably do not get all of the options.

Here is a guide to setting up remote TCP connections without using the surface area configuration. http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Worst case you may need to install another instance of SQLExpress which will include the tools needed to configure it yourself.

Clay

Having wdaed through this http://www.eggheadcafe.com/software/aspnet/29019401/-using-sql-express-wit.aspx

I think I may just upgrade to Full blown SQL - there are no tools available in the embedded version.

Bob

Hi Bob,

 You should be able to access your SQL Server Express settings with this:

SQL Management Studio Express

You probably need to give SQL Server admin permissions to the ASPNET account.

jrishe

Cheers

Bob