How to install Microsoft SQL Server 2012 SP1 on Windows Server 2012

TECHIE >> Software
8/14/2013 9:51:43 PM

 


 


 

 

1) Open up VMware workstation 9.0

Image


2)Locate your VMware Windows 2012 server

 

3) Right Click and choose Settings

 Image

4) On the CD/DVD Drive - under the Use ISO image file - change the destination to the SQL Server 2012 install. Choose "OK"

 Image

 

5) Log onto your Windows Server 2012 server

 

6) Execute the following path

1.       Go to Tools

2.       Computer Management

3.       Disk Management(under Storage)

 Image

 Image

 

7) Right click on the CD ROM drive and choose to open.

 Image

8) Run Setup

 Image

9) You will be presented with a SQL Server Installation Center - Follow the Wizard:

 Image

10) Go to Installation and Choose "New SQL Server stand-alone installation or add features to an existing installation.

 Image

11) The first thing it will check for will run it's setup support rules to see if your Operating System passes the checks to install SQL Server 2012:

 Image

 Image

Choose "OK"

12) Next - You can enter in your product Key for SQL Server 2012. In this demo, we'll be using the evaluation license. You can enter in the activation license after the 180 day trial expiration.

 Image

Choose "Next"

13) License Terms is the next step. Read through the License terms and choose the "I Accept the License Terms" and then choose "Next"

 Image

 

14) Since we are installing SQL Server 2012 SP1, there are product updates to SQL Server. Choose to "Include the SQL Server Product Updates" and click "Next". You can review the KB articles on Microsoft's website.

 Image

 

15) SQL Server is now installing the Setup Files. Allow this to run and complete. This will take several minutes.

 Image

 

16) Click "Install" on the SQL Server 2012 Setup.

17) The Next page will include the "Setup Support Rules" on SQL Server 2012 Setup. To proceed, it will attempt to run a "status" check on the following rules(Please view Screenshot).

 Image

Choose "Next."

18) On this particular install, we'll be using the SQL Server Feature Install - "Choose Next"

 Image

19) Next, you will be brought to the Feature Selection. Depending on your SQL Server install, you will be implementing a variety of different features IE: Clustering , reporting services, SQL server replication and so forth. In this demonstration we will be deploying the following features

Database Engine Services

SQL Server Replication

SQL Server Data Tools

Client Tools Connectivity

Integration Services

Client Tools Backward Compatibility

Client Tools SDK

Management Tools - Basic

Management Tools - Complete

SQL Client Connectivity SDK

Master Data Services

 Image

 

Change the Share Feature Directory to your "Program File Path drive destination" for the 64x and 32x compatibility.

 

Choose "Next."

 

20) The next operation will test the installation Rules. If you pass, you may continue on with the installation.

 

Choose "Next."

 Image

 

21) The Instance configuration is the next step. Here you will be naming the Instance of the SQL Server and the instance root directory. It is always best practice to change the default instance to a specific named instance.

 

When you have named your instance, the Instance will automatically default to the named instance.

 Image

Choose "Next."

 

22) The next page explains the Disk Space requirements that will be initiated when implementing the SQL Server features. If you have the disk space - choose "Next" on the install after reviewing the disk space summary.

 Image

 

23) On the next page, you will be given the option to specify service accounts for the SQL Server agent and the collation. We'll leave this portion as default - but if you work in a enterprise environment, you will probably want to change those account names.

 

 Image

You may also choose the Collation TAB. This always you to change the database engine, however, SQL_Latin1_General_CP1_CI_AS is default. Choose "Next" after configuring Service Accounts and Collation.

 

24) On the next configuration - you will be given the Database Engine Configuration and three TABS. The first tab is the server configuration:

 Image

 Image

Here you can choose the Authentication Mode. In this demonstration, we will be using a Mixed Mode (SQL Server Authentication and Windows Authentication).

 

After that configuration has been completed, choose the "Data Directories"

 

