November 14, 2014 at 6:42 am
I am setting up a consolidated server and plan to install instances of SQL 2014, SQL 2012 and SQL 2008 R2 to support enterprise applications.
What is best practice for order of installation:
A) newest to oldest edition
B) oldest to newest edition
C) it doesn't matter
November 14, 2014 at 7:21 am
In the past it was you had to install oldest to newest in the SQL 7,2000, 2005 versions. I have not heard anything about the three newer versions but my guess is oldest to newest is the best way. Maybe someone else has done this.
November 19, 2014 at 9:49 am
I am not sure why it would make a difference? I would install newest to oldest, installing the newest instance and all of the tools, then just the instances for the older versions. Using the newer tools for all instances.
But not tried it so would like to know why this is not possible if its not?
November 20, 2014 at 10:32 am
Since we have other servers to host SQL2008 R2, our plan is to install newest to oldest and try to omit 2008 R2 from these 2 platforms. We had a bit of a hiccup with what OS to install. Initially we requested Windows 2012, but after using the interface, we decided to request Windows 2012 R2. This has caused a delay with storage allocations and installing the SQL instances.
November 20, 2014 at 10:40 am
I have done it both ways. It works fine for the database engine. I have seen some issues come about with the install of SSMS and that was only the 2014 SSMS install. You can get around that by leaving the tools off and only installing the 2014 tools at the end of all of the installs.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 20, 2014 at 10:52 am
SQLRNNR - can you please clarify what issues you saw with multiple editions installed? We would typically install tools for every version so we can use the appropriate tool with the same version. In this case, we plan to install SQL 2014 (2 instances), then SQL 2012 (6 instances) and then during the last installation, add the tools for each version.
November 20, 2014 at 11:08 am
The issues I have seen boil down to the tools not launching after the 2014 tools were installed. This persisted until the removal of the 2014 tools.
I'm not really seeing the gain of having different tools for each edition installed. The tools for 2014 will work for all of the editions you specified.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 20, 2014 at 11:13 am
Ok, we are probably going to install the 2014 tools only. Thanks!
November 20, 2014 at 11:15 am
You are welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply