I've installed a search server 2008 express in the virtual machine(VMWare), and ran the configuration wizard.
I'm trying to connect to an existing SQL server 2005 express(which is run at host) to create a new config db
I supply the instance name ("lindy\sqlexpress") and credentails
("domain\sqladmin") but keep getting "Failed to connect to the database
server" (see full error below). SQL instance is up and runining, SQL
managment studio installed on the search server 2008 machine (virtual machine) has no problem to connect to
the same instance located on host.
The error message:
SharePoint Products and Technologies Configuration Wizard
Failed to connect to the database server or the database name does not
exist. Ensure the database server exists, is a Sql server, and that you have
the appropriate permissions to access the database server. To diagnose the
problem, review the extended error information located at C:\Program
Files\Common Files\Microsoft Shared\Web Server
Please consult the SharePoint Products and Technologies Configuration Wizard
help for additional information regarding database server security
configuration and network access.
I had such this problem and I have some solution to solve problem:
First test connectivity with IP address if you connected successfully then :
1. Make sure that you type server name correctly. (Check again. I had this problem!)
2. Check DNS healthy.
3. Use “ipconfig /flushdns”.
4. Check you SQL server and make sure about any firewall restriction.
I hope to be succeed.