[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2011-03-11
3
Medium Priority
?
1,581 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article I will describe the Backup & Restore 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.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

649 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