Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL instalation

Posted on 2014-12-11
5
Medium Priority
?
112 Views
Last Modified: 2014-12-12
Hi!
Will I face any problems when installing a 2012 SQL Standard instance on a server that is already running a 2014 SQL Standard instance?
0
Comment
Question by:elit2007
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 5

Expert Comment

by:Dejan Vasiljevic
ID: 40493663
Hi elit2007,

SQL Server SysPrep does not support side by side installation of prepared instances of SQL Server 2014 with earlier versions of SQL Server on the same computer. For example, you cannot prepare a SQL Server 2014 instance side by side with a prepared instance of SQL Server 2012. However, you can install multiple prepared instances of the same major version of SQL Server side by side on the same computer. For more information, see Considerations for Installing SQL Server Using SysPrep .

SQL Server 2014 cannot be installed side-by-side with earlier versions of SQL Server on a computer that is running Windows Server 2008 R2 Server Core SP1. For more information on Server Core installations, see Install SQL Server 2014 on Server Core .

From official MSDN
Also, I saw Exsisting Instance of SQL Server 2014 support Side-by-side 2005 to 2014 both 32/64 bits. But I guess You will need to define major version and minor version.
All in all, i think You will be able to configure them without any major problem, just pay attention to those things. *SysPrep

Thanks,
D.
0
 
LVL 1

Author Comment

by:elit2007
ID: 40493713
The OS on the server is 2012. So it shouldn't be a problem as long as i run a manually installation?
My concern was shared files. If SQL 2012 overwrite files that SQL 2014 already is using.
0
 
LVL 5

Accepted Solution

by:
Dejan Vasiljevic earned 2000 total points
ID: 40493741
I would backup files, which I always do before doing such an important thing, so if anything goes wrong, You always have Your files backed up. I think the OS is not a problem at all, everything after 2008 R2 should be just fine.

And for Your concerns about shared SQL files there is an article saying - "Certain components are shared by all instances of all installed versions of SQL Server. When you install different versions of SQL Server side-by-side on the same machine, these components are automatically upgraded to the latest version. Such components are usually uninstalled automatically when the last instance of SQL Server is uninstalled.
Examples: SQL Server Browser and Microsoft SQL Server VSS Writer.
"
MSDN is source again
Also You can change the default path, and etc.

Thanks,
D.
0
 
LVL 1

Author Comment

by:elit2007
ID: 40495585
Thanks a lot! I just have to hope that when I install SQL 2012, the installation program will see that the shared files have a newer version and not overwrite them.  :)
0
 
LVL 5

Expert Comment

by:Dejan Vasiljevic
ID: 40495640
You are welcome. As what we saw from microsoft official site, it should not overwrite them, because they are newer than SQL 2012 shared files, but again to make yourself secured, backup files before start.

Regards,
D.
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

662 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question