Microsoft SQL Server, also called as SQL Server only, is a relational database management system (rdbms) developed by Microsoft. It is used to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). SQL Server use structured query language (SQL), technically they are T-SQL and ANSI SQL.
Some applications are likely high-coupled with Microsoft SQL Server. In simple term, they are works with SQL Server around. This is normal for Windows applications.
In this article we will discuss about how to install Microsoft SQL Server 2012 on Windows Server 2012. SQL Server 2012 has four editions: Enterprise, Standard, Developer, and Express edition. We will use Microsoft SQL Server 2012 Developer edition. This edition only suitable for development process. However this is enough, as the installation process is roughly same for any edition.
Another Extra Info
SQL Server Standard and Enterprise Edition usually used for production, while Developer Edition used for development. If we use one of them, we can also install another tool set beside SQL Server DBMS, for example: SQL Server Reporting Service, SQL Server Analysis Service, and SQL Server Integration Service.
Stage 1: Add New Username to Active Directory
If you have installed Active Directory, you should add new username in your active Directory. This username is used for SQL Server and also this step is always done if you want to create a bigger service such as SharePoint. The username for SQL Service is service and different with other username, so we will create it to new Organizational Unit (OU). Let name it as WINDEV (My machine’s NetBIOS name) so our username would be WINDEV\SQL_Service.
Open “Start screen” and choose “Active Directory Users and Computers“. Right click to your domain controller, in my case it is “windev.xathrya.id”. Navigate to New > Organizational Unit. Then create the name you prefer.
Then, create new user under WINDEV, SQL_Service
Click Next and set the password. Don’t forget to uncheck “User must change the password at next logon” and check “Password never expires”.
Stage 2: SQL Server Installation
If you have the DVD, insert it to tray. If you have the ISO, mount it. Either way, you should have opened and see a setup executable file. Run it and wait until the installation window appears.
Click on “Installation” on left pane. Then, click on “New SQL Server stand-alone installation or add features to an existing one”. Wait for next page.
SQL Server installer will do some checks. It will be decided whether your machine is fulfilling the prerequisites or not for installation.
Next, enter the product key. As said before, we are using SQL Server 2012 Developer Edition.
The next screen prompts us to accept the license terms. We can also opt to send anonymous feature usage data to Microsoft. It is recommended to do this as Microsoft actually uses this data to qualify and prioritize future development efforts.
SQL Server also checks for updates. However we can exclude the update for now.
Setup then checks for conditions that may interfere with the installation of setup support files:
On above window, I would install the SQL Server on same machine as my Domain Controller. In the real world, actually we don’t do this. We have separate machine for Domain Controller and SQL Server.
Next select the setup role in the installation process. We choose “All Features With Defaults,”
Click next to continue to the Feature Selection. The content would be populated based on our machine. We also install it to default path, so we won’t lay our finger there.
Setup next checks installation rules.
Next we determine the instance ID. This is the ID for SQL Server in our machine. It should be unique if it is used in production level when more than one SQL Server is used. In our case, we are only using it for developing so we won’t mess with it.
Setup will calculate the disk space. Roughly 7GB is required when we install all the features (default features).
Next we do service account configurations. We use WINDEV\SQL_Service for all account, and remember to set the password.
Database engine configuration includes Authentication Mode and SQL Server Administrators. You can accept the defaults if you want. We use Mixed Mode Authentication (combined with very strong passwords) for my installations. Clicking the Add Current User button adds me to the SQL Server administrators
Next we have Analysis Services setup. I mostly work with Tabular Model these days. As before, I click the “Add Current User” button to add this account to the Administrators:
Accept the defaults for Reporting Services configuration:
Click on “Add Current User” button.
Give DRC (Distributed Replay Client) a name. In this case, I use XathWinServ2012Sql:
Next we have Error Reporting page. Just click on Next.
Then, Installation configuration rules are checked for consistency and readiness.
Next we will be presented by a confirmation page. When you decided to accept the configuration, click Install to begin installation.
Installation will take some times. You should grab some food or doing something else.
When the process come to end, it’s time to celebrate it. You have installed the SQL Server 2012.database, windows