Xathrya Sabertooth

Installing SQL Server 2012 on Windows Server 2012
Installing DNS Server on Windows Server 2012
Disable Ctrl + Alt + Delt Prompt to Login Windows Server 2012
Enable Sound on Windows Server 2012

Installing SQL Server 2012 on Windows Server 2012

Posted: 14 Nov 2013 11:51 PM PST

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.web.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.

Installing DNS Server on Windows Server 2012

Posted: 14 Nov 2013 10:24 AM PST

Domain Name System (DNS) is a hierarchical distributed naming system for computers, services, or any resource connected to the Internet or a private network. It associates various information with domain names assigned to each of the participating entities. Most prominently, it translates easily memorized domain names to the numerical IP addresses needed for the purpose of locating computer services and devices worldwide. By providing a worldwide, distributed keyword-based redirection service, the Domain Name System is an essential component of the functionality of the Internet.

Windows Server 2012 use it’s own DNS server program, named Microsoft DNS. This is the default on any Windows Server.

Like any service on Windows Server 2012, Microsoft DNS is implemented as server role. This article will discuss about how to install DNS service in Windows Server 2012.

Installation

Open “Server Manager” from task bar, if you have not opened it yet.

From “Server Manager” Dashboard, select “Add roles and features”. This will launch the Roles and Features Wizard allowing for modifications to be performed on the Windows Server 2012 instance.

Select “Role based or features-based” installation from the Installation Type. Roles are the major feature sets of the server, such as IIS. Features provide additional functionality for given role.

When asked for destination server, select the current server. It should be chosen by default. Click “Next” button to proceed.

From the Server Roles, choose the option “DNS Server” by checking it. A notice will appear explaining additional roles services or feature are also required to install domain services.

If you don’t set your machine using static IP address, you will get a warning message. Make sure you set your machine to static IP address so client can resolve your machine. However, you can always ignore it and go to next stage for installation.

Now we will be brought to “Features” page. Review and select optional features to install during installation of DNS Server. You can check any features but we will leave it as is.

Review the information. Click Next.

Review the installation. This page will show you information about what will be installed. When ready, press “install” button.

Installation will take on. It should not be long, but that will depend on your machine. In installation process, a progress bar will be displayed on the screen. Once Active Directory role is installer, it will be displayed on the ‘Server Manager’ landing page.

Disable Ctrl + Alt + Delt Prompt to Login Windows Server 2012

Posted: 14 Nov 2013 09:54 AM PST

By default, whenever we boot Windows Server 2012 we will be asked to press ctrl + alt + del on logon screen. Sometimes this is annoying and fortunately we can remove it so we can start typing the username and password without pressing ctrl+alt+del.

In this article we will discuss about how to disable Ctrl+Alt+Del prompt.

The Idea

Everytime we login we need to press Ctrl+Alt+Del. This policy is defined by Windows on “Local Security Policies” and can be disabled manually.

How to Enable

Open the “Start” screen, click “Administrative Tools”.

Double click the “Local Security Policy” icon, expand Local Policies and click Security Options. In the right pane search and open”Interactive logon: Do not require CTRL+ALT+DEL” and choose “Enabled“. Save the policy change by clicking OK.

Enable Sound on Windows Server 2012

Posted: 14 Nov 2013 09:04 AM PST

By default, Windows Server 2012 disables audio. This of course has a reason. Most servers won’t need it. However, you can always enable manually or make it enable by default.

In this article we will discuss about how to enable sound on Windows Server 2012.

The Idea

Sound is a service. Like any other service, it can be manually started or we can set it enabled automatically on every boot time.

How to Enable

Go to Services window. There are two ways to do that. First: Open the “Start” screen, click “Administrative Tools” and open the “Services” shortcut. Second: press CTRL+R (opening Run dialog) and type “services.msc“.

You will see a window for Services.

Search for “Windows Audio” service and double click it (or press enter button on it). We will be presented by another window.

If we want it to enable for only this time, click on “Start” button. If you want it to run automatically, set its “Startup type” to “Automatic“. Repeate this process for “Windows Audio Endpoint Builder” service. If you want to use audio immediately, also click the Start button in the Properties window of both services in addition to changing the Startup type.

Proyek Teknologi

Jumat, 15 November 2013