Installing SQL Tools on WS08

From Steven Stevenson:

Installing tools on Server 2008  - Especially SQL 2005 64 bit (New UAC user controls limit even Administrators group permissions on what it considers system based exe's - right click and run as administrator where permissions denied.)

1.  make sure after you have installed applications you bring up server manager 2.  Add Role and choose iiS.

        Make sure these items checked

        - Check all Common HTTP Features

        - Check all Application Development

        - HTTP Logging

        - logging  tools

        - Tracing

        - Security

        - Windows Auth

        - URL Auth

        - Request Filtering

        - IP and Domain restrictions

        - All Management tools (especially iis 6.0 compatibility as this affects some of SQL installation tests)

        - all FTP publish Service

2.5 Add Features

        - .Net 3.0 (Rumor has it this will install .net 2.0 automatically.)


3. Run this Script cscript

%SystemDrive%\inetpub\AdminScripts\adsutil.vbs setw3svc/AppPools/Enable32bitAppOnWin64 0

        - If you dont you end up with Warning in testing of SQL install and Reporting Services will not install


4. Install tools.  MagicISO Virtual CD/DVD has a mounting application freeware that works with 2008 Server

5. If you need to add dll to system searchable path and be able to load it you must put them in the sysWOW64 folder