WSS Install Problem as Part of Project Server 2003

[Wes Johnson, PMP]

Here's the scenario and it's fairly straight forward:

Installed Windows Server 2003 EE
Installed SQL Server 2000 Developer's Edition
Installed SQL Server 2000 Analysis

In Enterprise Manager SQL, the SQL Database shows as [local}

Downloaded and began installing WSS 2.0

On the first screen for configuring the server, I give the database name as
{local] and the next parameter I said PROJ2003

I tell it to use SQL authentication and give it administrator as the user
name and the password and click OK

After it churns for a couple of seconds I get this error:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. (Error code: 17).





What the heck am I missing??????????????????????

 

[Juan Ma]

Here's the scenario and it's fairly straight forward:

Installed Windows Server 2003 EE
Installed SQL Server 2000 Developer's Edition
Installed SQL Server 2000 Analysis

In Enterprise Manager SQL, the SQL Database shows as [local}

Downloaded and began installing WSS 2.0

On the first screen for configuring the server, I give the database name as
{local] and the next parameter I said PROJ2003

I tell it to use SQL authentication and give it administrator as the user
name and the password and click OK

After it churns for a couple of seconds I get this error:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. (Error code: 17).





What the heck am I missing??????????????????????

You must write "localhost" like database server. If you have a
instance for the Project server database then "localhost\<instance
name>".
I recommended to write down the machine name instead of localhost.

 

[David Gage]

Also, 'sa' is the default admin SQL account. Take a look under SQL Server
Enterprise Manager --> Security --> Logins.

David
--
David Gage
Microsoft Project MVP
QuantumPM

"Wes Johnson, PMP" <[email protected]> wrote in message

Here's the scenario and it's fairly straight forward:

Installed Windows Server 2003 EE
Installed SQL Server 2000 Developer's Edition
Installed SQL Server 2000 Analysis

In Enterprise Manager SQL, the SQL Database shows as [local}

Downloaded and began installing WSS 2.0

On the first screen for configuring the server, I give the database name as
{local] and the next parameter I said PROJ2003

I tell it to use SQL authentication and give it administrator as the user
name and the password and click OK

After it churns for a couple of seconds I get this error:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. (Error code: 17).





What the heck am I missing??????????????????????

You must write "localhost" like database server. If you have a
instance for the Project server database then "localhost\<instance
name>".
I recommended to write down the machine name instead of localhost.