Solved

Failed to connect to database (Configuration Wizard)

Posted on 2007-11-19
12
1,666 Views
Last Modified: 2012-06-22
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.
0
Comment
Question by:mtdzgl
[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
  • 5
  • 4
12 Comments
 
LVL 18

Expert Comment

by:Yveau
ID: 20318387
Did you enable the network protocols via the Configuration wizrd for that instance ?
By default you cannot connect from the network to a SQL Server 2005 instance.

Start | Programs | Microsoft SQL Server 2005 | Configuration Tools | SQL Server Configuration Manager
open the Network Configuration folder, click on Protocols for <instance name> and enable the TCP/IP and Named Pipes protocols. Restart SQL Service (as told in the popup) and your back in business.

Hope this helps ...
0
 

Author Comment

by:mtdzgl
ID: 20318475
Thanks! But I've enable the TCP/IP and named Pipes protocals, i.e. the SQL 20005 express remote access is enable. I can connect the instance by SQL managment studio installed on the search server 2008 machine. But it isn't ok by the SharePoint Products and Technologies Configuration Wizard.
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20318820
Can you run a trace on the SQL Server to see what connection attempt is made ?
0
Don't Miss ATEN at InfoComm 2017!

Visit booth #2167 to see the  new ATEN VM3200 32 x 32 Modular Matrix Switch. Other highlights include the VE8950 4K HDMI Over IP Extender, VS1912 12-Port DP Video Wall Media Player  and VK2100 ATEN Control System. Register now with Free Pass Code ATEN288!

 

Author Comment

by:mtdzgl
ID: 20325098
Thanks! Could you please tell me how to run the trace on the SQL server?
The SQL server is installed on host, the sharepoint service and search server 2008 are installed on virtual machine. Sometimes it failed if visit host through virtual machine.  Maybe it is the problem. But It is strange that SQL manage studio run at virtual machine is ok to visit SQL server.
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20326064
From a machine that can connect to the SQL Server and has the tools installed, run SQL Profiler (Start | Programs | Microsoft SQL Server 2005 | Performance Tools | SQL Server Profiler)
Connect to the SQL Server and create a new trace (from a blank template) and go to the events tab. Scroll to the Security Audit and open the folder. Mark the items 'Audit Login', 'Audit Login Failed' and 'Audit Logout'. Start by clicking Run.

Now you will see a list of all successful logins, failed logins and logout events.

Try to connect from the app's and see what the trace is showing you ... and tell us, so we can help you from there on.

Hope this helps ...
0
 

Author Comment

by:mtdzgl
ID: 20326175
I installed the SQL server 2005 express which is free version. Maybe no trace function. Anyway, thanks a lot!
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20330323
... is it working now ?
0
 

Author Comment

by:mtdzgl
ID: 20338695
I'm troubleshooting. I will get back to you if it works. I think it is the virtual machine problem.
0
 

Author Comment

by:mtdzgl
ID: 20342578
maybe it is impossible mission that remote connect the database for sharepoint service.
I run the SQL server express same with Search Server express. it is ok now.
0
 

Accepted Solution

by:
mhdhallak earned 125 total points
ID: 21988990
try this Programs --> SQL SERVER 2005 -->Config Tools --> SQL Server 2005 Surface Area Configthen Surface Area Config for Services and Connections, Go to the specific SQL instance (SQLXYZ for example) and allow the remote connection
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
Teach the user how to edit .vmx files to add advanced configuration options Open vSphere Web Client: Edit Settings for a VM: Choose VM Options -> Advanced: Add Configuration Parameters:
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

707 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