?
Solved

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

Posted on 2011-03-11
3
Medium Priority
?
1,572 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
jonaska earned 2000 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

752 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