Sharepoint 3.0 and SQLE (Advanced)

[Lithium]

I've got 2 totally blank S2K3 boxes.

 

One has SQL 2K5 Express w/ Advanced Features installed...

The other has IIS installed.

 

Firstly.., did I miss something in the above?

 

Secondly, I've followed the DBA part of Microsoft's Deployment guide and opened TCP/IP and Named ports for remote connections and added 2 accounts (one didn't like the password... but it's right..) as administrators - I don't know if they went in...

 

Whenever I run through the Advanced, Web Front End install on the Application Box, when I am asked to connect to the SP_Config database, it fails (Error 40)

 

The name is right, tried both fully and non-FQL names and FQL/netbios usernames and nothing I try can get connected to it.

 

Any ideas/solutions?

 

I didn't manage to find any thus far and I've tried pretty hard to find a solution.

 

 

Answer: Database Server Name is not the name of the server itself, but the instance name: MyServerName\SQLExpress (for a default install)

 

If you need to know the name of it, open the Management Studio thingy and it tells you there when asked what you want to connect to.