none
Failed to connect to database (Configuration Wizard)

    Question

  •  

    Hi,

    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
    Extensions\12\LOGS\PSCDiagnostics_12_20_2006_17_10_44_859_1832613818.log.
    Please consult the SharePoint Products and Technologies Configuration Wizard
    help for additional information regarding database server security
    configuration and network access.
    Tuesday, November 20, 2007 3:51 AM

All replies

  • any suggestion? Thx!

    Wednesday, November 21, 2007 2:39 AM
  • 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.

     

    Thursday, January 17, 2008 12:45 PM
  • Thanks your suggestions.

    Actually the virtual machine doesn't work well. Sometimes I can't visit host by virtual machine. So the problem is located on the virtual machine.

    Tuesday, January 22, 2008 3:53 AM
  • Thanks Morteza,

    Added exception to Firewall... and now the issue is resolved.


    Zulfikar

    Monday, April 23, 2012 9:57 AM