I've upgraded my laptop to Windows 7 Ultimate and am now rebuilding my Microsoft servers so as to get my test DNN sites back up. I've just re-installed SQL Server Express 2005, and got a series of messages about the "surface area" of SQL Server Express:
For improved manageability and security, SQL Server 2005 provides more control over the SQL Server surface area on your system.
To minimize the surface area, the following default configurations have been applied to your instance of SQL server:
o TCP/IP connections are disabled
o Named Pipes is disabled
o SQL Browser must be started manually
o OPENROWSET and OPENDATASOURCE have been disabled
o CLR integration is disabled
o OLE automation is disabled
o xp_cmdshell is disabled
To enable or disable features and services, run the SQL Server Surface Area Configuration tool from the Start menu.
It's been awhile since I did this, but I'm almost sure that to support DNN I need to enable TCP/IP connections and Named Pipes. Is this correct, and are there any other features I need to turn on to support DNN? I'm pretty ignorant of SQL server administration.