Solved

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

Posted on 2011-03-11
3
1,522 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sharepoint installation and configuration 4 45
VBA in SharePoint 3 19
affinity mask in sql server 1 8
In or Between 2 0
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 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

10 Experts available now in Live!

Get 1:1 Help Now