1
Vote

Deployment Guide - SP 2010 VRE Installing SQL Server

description

Step 4
WHY DO THEY SAY THAT THIS NEEDS TO BE DONE? THESE SECURITY SETTINGS ARE HIGH FOR A REASON.
 
Step 20
WHY DO YOU NEED ALL OF THESE SQL COMPONENTS. YOU ONLY NEED SQL DATABASE SERVICES AND MANAGEMENT TOOLS. ALL OF THE OTHER ITEMS ARE EITHER NOT NECESSARY OR ADD OVERHEAD TO THE SYSTEM. YOU DO NOT NEED REPLICATION, OR SQL INDEXING, SDK OR SYNC FRAMEWORK. THIS IS INCREASING THE ATTACK SURFACE.
 
Step 26
MISSING AN IMPORTANT STEP HERE. YOU HAVE TO SET THE SQL COLLATION SETTINGS (SEE THE TAB ON THE IMAGE ABOVE). PLEASE SEE THIS MS ARTICLE - http://support.microsoft.com/kb/2008668
 
Step 27
MIXED MODE IS NOT IDEAL AND SHOULD NOT BE USED UNLESS THERE IS A REALLY GOOD REASON. IT MAYBE DUE TO THE WAY THEY AUTHENTICATE THEIR CODE TO THE SQL DATBASES. THIS IS STILL POOR AS IT SHOULD USE AN INTEGRATED ACCOUNT IN ACTIVE DIRECTORY.
 
Step 30
NOOOOOO! THEY ARE ASKING YOU TO ADD THE APPLICATION POOL ACCOUNT FOR THE WEB SITE INTO THE SQL ADMINISTRATORS GROUP!!!! NOOOOOOOO!!!!
 
Step 34
SPSERVICES SHOULD NOT BE AN ADMIN OF SQL EITHER!!! THIS IS MADNESS!!! YOU DO NOT DO THIS.
 
Step 36
SO RIC NOW INCLUDES ANALYSIS SERVICES TOO?
 
Step 42
MORE MADNES! INSTALLING SQL REPORTING SERVICES IN NATIVE MODE. NOT ONLY DOES THIS NOT WORK WITH SHAREPOINT BUT IS A TOTAL WASTE OF RESOURCES TOO!

comments