MS: Install SQL Server 2008 on Windows 2008 R2

Install .NET Framework 3.5.1 on Windows 2008 R2 (Features)

Install SQL Server 2008 with SP1. You must slipstream SP1 on SQL Server 2008 RTM image.

Check How to update or slipstream an installation of SQL Server 2008
http://support.microsoft.com/kb/955392

MS: Always ask before opening this type of file

When you open a link or URL for a file in Internet Explorer (IE) or any browser like FireFox, you will receive this dialog:


File Download

Do you want to open or save this file?

Three buttons: Open - Save - Cancel

And one checkbox Always ask before opening this type of file

The solution is add (or modify existing) registry key to the machine (you can use a GPO to update several machines)

Microsoft Word 2003 (.doc):

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Word.Document.8]
@="Microsoft Word Document"
"EditFlags"=dword:00010000
"BrowserFlags"=dword:00000008

Microsoft Word 2007 (.doc):

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Word.Document.8]
@="Microsoft Office Word 97-2003 Document"
"EditFlags"=dword:00010000
"BrowserFlags"=dword:00000008

Word 2007/2010 (.docx):

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Word.Document.12]
@="Microsoft Office Word Document"
"EditFlags"=dword:00010000
"BrowserFlags"=dword:00000008

Microsoft Excel 2003 (.xls):

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Excel.Sheet.8]
@="Microsoft Excel Worksheet"
"EditFlags"=dword:00010000
"BrowserFlags"=dword:00000008

Microsoft Excel 2007 (.xls):

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Excel.Sheet.8]
@="Microsoft Office Excel 97-2003 Worksheet"
"EditFlags"=dword:00010000
"BrowserFlags"=dword:00000008

Excel 2007/2010 (.xlsx):

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Excel.Sheet.12]
@="Microsoft Office Excel Worksheet"
"EditFlags"=dword:00010000
"BrowserFlags"=dword:00000008

Adobe Acrobat 7.0

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\AcroExch.Document]
"BrowseInPlace"="1"
"EditFlags"=dword:00010000
@="Adobe Acrobat 7.0 Document"
"BrowserFlags"=dword:00000008

Adobe Acrobat 9.0

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\AcroExch.Document]
"BrowseInPlace"="1"
"EditFlags"=dword:00010000
@="Adobe Acrobat Document"
"BrowserFlags"=dword:00000008