October 6, 2014 at 3:09 pm
hi all.
Have a question regarding the ability/conflicts of installing different editions onto a windows 7 system.
the system is already running sql server 3.5 compact as well as mySql 5.1
the program that i created is needing to run with sql server 2008r2.
this would be an install that would not require any remote access as it is a local database - only reading and writing to the machine i install my program on.
can anyone tell me if im gonna run into trouble doing this? or if there is anything that i need to do to successfully install ?
thank you
October 7, 2014 at 12:15 am
You can install multiple versions on the same computer. Best practice is to first install the older version (you say you have already SQL Compact) and then continue with the newer version (in your case SQL 2008R2).
During the installation of the newer version you have the option to upgrade or a new install. Choose for new installation. Because you will have multiple instances on the computer you must use named instances. Only one default instance is allowed on one computer.
October 7, 2014 at 12:43 am
HanShi (10/7/2014)
You can install multiple versions on the same computer. Best practice is to first install the older version (you say you have already SQL Compact) and then continue with the newer version (in your case SQL 2008R2).During the installation of the newer version you have the option to upgrade or a new install. Choose for new installation. Because you will have multiple instances on the computer you must use named instances. Only one default instance is allowed on one computer.
+1 there should be no issues when installing multiple instances of SQL Server on one machine.
Currently I have SQL Server 2012 and 2014 side by side.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 7, 2014 at 4:01 pm
awesome :), thank you for the time and the advise!
it made the whole installation process a bit less nerve racking!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply