SQL Server 2012 Installation and Setup - TeamDewberry/jmxdatamart GitHub Wiki

Notes on SQL Server 2012 Installation and Setup

SQL Server 2012 (SQLEXPRADV) http://www.microsoft.com/en-us/download/details.aspx?id=29062

Installation:

  1. Install a stand-alone version
  2. Perform a new installation of SQL Server 2012
  3. Select all features (local DB is usually the only box not selected)
  4. Select ‘Default Instance’
  5. Select ‘Mixed Mode’ for Server Configure
    • The username is ‘sa’ by default (not sure if it can be changed)
  6. Select ‘Install and Configure’
    • If this causes an error, then select ‘Install Only’ (not sure exactly what causes the error)

Setup:

  1. Open ‘SQL Server Configuration Manager’ and enable the TCP/IP protocol for MSSQLSERVER or your equivalent.
  2. Double-click TCP/IP and under ‘IP Addresses -> IP All’ set the TCP Port to 1433

Server Config Manager.