I have a question about licensing and hope there are MS Licensing experts around.
I have (or am planning to have) the following setup, all servers are VPS:
1 MS Windows 2008R2 webserver hosting mainly 1 website (ecommerce)
1 MS Windows 2008R2 server with SQL Server standard (2008 or 2012)
Currently only the webserver is active with on the same server SQL express 2008.
The performance of SQL server is not sufficient anymore so I want a separate server for it with more memory.
The only function the SQL server will provide is as a database for the website with occasional use of Management Studio on the SQL server itself.
The question is which version of MS SQL server should I buy and how many Cals will I need.