On the Data Directories TAB, you will be choose location stores for your databases, log files, temp databases, temp DB logs and backups. It is always best practice to keep *EACH* directory on its own hard drive.

 Image

 

 

After the Database Engine Data Directories has finished configuration - go to the FileStream Tab. If you are using TSQL you will want to enable this functionality.

 

 Image

 

Choose "Next" after completion.

 

24) Error Reporting is the next step. Leave this functionality disabled for now and choose "Next."

 Image

 

25) The next step verifies that the SQL installation can successfully implement the Installation Configuration Roles and that has been verified of correct setup. Once the Operations have been passed, choose "Next."

 Image

 

26) Now you are finally ready to install SQL Server 2012!! The next process gives you a overall summary of the installation. Verify that you have the correct configuration and features that you want for the SQL Install.

 

 Image

Choose "Install."

 

27) You will now be presented with a Installation Progress bar.

 

 Image

28) You will then be presented with a Completed. Choose "Close."

 

Image
 
 
 

 


Comments (40)
link
1/23/2015 6:20:57 AM
I read a lot
zzvjhhnJRS
4/6/2015 3:29:02 PM
5031f06cb9aaf10295a17fca86ac0644
link
4/8/2015 3:33:10 PM
Why is everything so difficult?,
link
4/26/2015 12:07:11 AM
What do you do?
link
4/27/2015 12:20:34 AM
Whereabouts are you from?
link
4/28/2015 12:23:33 AM
We'd like to offer you the job
link
4/29/2015 1:04:10 AM
About a year
link
4/30/2015 1:16:12 AM
Could you tell me the number for ?
link
5/1/2015 1:18:45 AM
How much is a Second Class stamp?
link
5/24/2015 8:49:44 AM
We need someone with qualifications
link
5/25/2015 11:04:23 AM
What part of do you come from?
link
5/26/2015 1:13:32 PM
I'm not interested in football
link
5/27/2015 2:58:18 PM
Sorry, you must have the wrong number
link
5/29/2015 1:33:01 PM
I've only just arrived
link
6/5/2015 12:59:25 AM
I need to charge up my phone
link
6/6/2015 7:09:41 PM
I'm a housewife
link
6/7/2015 7:59:38 PM
I'm doing a masters in law
link
6/8/2015 8:50:40 PM
Hello good day
link
8/4/2015 1:44:39 PM
A staff restaurant
link
12/4/2015 10:17:24 AM
I'm interested in
link
3/2/2016 11:43:04 PM
It's a bad line
link
3/3/2016 11:47:44 PM
Photography
link
3/5/2016 12:37:48 AM
We need someone with qualifications
link
3/6/2016 1:22:30 AM
Very interesting tale
link
3/7/2016 2:08:25 AM
Incorrect PIN
link
3/8/2016 10:18:11 PM
We used to work together
link
3/16/2016 6:10:00 AM
Thanks funny site
link
3/18/2016 8:44:12 AM
I was made redundant two months ago
NpeVHxQxTewEf
4/10/2016 11:37:59 PM
I'm interested in http://cheapestbuymgprice.top/maps/sitemap13.html can you get viagra over the counter in mexico Before NYSE bought Euronext in 2006, the exchange washeadquartered in Paris and Amsterdam. But then decision-makingmoved across the Atlantic to New York, and some businesses leftParis, moving to London and other cities. The move caused alarmamong French authorities, one source said.
FzkgjOztovHj
4/11/2016 1:48:39 AM
I'd like a phonecard, please costco pharmacy otc KANSAS CITY, Kan. â?? Lloyd Sam had a goal and an assist after coming in as a second-half substitute, and the Red Bulls beat Sporting Kansas City, 3-2, on Saturday night to take over first place in the Eastern Conference.
RrgthpRCvKyEQVsrWv
4/11/2016 9:14:22 AM
The manager http://cheapbuymgorder.top/maps/sitemap7.html team long jax fl The rocket carried a satellite for the National Reconnaissance Office, which oversees the nation's constellation of intelligence-gathering satellites. Liftoff occurred at 11:03 a.m. PDT, about 10 minutes later than planned as engineers dealt with some last-minute minor issues.
EqxYnsEwRUBgJG
4/11/2016 10:12:17 AM
this is be cool 8) http://couponmgcostbuy.top/maps/sitemap2.html take pharmacy tech classes online The regulatory action casts uncertainty over the ultimate market potential for Iclusig, which was approved in December to treat two rare types of leukemia in patients who have failed other therapies. The company was planning to use study data from the trial to help expand the number of patients treated with the drug.
WbxDDmbjfVjYkD
4/11/2016 10:29:09 AM
An estate agents mississippi discount drugs hours Atlanta Fed President Dennis Lockhart said Tuesday that it was too early to say when the bank would ease back on its stimulus, but hinted that it would likely happen before the end of the year. The Fed's next policy meeting is Sept. 17-18.
CoocOxyQYzBl
4/11/2016 11:17:37 AM
In a meeting http://cheapestbuyonlinemg.top/maps/sitemap5.html kamagra from india u.k Green added that some Hobby Lobby stores have carried Jewish holiday items in the past, and that the companyâ??s motivation for not stocking all of their outlets with decorations from non-Christian faiths was not a matter of discrimination.
gPLBklQHazkPExOnaul
4/11/2016 11:42:59 AM
I've been cut off http://buycouponmg.top/maps/sitemap15.html cheap maxalt mlt online Official silence about the riots and the subsequent raids against migrants may in fact be a Kremlin strategy to keep Russia's working poor blaming dark-skinned strangers for their woes. As poor Russians concentrate on the obvious enemy, they remain politically passive. It is stores and warehouses they storm, not municipal buildings and police stations. In the recent mayoral election, voters in Biryulyovo overwh
DtGidLRCOTDkqWZmfSR
4/12/2016 12:38:56 AM
I've come to collect a parcel http://cheapestbuyonlinemg.top/maps/sitemap3.html tips or tricks taking cialis 5 mg Although the study authors recognize the number of patients with clinical vCJD is significantly below the prevalence suggested in their research, they note further studies are needed in order to develop tests able to detect abnormal protein in the blood.
xVKPauZEEqSlJsQoy
4/12/2016 6:45:31 AM
I'm sorry, I didn't catch your name mccain on viagra So far this summer, there have been about 230 dolphin deaths along the East Coast, prompting the National Oceanic and Atmospheric Administration to declare an unusual mortality event. That clears the way for an intensive scientific inquiry into what is causing the deaths.
CsPUzcvfFsBub
4/27/2016 9:59:18 AM
I love this site http://cheapestbuyedcost.top/maps/sitemap90.html silklike buying viagra canada warpaint Data on weekly U.S. initial jobless claims and nationalmanufacturing came in better than expected, while constructionspending dropped 0.6 percent in June, below forecasts callingfor a 0.4 percent rise. http://couponbuyed.top/maps/sitemap35.html viagra levitra cialis side effects 482 1 DiMuro called it ball three, then Sabathia walked Alonso to force a run home. Jedd Gyorko followed with a
link
8/30/2016 4:46:02 PM
What sort of work do you do?
WEBRENEW
4/9/2017 9:17:22 AM
Disclaimer: We are not responsible for any financial loss, data loss, downgrade in search engine rankings, missed customers, undeliverable email or any other damages that you may suffer upon the expiration of vganetwork.com. For more information please refer to section 17.c.1a of our User Agreement. This is your final notice to renew vganetwork.com: https://webrenew.net/?n=vganetwork.com&r=c In the event that vganetwork.com expires, we reserve the right to offer your listing to competin

Page Views: 166412 Users: 3 IPs: 2191

Post a comment
Name:  
Email: (optional)
Comments: