SQL Server 2012 and SQL Server 2017 together

  • Hi.  I have a situation where I need to run SQL Server 2017 and SQL Server 2012 side by side for a time. According to Microsoft, the two can run side by side without issue.  I see that seems to be true because each has their own installation directory ...\110\... and ...\140\...

    The question I have is the order that the two should appear in the Windows and PowerShell path.  If 2012 is installed first then its directory structure would appear first in the path. That seems to mean that PowerShell Agent jobs that use SQLPS will pick the 2012 version instead of the 2017 version. v1 vs. v14.

    Do I need to be concerned?

  • You don't have an option to install 2017 first. Because it won't allow you to install a lower version of SQL Server. The most recent version of shared tools should be used. So I think it will be one from 2017 but I can't guarantee that because I haven't tried this. Try this in some isolated environment before introducing in production.

  • This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply