Problem installing PS2K3 on a single Win2K3 AD\SQL machine

A

Arno

Ha,

Maybe I've to ask this in a SQL or Win newsgroup, but I want to start
here...

I'v installed Win2K3 with AD on a single machine. After that I installed SQL
Server (2000 sp3) on that same machine. Now when I try to install PS2K3 I
can't get passed the "enter database server information". If I select
"Create a new database", it returns that it requires a mixed mode SQL
Server. When I switch to SQL Server authentication it replies that it can't
find the server.
My guess is that it has something to do with security on this AD machine,
but what???

I have to do all this on a single machine. It's for testing purpose and we
don't have an AD domain here, so the sysboys won't like it when I hook up
this AD machine to the network :)

Regards,

Arno
 
G

Gary L. Chefetz \(MVP\)

Arno:

Your instance of SQL is configured to support Named Pipes transport only.
You need to configure it to support TCIP. Open Enterprise Manager and Expand
the tree to your server. On the action menu, select properties. On the
General Tab, select Network Configuration button and enable TCP/IP.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-
 
A

Arno

Thanx for the tip. TCP/IP was allready enabled.
But the authentication was Windows only (I thought I said both during the
install). Now it is both and the PS install accepts "connect using Windows
authentication"
MS walks in mysterious ways :)

greetz,

Arno
 
Top