• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1596
  • Last Modified:

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

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.
  • 2
1 Solution
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.
Jack_A_RoeAuthor Commented:
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?  :-(
You can see the connection string if you open up the udl file with notepad.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now