Solved

Can't complete FAST configuration because "Database validation failed".

Posted on 2011-03-11
3
1,532 Views
Last Modified: 2012-05-11
I have a trusted SQL Server 2008 on one box, I've installed SharePoint Server 2010 on another, and I've installed FAST Search Server 2010 for SharePoint on yet another.

But when I run the "Microsoft FAST Search Server 2010 for SharePoint Configuration Wizard" I can't go pass "Database settings".

I'm asked for "Database connection string", and I type "[FQDN_My_SQL]\MSSQLSERVER", which is -- AFAIKS -- the server name and instance name respectively.

(The other fields I leave as they are: Database name "FASTSearchAdminDatabase" and Database port "1433".)

When I click next I get an error message with title "Database validation failed": 'Could not connect to the database. Check the database connection string, the database name and the port number to the database server.' (Note that the database aren't there and is not being created now, but after the guide is completed.)

Of course I've double checked and triple checked everything to the best of my ability (connections, instance name, etc), but I cannot find out why the configuration guide won't accept my database connection string.

Any help much appreciated.
0
Comment
Question by:Jack_A_Roe
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
jonaska earned 500 total points
ID: 35107851
Can you connect to the database instance from the SP machine otherwise?
Create an empty textfile, rename the suffix from txt to udl and double klick on the new file. The file should now open with another tool where you can choose database provider and so on...
You can allso try to resolve your database name to an IP adress and use that in the connection string.
Notice that SQL Express does not accept network connections by default.
0
 

Author Comment

by:Jack_A_Roe
ID: 35107988
Thank your very much for the reply, the UDL-file was a great troubleshooting tool -- I didn't know about it before.

From the FAST Server, I can use the udl-file to connect to databases on the SQL server without any problem.

The notable difference though, is that with the UDL-tool I only select a server name, not a connection string, to connect to the SQL server.

In the wizard I'm supposed to type a "Database connection string", and in the white paper Deployment guide for FAST Search Server 2010 for SharePoint they say
Enter the Database connection string in the format <ServerName>\<DBInstanceName> ... (p. 13)

However, when I (thanks to you jonaska) try the format SERVERNAME instead, it works!

But now I'm a little bit nervous... Should I continue with SERVERNAME as Database connection string instead of <ServerName>\<DBInstanceName>? Will my FAST Search Server break eventually if I do so?  :-(
0
 
LVL 6

Expert Comment

by:jonaska
ID: 35108151
You can see the connection string if you open up the udl file with notepad.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now