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: 4199

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

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?



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

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.