Features on SQL Server 2014 SP2 Standard on Windows Server 2012 R2

Question

Hi,

I hope this is the correct forum.

I have created a VM using the template "SQL Server 2014 SP2 Standard on Windows Server 2012 R2"

I get the following error (please note "SQL 2008") when I use "SQL Server Installation Center":

I need to know the following:

• What are the installed features. (integration services, reporting services, database engine, etc)
• How to add new features
• How to remove installed features

Thanks in advance!

Answer 1

If you choose to install VM with SQL Server, SQL Server is already installed. You don't have to run Installation centar, it's already there.

All features that are supported by SQL Server 2014 Standard Edition are installed.

https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

Or go check SQL Server Configuration Manager, all SQL services are listed there.

You can use Control Panel(Programs and features) to remove features(or just disable service). No need to add anything as everything is already there.

---

Mustafa Toroman, Azure MVP

Answer 2

Thanks Mustafa for your response.

If today I remove i.e reporting services, and I need it again after a couple of months,

Do I need to copy the correct media of SQL Server to the VM to install the removed feature?

Thanks.

Answer 3

Yeah, you would need media. Good thing is that you can download it very fast on Azure VM and it's free as you don't pay for inbound data.

---

Mustafa Toroman, Azure MVP