Setup MS SQL 2014 on Windows Server 2012 R2

From Notes_Wiki

Home > Windows > Windows Server 2012 R2 > Setup MS SQL 2014 on Windows Server 2012 R2

  1. Install Windows Server 2012 R2 and make machine member of domain
    In case of a cloned VM before adding to domain, it might make sense to go to Windows -> Run and execute 'sysprep'. System cleanup action - OOBE, generalize (MUST) and shutdown options - Reboot. Set timezone and keyboard. Set administrator password.
  2. Get setup of MS SQL 2014 from appropriate sources
  3. Start installation to get to "SQL server installation center" screen
  4. Click on "Installation" below planning on left tab
  5. Select "New SQL server stand-alone installation" option
  6. If key is availble enter it else choose "evaluation" to proceed
  7. Accept the license terms and click next
  8. Enable use of microsoft updates to check for updates and click next. This assumes decent Internet bandwidth.
  9. On Windows Firewall warning optionally disable Windows firewall and rerun the tests.
  10. On "Setup Role" choose "All features with defaults" and click next
  11. On "Feature selection page click next.
  12. On feature rules page in case of .Net framework 3.5 warning open Server Manager.
    1. Add "Roles and features" for local server and under features select ".NET Framework 3.5 Features".
  13. On instance configuration page choose "Default Instance". Leave instance ID MSSQLSERVER as it is. Click next.
  14. On "server configuration" leave service accounts, collation tabs as it is and click next.
  15. On "Database engine configuration" leave "Windows authentication mode" selected. Under SQL server administrators add domain administrator (Eg RND\administrator). Leave data directories and filestream as it is and click next.
  16. On "Analysis Services Configuration" page add both local and domain administrator and click next.
  17. On "Reporting Services Native Mode" leave "Install and configure" selected. For sharepoint integrated mode leave "Install only" selected. Click next.
  18. On "Distributed Replay Controller" page add both local and domain administrator and click next.
  19. On "Distributed Replay Client" leave defaults and click next
  20. On "Ready to install" page click "install"
  21. Once setup is complete click "Close" to complete the setup.
  22. Open "SQL Server Configuration Manager" from Windows application menu.
    1. Go to "SQL server Network Configuration" -> "Protocols for MSSQLServer".
    2. Double click on "TCP/IP".
    3. Go to "IP addresses" tab.
    4. Against each IP (eg 172.17.1.105) for which network access should work change Enabled from No to Yes.
    5. Click Apply and ok.
  23. Go to "SQL server services". Restart "SQL Server"
  24. Optionally configure MSDTC security settings for remote access.
    1. For configuring MSDTC security settings for remote access search for "Component services"
    2. Go to "Computers" (Double click) -> " My Computer" -> Distributed Transaction Coordiantor -> Local DTC.
    3. Right click on "Local DTC" and select properties.
    4. Go to Security tab.
    5. Select "Network DTC Access".
    6. Under it select all four checkboxes. Leave other options as it is and click ok.
    7. On warning click "yes".

Refer: - http://itconfig.tech/vra-6-2-error-executing-query-usp_selectagentcapabilities/



Home > Windows > Windows Server 2012 R2 > Setup MS SQL 2014 on Windows Server 2012 R2

Retrieved from "http://www.sbarjatiya.com/notes_wiki/index.php?title=Setup_MS_SQL_2014_on_Windows_Server_2012_R2&oldid=5687"