SQL Server 2012 with SP1 Installation Step by Step Guide – Saving System Admins, DBAs, Developers and Support Technicians A Wee Bit O’ Misery

Hugo-Shebbeare, 2013-01-11

Since the last guide was quite popular (over 4k distinct views for SQL Server 2008 R2), I’ve uploaded to SkyDrive another complete step by step guide for a Microsoft SQL Server installation. This time the Guide is for a SQL Server 2012 with Service Pack 1 installation, because I prefer to see this done correctly, rather than butchered ๐Ÿ™‚
I hope it helps save some time for those dealing with this vast task, including how to install a service pack and where to find the latest downloads. Furthermore, I have incorporated post-installation settings and validation, thus as Robert Davis states, you can ‘put a better SQL Server into Production.’
Here is the Guide also in an Embedded Version ( with an alternate download on my servers if you do not have access ot SkyDrive):



Enjoy, comments to improve are welcome ๐Ÿ™‚

If you cannot see the above embedded document, or access SkyDrive from your workplace, simply reload the page from home.

PS – update regarding Service Accounts (from the SQL 2012 Security Best Practices White Paper):

Service Account Selection and Management



SQL Server 2012 executes as a set of Windows services. Each service can be configured to use its own service account. This facility is exposed at installation. SQL Server provides a special tool, SQL Server Configuration Manager, to manage these accounts. In addition, these accounts can be set programmatically through the SQL Server WMI Provider for Configuration Management. When you select a Windows account to be a SQL Server service account, you have a choice of:

ยท Virtual Service account (new in SQL Server 2012)

ยท Managed Service account (new in SQL Server 2012)

ยท Domain user that is not a Windows administrator

ยท Local user that is not a Windows administrator

ยท Network Service account

ยท Local System account

ยท Local user that is a Windows administrator

ยท Domain user that is a Windows administrator

When choosing service accounts, consider the principle of least privilege. The service account should have exactly the privileges that it needs to do its job and no more privileges. You also need to consider account isolation; the service accounts should not only be different from one another, they should not be used by any other service on the same server. Only the first four account types in the list above (and Network Service account when running on Windows Server 2008 and above operating systems) have both of these properties. Making the SQL Server service account an administrator, at either a server level or a domain level, or using Local System, bestows too many unneeded privileges.

Rate

โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜…

Share

Share

Rate

โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜…

Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜…

Robert Davis

2009-02-23

1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜…

Andy Warren

2009-02-17

1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜… โ˜…

Andy Warren

2009-02-13

360 reads