Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...Configuring SQL Server Express 2005Configuring SQL Server Express 2005
Previous
 
Next
New Post
12/29/2009 8:45 PM
 

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.

 


hedera
**********
Nature bats last.
 
New Post
12/29/2009 9:36 PM
 

I usually enable TCP\IP and Named Pipes on my local instance, just makes it easier.  For a production server though, I think you want to disable TCP\IPand only enable named pipes to make it more secure.

 
New Post
12/30/2009 12:42 AM
 

Shawn, thanks so much for confirming my suspicions.  Now if I can just find out where to find the SQL Server Surface Area configuration tool, I'm in business.  Somehow it didn't download with the rest of SQL server; or maybe it requires the 32-bit ASP.Net that the installer complained about.  But that's another problem for another forum; I really appreciate your help.


hedera
**********
Nature bats last.
 
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...Configuring SQL Server Express 2005Configuring SQL Server Express 2005


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out