Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

PSConfig error: Failed to connect to the database server or the data

  Asked By: Conor    Date: Oct 18    Category: MOSS    Views: 3772

Has anyone encountered this and actually found a solution? I have one MOSS
2007 box and a SQL 2008 box; my service accounts can all connect to the DB
server with SQL Management Studio (which is installed on the SQL box), and I
can ping the database server from the SharePoint server, but when I run
PSConfig (proper server name, proper account credentials, I get this lovely
error:

The server parameter specified with the configdb command is invalid.
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.

The SharePoint logs basically say the same thing again (with a stack
trace). TCP/IP and Named Pipes are both turned on (just for grins), remote
connections are enabled... what in the world could be going wrong here?

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Bailey Lewis     Answered On: Oct 18

Have you tried connecting via the SQL management studio from your MOSS
machine? Are there any intermediate firewalls (like Windows firewall)
that might be port blocking?

 
Answer #2    Answered By: Quentin Cummings     Answered On: Oct 18

I wanted to, but couldn't get it installed (this is all via VPN to a
client).

Turned out to be the firewall; that'll teach me to assume that they've taken
care of everything.

 
Answer #3    Answered By: Bhoomi Chabaria     Answered On: Oct 18

For starters, have you tried using the data  Sources app under admin tools to
verify your connection to the DB? When we connect, we have to use
servername\instance<file:///\\servername\instance> to connect  because we are not
using the default instance of the database.

 




Tagged: