Which SQL Server 2012 version is required to install on a Windows 2012 R2 SIMS Srvr

[genesis]

Snap shot Microsoft Volume licensing portal.docxHi

I have SIMS running on Windows 2003 server at the moment andplanning to Install a new Windows 2012server and install SQL server 2012 and migrate the database to the new Window2012 server. I have access to the Microsoft volume licensing portal and thereare many SQL versions listed (Please see the attached snap shot of MicrosoftVolume licensing portal).

and Please suggest me the right version that needs to beinstalled.

Many thanks

Any help much appreciated

Edited June 25, 2014 by genesis

[synaesthesia]

You need to use whichever version you are licensed for; best person to ask is your licensing provider/reseller.

[genesis]

We are a secondary school and I can download any version that I want from the portal and later I can ask my reseller the pricings for the version that I go for. So I need know the right version to download and install.

[matt40k]

Don't. Use the Capita installer, it installs Express, which is free. This will mean you won't end up with large bill from Microsoft and added complexity come install time. The school will need to purchase a SQL 2012 Standard license, if they need it, see - Should I purchase Full SQL or is Express enough? – Matt Smith. If they do need it, then download the ISO, mount it, then select the upgrade edition, it's a 5 min job.

[Marshall_IT]

How do SLG and InTouch affect that choice?

 

We'll end up with both plus room bookings and our VLE linking into the system eventually. These all make database calls so should have an impact. I know InTouch can be especially resource intensive.

[matt40k]

Not sure about InTouch beyond it needs more RAM on the clients. Personally I prefer SchoolComms which isn't as hungry.

 

SLG, self-hosted, you need a separate server \ SQL server.