Sharepoint 3.0 and SQLE (Advanced)
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.
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.